APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT

Line 381: ,ben_ext_rslt rslt

377:
378: CURSOR csr_last_run_details IS
379: SELECT MAX(TRUNC(rslt.eff_dt)) -- highest effective date of all prev runs
380: FROM pqp_extract_attributes pqea
381: ,ben_ext_rslt rslt
382: ,ben_ext_rslt_dtl rdtl
383: ,ben_ext_rcd drcd
384: WHERE pqea.ext_dfn_type = g_extract_type
385: AND rslt.ext_dfn_id = pqea.ext_dfn_id

Line 382: ,ben_ext_rslt_dtl rdtl

378: CURSOR csr_last_run_details IS
379: SELECT MAX(TRUNC(rslt.eff_dt)) -- highest effective date of all prev runs
380: FROM pqp_extract_attributes pqea
381: ,ben_ext_rslt rslt
382: ,ben_ext_rslt_dtl rdtl
383: ,ben_ext_rcd drcd
384: WHERE pqea.ext_dfn_type = g_extract_type
385: AND rslt.ext_dfn_id = pqea.ext_dfn_id
386: AND rslt.business_group_id = g_business_group_id

Line 417: ,ben_ext_rslt rslt

413:
414: CURSOR csr_next_run_details IS
415: SELECT MIN(TRUNC(rslt.eff_dt)) -- least effective date of all future runs
416: FROM pqp_extract_attributes pqea
417: ,ben_ext_rslt rslt
418: ,ben_ext_rslt_dtl rdtl
419: ,ben_ext_rcd drcd
420: WHERE pqea.ext_dfn_type = g_extract_type
421: AND rslt.ext_dfn_id = pqea.ext_dfn_id

Line 418: ,ben_ext_rslt_dtl rdtl

414: CURSOR csr_next_run_details IS
415: SELECT MIN(TRUNC(rslt.eff_dt)) -- least effective date of all future runs
416: FROM pqp_extract_attributes pqea
417: ,ben_ext_rslt rslt
418: ,ben_ext_rslt_dtl rdtl
419: ,ben_ext_rcd drcd
420: WHERE pqea.ext_dfn_type = g_extract_type
421: AND rslt.ext_dfn_id = pqea.ext_dfn_id
422: AND rslt.business_group_id = g_business_group_id

Line 3281: FROM ben_ext_rslt_dtl dtl

3277: CURSOR count_extract_details
3278: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
3279: IS
3280: SELECT COUNT(*)
3281: FROM ben_ext_rslt_dtl dtl
3282: --,ben_ext_rcd rcd
3283: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
3284: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3285: --AND rcd.rcd_type_cd = 'D'