APPS.PAY_EVENTS_WRAPPER dependencies on PAY_DATED_TABLES

Line 206: pay_dated_tables pdt

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
210: AND pde.column_name = peu.column_name

Line 244: pay_dated_tables pdt,

240: peu.dated_table_id,
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

Line 267: pay_dated_tables pdt,

263: peu.dated_table_id,
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

Line 292: FROM pay_dated_tables pdt,

288: --
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';

Line 1050: FROM pay_dated_tables

1046: -- Get the (special case) element entries table ID
1047: BEGIN
1048: SELECT dated_table_id
1049: INTO l_element_entries_dt_id
1050: FROM pay_dated_tables
1051: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F';
1052: EXCEPTION
1053: WHEN OTHERS THEN l_element_entries_dt_id := NULL;
1054: END;