APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 4646: ,ben_ext_rcd drcd

4642: SELECT 'Y'
4643: FROM pqp_extract_attributes pqea
4644: ,ben_ext_rslt rslt
4645: ,ben_ext_rslt_dtl rdtl
4646: ,ben_ext_rcd drcd
4647: WHERE pqea.ext_dfn_type = g_extract_type
4648: AND rslt.ext_dfn_id = pqea.ext_dfn_id
4649: -- Bugfix 3073562:GAP1:GAP2, now using master bg id
4650: AND rslt.business_group_id = g_master_bg_id

Line 4673: FROM ben_ext_rcd drcd1

4669: FROM ben_ext_rslt_dtl rdtl1
4670: WHERE rdtl1.business_group_id = g_master_bg_id
4671: AND EXISTS
4672: ( SELECT 'Y'
4673: FROM ben_ext_rcd drcd1
4674: WHERE drcd1.rcd_type_cd = 'H'
4675: AND drcd1.ext_rcd_id = rdtl1.ext_rcd_id
4676: )
4677: AND rdtl.ext_rslt_id = rdtl1.ext_rslt_id

Line 16693: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

16689: PROCEDURE del_dummy_recs
16690: IS
16691:
16692: -- Variable Declaration
16693: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
16694:
16695: l_proc_name VARCHAR2(61):=
16696: g_proc_name||'del_dummy_recs';
16697: