APPS.PQP_GB_TP_EXT_PROCESS dependencies on BEN_EXT_RCD

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 192: ,ben_ext_rcd rcd

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';
196:

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';

Line 204: ,ben_ext_rcd rcd

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';
208: --

Line 509: FROM ben_ext_rcd

505:
506: CURSOR csr_get_ext_rcd_ht (c_ext_rcd_id NUMBER)
507: IS
508: SELECT rcd_type_cd
509: FROM ben_ext_rcd
510: WHERE ext_rcd_id = c_ext_rcd_id;
511:
512: l_ext_rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE;
513:

Line 512: l_ext_rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE;

508: SELECT rcd_type_cd
509: FROM ben_ext_rcd
510: WHERE ext_rcd_id = c_ext_rcd_id;
511:
512: l_ext_rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE;
513:
514: --
515: -- Cursor to get extract result information
516: --

Line 1073: AND EXISTS ( SELECT 1 FROM ben_ext_rcd rcd

1069: UPDATE ben_ext_rslt_dtl rslt
1070: SET val_02 = l_val_02
1071: ,val_03 = l_val_03
1072: WHERE ext_rslt_id = l_master_ext_rslt_id
1073: AND EXISTS ( SELECT 1 FROM ben_ext_rcd rcd
1074: WHERE rcd.ext_rcd_id = rslt.ext_rcd_id
1075: AND rcd.rcd_type_cd = 'T'
1076: );
1077: --