[Home] [Help]
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
387: AND rslt.ext_stat_cd NOT IN
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
423: -- even failed future runs are to be considered
3271: IS
3272:
3273: l_proc_name VARCHAR2(61):= g_proc_name||'get_total_number_data_records';
3274:
3275: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3276:
3277: CURSOR count_extract_details
3278: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
3279: IS
3274:
3275: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3276:
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
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'
3286: AND dtl.ext_rcd_id = p_ext_rcd_id
3297:
3298: debug_enter(l_proc_name);
3299:
3300: -- 11.5.10_CU2: Performance fix :
3301: -- get the ben_ext_rcd.ext_rcd_id
3302: -- and use this one for next cursor
3303: -- This will prevent FTS on the table.
3304:
3305: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id