[Home] [Help]
158: peu.dated_table_id,
159: MIN(ppe.effective_date) effective_start_date,
160: MAX(ppe.effective_date) effective_end_date
161: FROM pay_process_events ppe,
162: pay_event_updates peu
163: WHERE ppe.creation_date BETWEEN p_st AND p_en
164: AND ppe.event_update_id = peu.event_update_id
165: GROUP BY ppe.assignment_id,ppe.surrogate_key, peu.dated_table_id
166: ORDER BY ppe.assignment_id, ppe.surrogate_key;
173: ppe.surrogate_key,
174: MIN(ppe.effective_date) start_date,
175: MAX(ppe.effective_date) end_date
176: FROM pay_process_events ppe,
177: pay_event_updates peu
178: WHERE ppe.creation_date BETWEEN p_st AND p_en
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 (
195: ppe.surrogate_key,
196: MIN(ppe.effective_date) start_date,
197: MAX(ppe.effective_date) end_date
198: FROM pay_process_events ppe,
199: pay_event_updates peu
200: WHERE ppe.creation_date BETWEEN p_st AND p_en
201: AND ppe.event_update_id = peu.event_update_id
202: AND substr(peu.event_type,1,1) IN ('U','C')
203: AND EXISTS (
239: ppe.assignment_id,
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) <> '
262: ppe.assignment_id,
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) <> '
1025: l_qry := l_qry ||') '||
1026: 'AND n.assignment_id IN ('||
1027: 'SELECT '||
1028: ' ppe.assignment_id '||
1029: ' FROM pay_process_events ppe,pay_event_updates peu '||
1030: ' WHERE ppe.creation_date BETWEEN :1 AND :2 '||
1031: ' AND peu.event_update_id = ppe.event_update_id '||
1032: ' AND peu.dated_table_id = '||p_dtid||
1033: ') '||