APPS.HRI_OPL_EVENT_CAPTURE dependencies on PAY_DATETRACKED_EVENTS

Line 3001: FROM pay_datetracked_events pde,

2997: AND to_date('''
2998: || to_char(g_end_of_time, 'DD-MON-YYYY HH24:MI:SS')
2999: || ''',''DD-MON-YYYY HH24:MI:SS'')
3000: AND EXISTS (SELECT distinct event_update_id
3001: FROM pay_datetracked_events pde,
3002: pay_event_updates peu
3003: WHERE pde.event_group_id = '||g_master_event_group_id||'
3004: AND pde.dated_table_id = peu.dated_table_id
3005: AND ppe.event_update_id = peu.event_update_id )

Line 3092: FROM pay_datetracked_events pde,

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,
3093: pay_event_updates peu
3094: WHERE pde.event_group_id = g_master_event_group_id
3095: AND pde.dated_table_id = peu.dated_table_id
3096: AND ppe.event_update_id = peu.event_update_id );