[Home] [Help]
714: --
715: /* Find the min effective date so that we know
716: which entries to reprocess for
717: */
718: select /*+ INDEX(ppe PAY_PROCESS_EVENTS_N3) use_nl(ppe peu pdt)
719: ORDERED */
720: min(decode(peu.event_type,
721: 'U', decode(peu.column_name,
722: pdt.end_date_name, ppe.effective_date +1,
724: ),
725: ppe.effective_date)
726: )
727: into l_min_eff_date
728: from pay_process_events ppe,
729: pay_event_updates peu,
730: pay_dated_tables pdt
731: where ppe.assignment_id = p_assignment_id
732: and ppe.creation_date between p_min_creation_date
733: and p_time_processing_started
734: and peu.event_update_id = ppe.event_update_id
735: and peu.dated_table_id = pdt.dated_table_id;
736: --
737: select /*+ INDEX(ppe PAY_PROCESS_EVENTS_N3) use_nl(ppe peu pdt)
738: ORDERED */
739: min(decode(peu.event_type,
740: 'U', decode(peu.column_name,
741: pdt.end_date_name, ppe.effective_date +1,
743: ),
744: ppe.effective_date)
745: )
746: into l_min_grp_eff_date
747: from pay_process_events ppe,
748: pay_event_updates peu,
749: pay_dated_tables pdt
750: where ppe.assignment_id is null
751: and ppe.creation_date between p_min_creation_date
1251: */
1252: if (l_min_creation_date = hr_api.g_sot) then
1253: select min(creation_date)
1254: into l_min_creation_date
1255: from pay_process_events
1256: where assignment_id = p_assignment_id
1257: and nvl(retroactive_status, 'P') <> 'C';
1258: end if;
1259: --
1357: p_end_date in date,
1358: p_rownum in number)
1359: is
1360: SELECT distinct assignment_id asg
1361: FROM pay_process_events ppe
1362: WHERE business_group_id = p_bg_id
1363: and assignment_id = nvl(p_asg_id, assignment_id)
1364: and creation_date between p_start_date
1365: and p_end_date