eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

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 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 3267: FROM ben_ext_rslt_dtl dtl

3263: CURSOR count_extract_details
3264: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
3265: IS
3266: SELECT COUNT(*)
3267: FROM ben_ext_rslt_dtl dtl
3268: --,ben_ext_rcd rcd
3269: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
3270: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3271: --AND rcd.rcd_type_cd = 'D'