APPS.PAY_EVENTS_WRAPPER dependencies on PAY_DATETRACKED_EVENTS

Line 187: FROM pay_datetracked_events pde

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

Line 209: FROM pay_datetracked_events pde,

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

Line 249: pay_datetracked_events pde

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

Line 272: pay_datetracked_events pde

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

Line 297: pay_datetracked_events pde

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

Line 1011: FROM pay_datetracked_events pde

1007: --
1008: -- Get a list of the columns that are in the event group and table
1009: CURSOR get_columns(p_evt IN NUMBER,p_tab IN NUMBER) IS
1010: SELECT column_name
1011: FROM pay_datetracked_events pde
1012: WHERE event_group_id = p_evt
1013: AND dated_table_id = p_tab
1014: AND update_type = 'U';
1015: --