[Home] [Help]
4982: from pay_process_events ppe
4983: where trunc(ppe.creation_date) between p_lapp_date and p_end_date
4984: and ppe.assignment_id = p_assignment_id
4985: and ppe.business_group_id = p_business_group_id
4986: and ppe.effective_date >= ben_ext_thread.g_effective_start_date
4987: and exists (select pde.event_group_id
4988: from pay_datetracked_events pde,
4989: pay_event_updates peu
4990: where pde.event_group_id in (select becv.val_1
4992: ben_ext_crit_typ bect,
4993: ben_ext_dfn bed
4994: where becv.ext_crit_typ_id = bect.ext_crit_typ_id
4995: and bect.ext_crit_prfl_id = bed.ext_crit_prfl_id
4996: and bed.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
4997: and bect.crit_typ_cd = 'CPE')
4998: and ppe.event_update_id = peu.event_update_id
4999: and peu.dated_table_id = pde.dated_table_id);
5000:
5622: CURSOR csr_pen_get_lapp_date
5623: IS
5624: SELECT least(run_strt_dt,eff_dt) app_date
5625: FROM ben_ext_rslt
5626: WHERE ext_dfn_id = ben_ext_thread.g_ext_dfn_id
5627: AND business_group_id = p_business_group_id
5628: AND ext_stat_cd = 'A'
5629: ORDER BY app_date DESC;
5630:
5833:
5834: -- BUG 7525608 :End
5835:
5836: --bug 7443747:Start
5837: hr_utility.trace('ben_ext_thread.g_ext_dfn_id '||ben_ext_thread.g_ext_dfn_id);
5838: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);
5839:
5840: IF g_pen_collect_reports is null
5841: THEN
5838: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);
5839:
5840: IF g_pen_collect_reports is null
5841: THEN
5842: OPEN csr_get_pen_reports_exts(ben_ext_thread.g_ext_dfn_id);
5843: FETCH csr_get_pen_reports_exts INTO g_pen_collect_reports;
5844:
5845: IF csr_get_pen_reports_exts%notfound
5846: THEN