APPS.PQP_GB_TP_EXT_PROCESS dependencies on BEN_EXT_RCD_IN_FILE

Line 191: FROM ben_ext_rcd_in_file fil

187: --
188: CURSOR csr_get_hdr_cnt
189: IS
190: SELECT COUNT(*)
191: FROM ben_ext_rcd_in_file fil
192: ,ben_ext_rcd rcd
193: WHERE fil.ext_rcd_id = rcd.ext_rcd_id
194: AND fil.ext_file_id = p_ext_file_id
195: AND rcd.rcd_type_cd = 'H';

Line 203: FROM ben_ext_rcd_in_file fil

199: --
200: CURSOR csr_get_trl_cnt
201: IS
202: SELECT COUNT(*)
203: FROM ben_ext_rcd_in_file fil
204: ,ben_ext_rcd rcd
205: WHERE fil.ext_rcd_id = rcd.ext_rcd_id
206: AND fil.ext_file_id = p_ext_file_id
207: AND rcd.rcd_type_cd = 'T';