APPS.PAY_EVENTS_WRAPPER dependencies on PAY_DATETRACKED_EVENTS

Line 183: FROM pay_datetracked_events pde

179: AND ppe.event_update_id = peu.event_update_id
180: AND substr(peu.event_type,1,1) in ('D','I','Z')
181: AND EXISTS (
182: SELECT 'X'
183: FROM pay_datetracked_events pde
184: WHERE pde.event_group_id = p_evt
185: AND pde.dated_table_id = peu.dated_table_id
186: AND pde.update_type = SUBSTR(DECODE(peu.event_type,'ZAP','D',peu.event_type),1,1)
187: )

Line 205: FROM pay_datetracked_events pde,

201: AND ppe.event_update_id = peu.event_update_id
202: AND substr(peu.event_type,1,1) IN ('U','C')
203: AND EXISTS (
204: SELECT 'X'
205: FROM pay_datetracked_events pde,
206: pay_dated_tables pdt
207: WHERE pde.event_group_id = p_evt
208: AND pde.dated_table_id = peu.dated_table_id
209: AND pdt.dated_table_id = pde.dated_table_id

Line 245: pay_datetracked_events pde

241: peu.column_name
242: FROM pay_process_events ppe,
243: pay_event_updates peu,
244: pay_dated_tables pdt,
245: pay_datetracked_events pde
246: WHERE INSTR(ppe.description,' -> ') > 0
247: AND SUBSTR(ppe.description,1,6) <> ''
248: AND peu.event_update_id = ppe.event_update_id
249: AND peu.dated_table_id = pdt.dated_table_id

Line 268: pay_datetracked_events pde

264: peu.column_name
265: FROM pay_process_events ppe,
266: pay_event_updates peu,
267: pay_dated_tables pdt,
268: pay_datetracked_events pde
269: WHERE INSTR(ppe.description,' -> ') > 0
270: AND SUBSTR(ppe.description,length(ppe.description)-5) <> ''
271: AND peu.event_update_id = ppe.event_update_id
272: AND peu.dated_table_id = pdt.dated_table_id

Line 293: pay_datetracked_events pde

289: -- Get a list of the tables that are in our event group
290: CURSOR csr_table_list(p_evt IN NUMBER) RETURN csr_return IS
291: SELECT DISTINCT pdt.dated_table_id,NULL,pdt.table_name,NULL,NULL
292: FROM pay_dated_tables pdt,
293: pay_datetracked_events pde
294: WHERE pde.dated_table_id = pdt.dated_table_id
295: AND pde.event_group_id = p_evt
296: AND pde.update_type = 'U';
297: --

Line 993: FROM pay_datetracked_events pde

989: --
990: -- Get a list of the columns that are in the event group and table
991: CURSOR get_columns(p_evt IN NUMBER,p_tab IN NUMBER) IS
992: SELECT column_name
993: FROM pay_datetracked_events pde
994: WHERE event_group_id = p_evt
995: AND dated_table_id = p_tab
996: AND update_type = 'U';
997: --