GMY_COMMON_MST mst

            WHERE cost.import_folder_no=invheader.import_folder_no

            AND cost.billing_amt_num IS NOT NULL

            AND cost.billing_amt_num!=0

            AND cost.insur_db_cr!=0;

    BEGIN

        FOR rec_cost IN cur_cost LOOP

            BEGIN

                x_num_ret_value := GMY_GA000_PKG.CheckValidMasterBlNo(

                                p_i_job_id,

                                p_i_as_of_date_id,

                                rec_cost.import_folder_no,

                                x_vch_error_msg);

                IF x_num_ret_value = GMY_GA000_PKG.VALID_BL_NO THEN

                    INSERT INTO GMY_COST_INS_INF(

                        cost_trx_id,,

                        created_by,

                        program_name)

                    VALUES(

                        GMY_COST_INS_INF_S.NEXTVAL,

                        PRG_NAME,

                        PRG_NAME);

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9]  下一页