eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_EVENT_CAPTURE dependencies on PAY_PROCESS_EVENTS

Line 2983: -- that have had events in the pay_process_events table, since the last

2979: -- This is the normal execution path when the process is run correctly
2980: -- after a full refresh.
2981: --
2982: -- Generate a SQL statement that SELECTs all of the DISTINCT assignments
2983: -- that have had events in the pay_process_events table, since the last
2984: -- incremental refresh.
2985: --
2986: -- 3703498 Added restriction so that only assignments with changes that are
2987: -- being tracked in the event group are processed

Line 2992: FROM pay_process_events ppe

2988: --
2989: p_sqlstr :=
2990: 'SELECT /*+ parallel(ppe , default, default) */ DISTINCT
2991: ppe.assignment_id object_id
2992: FROM pay_process_events ppe
2993: WHERE ppe.creation_date
2994: BETWEEN to_date('''
2995: || to_char(g_capture_from_date, 'DD-MON-YYYY HH24:MI:SS')
2996: || ''',''DD-MON-YYYY HH24:MI:SS'')

Line 3088: FROM pay_process_events ppe

3084: -- Cursor to get the assignment_id for assignment action for full refresh
3085: --
3086: CURSOR c_asg_to_process IS
3087: SELECT DISTINCT ppe.assignment_id
3088: FROM pay_process_events ppe
3089: WHERE assignment_id between p_start_object_id and p_end_object_id
3090: AND ppe.creation_date BETWEEN g_capture_from_date and g_end_of_time
3091: AND EXISTS (SELECT distinct event_update_id
3092: FROM pay_datetracked_events pde,