APPS.HRI_OPL_EVENT_CAPTURE dependencies on PAY_EVENT_UPDATES

Line 2999: pay_event_updates peu

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 )
3003: ORDER BY ppe.assignment_id';

Line 3090: pay_event_updates peu

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 );
3094: --