[Home] [Help]
722: --
723: /* Find the min effective date so that we know
724: which entries to reprocess for
725: */
726: select /*+ INDEX(ppe PAY_PROCESS_EVENTS_N3) use_nl(ppe peu pdt)
727: ORDERED */
728: min(decode(peu.event_type,
729: 'U', decode(peu.column_name,
730: pdt.end_date_name, ppe.effective_date +1,
732: ),
733: ppe.effective_date)
734: )
735: into l_min_eff_date
736: from pay_process_events ppe,
737: pay_event_updates peu,
738: pay_dated_tables pdt
739: where ppe.assignment_id = p_assignment_id
740: and ppe.creation_date between p_min_creation_date
741: and p_time_processing_started
742: and peu.event_update_id = ppe.event_update_id
743: and peu.dated_table_id = pdt.dated_table_id;
744: --
745: select /*+ INDEX(ppe PAY_PROCESS_EVENTS_N3) use_nl(ppe peu pdt)
746: ORDERED */
747: min(decode(peu.event_type,
748: 'U', decode(peu.column_name,
749: pdt.end_date_name, ppe.effective_date +1,
751: ),
752: ppe.effective_date)
753: )
754: into l_min_grp_eff_date
755: from pay_process_events ppe,
756: pay_event_updates peu,
757: pay_dated_tables pdt
758: where ppe.assignment_id is null
759: and ppe.creation_date between p_min_creation_date
1316: */
1317: if (l_min_creation_date = hr_api.g_sot) then
1318: select min(creation_date)
1319: into l_min_creation_date
1320: from pay_process_events
1321: where assignment_id = p_assignment_id
1322: and nvl(retroactive_status, 'P') <> 'C';
1323: end if;
1324: --
1422: p_end_date in date,
1423: p_rownum in number)
1424: is
1425: SELECT distinct assignment_id asg
1426: FROM pay_process_events ppe
1427: WHERE business_group_id = p_bg_id
1428: and assignment_id = nvl(p_asg_id, assignment_id)
1429: and creation_date between p_start_date
1430: and p_end_date