[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
3257: IS
3258:
3259: l_proc_name VARCHAR2(61):= g_proc_name||'get_total_number_data_records';
3260:
3261: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3262:
3263: CURSOR count_extract_details
3264: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
3265: IS
3260:
3261: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3262:
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
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'
3272: AND dtl.ext_rcd_id = p_ext_rcd_id
3283:
3284: debug_enter(l_proc_name);
3285:
3286: -- 11.5.10_CU2: Performance fix :
3287: -- get the ben_ext_rcd.ext_rcd_id
3288: -- and use this one for next cursor
3289: -- This will prevent FTS on the table.
3290:
3291: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id