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 2980: -- that have had events in the pay_process_events table, since the last

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

Line 2989: FROM pay_process_events ppe

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

Line 3085: FROM pay_process_events ppe

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