DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGF_GR_LOAD_FILE_T

Line 818: igf_gr_load_file_t

814: IS
815: SELECT
816: record_data
817: FROM
818: igf_gr_load_file_t
819: WHERE gldr_id = 1
820: AND record_data LIKE 'GRANT HDR%'
821: AND file_type = p_file_type;
822:

Line 831: igf_gr_load_file_t

827: SELECT
828: gldr_id last_gldr_id,
829: record_data
830: FROM
831: igf_gr_load_file_t
832: WHERE
833: gldr_id = (SELECT MAX(gldr_id) FROM igf_gr_load_file_t) AND
834: record_data LIKE 'GRANT TLR%' AND
835: file_type = p_file_type;

Line 833: gldr_id = (SELECT MAX(gldr_id) FROM igf_gr_load_file_t) AND

829: record_data
830: FROM
831: igf_gr_load_file_t
832: WHERE
833: gldr_id = (SELECT MAX(gldr_id) FROM igf_gr_load_file_t) AND
834: record_data LIKE 'GRANT TLR%' AND
835: file_type = p_file_type;
836:
837: trailer_rec cur_trailer%ROWTYPE;