APPS.HRI_OPL_EVENT_CAPTURE dependencies on PAY_DATETRACKED_EVENTS

Line 2998: FROM pay_datetracked_events pde,

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

Line 3089: FROM pay_datetracked_events pde,

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