[Home] [Help]
162: peu.dated_table_id,
163: MIN(ppe.effective_date) effective_start_date,
164: MAX(ppe.effective_date) effective_end_date
165: FROM pay_process_events ppe,
166: pay_event_updates peu
167: WHERE ppe.creation_date BETWEEN p_st AND p_en
168: AND ppe.event_update_id = peu.event_update_id
169: GROUP BY ppe.assignment_id,ppe.surrogate_key, peu.dated_table_id
170: ORDER BY ppe.assignment_id, ppe.surrogate_key;
177: ppe.surrogate_key,
178: MIN(ppe.effective_date) start_date,
179: MAX(ppe.effective_date) end_date
180: FROM pay_process_events ppe,
181: pay_event_updates peu
182: WHERE ppe.creation_date BETWEEN p_st AND p_en
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 (
199: ppe.surrogate_key,
200: MIN(ppe.effective_date) start_date,
201: MAX(ppe.effective_date) end_date
202: FROM pay_process_events ppe,
203: pay_event_updates peu
204: WHERE ppe.creation_date BETWEEN p_st AND p_en
205: AND ppe.event_update_id = peu.event_update_id
206: AND substr(peu.event_type,1,1) IN ('U','C')
207: AND EXISTS (
243: ppe.assignment_id,
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) <> '
266: ppe.assignment_id,
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) <> '
1043: l_qry := l_qry ||') '||
1044: 'AND n.assignment_id IN ('||
1045: 'SELECT '||
1046: ' ppe.assignment_id '||
1047: ' FROM pay_process_events ppe,pay_event_updates peu '||
1048: ' WHERE ppe.creation_date BETWEEN :1 AND :2 '||
1049: ' AND peu.event_update_id = ppe.event_update_id '||
1050: ' AND peu.dated_table_id = '||p_dtid||
1051: ') '||