APPS.PAY_EVENTS_WRAPPER dependencies on PAY_DATED_TABLES

Line 210: pay_dated_tables pdt

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

Line 248: pay_dated_tables pdt,

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

Line 271: pay_dated_tables pdt,

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

Line 296: FROM pay_dated_tables pdt,

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

Line 1068: FROM pay_dated_tables

1064: -- Get the (special case) element entries table ID
1065: BEGIN
1066: SELECT dated_table_id
1067: INTO l_element_entries_dt_id
1068: FROM pay_dated_tables
1069: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F';
1070: EXCEPTION
1071: WHEN OTHERS THEN l_element_entries_dt_id := NULL;
1072: END;