APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 4674: ,ben_ext_rcd drcd

4670: SELECT 'Y'
4671: FROM pqp_extract_attributes pqea
4672: ,ben_ext_rslt rslt
4673: ,ben_ext_rslt_dtl rdtl
4674: ,ben_ext_rcd drcd
4675: WHERE pqea.ext_dfn_type = g_extract_type
4676: AND rslt.ext_dfn_id = pqea.ext_dfn_id
4677: -- Bugfix 3073562:GAP1:GAP2, now using master bg id
4678: AND rslt.business_group_id = g_master_bg_id

Line 4701: FROM ben_ext_rcd drcd1

4697: FROM ben_ext_rslt_dtl rdtl1
4698: WHERE rdtl1.business_group_id = g_master_bg_id
4699: AND EXISTS
4700: ( SELECT 'Y'
4701: FROM ben_ext_rcd drcd1
4702: WHERE drcd1.rcd_type_cd = 'H'
4703: AND drcd1.ext_rcd_id = rdtl1.ext_rcd_id
4704: )
4705: AND rdtl.ext_rslt_id = rdtl1.ext_rslt_id

Line 17062: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

17058: PROCEDURE del_dummy_recs
17059: IS
17060:
17061: -- Variable Declaration
17062: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
17063:
17064: l_proc_name VARCHAR2(61):=
17065: g_proc_name||'del_dummy_recs';
17066: