[Home] [Help]
605: pde.column_name column_name ,
606: pde.update_type update_type ,
607: pde.proration_style proration_type,
608: pdt.owner owner
609: FROM pay_datetracked_events pde,
610: pay_dated_tables pdt
611: WHERE pde.event_group_id = p_proration_group_id
612: AND pdt.dated_table_id = pde.dated_table_id
613: order by pdt.dated_table_id,pde.update_type; --ordering vital bug 3598389
3186: l_element_entry_id number;
3187:
3188: cursor get_update_type IS
3189: select update_type
3190: from pay_Datetracked_events
3191: where datetracked_event_id = p_datetracked_event;
3192:
3193: begin
3194: --
4984: and ppe.assignment_id = p_assignment_id
4985: and ppe.business_group_id = p_business_group_id
4986: and ppe.effective_date >= ben_ext_thread.g_effective_start_date
4987: and exists (select pde.event_group_id
4988: from pay_datetracked_events pde,
4989: pay_event_updates peu
4990: where pde.event_group_id in (select becv.val_1
4991: from ben_ext_crit_val becv,
4992: ben_ext_crit_typ bect,
5121: peu.event_update_id = ppe.event_update_id + 0
5122: AND peu.dated_table_id = pdt.dated_table_id
5123: AND pdt.dated_table_id IN
5124: ( select distinct pde2.dated_table_id table_id
5125: from pay_datetracked_events pde2
5126: where pde2.event_group_id = p_event_group_id
5127: and cp_bulk_processing = 'N'
5128: union all
5129: select distinct pdt2.dated_table_id
5180: peu.event_update_id = ppe.event_update_id + 0
5181: AND peu.dated_table_id = pdt.dated_table_id
5182: AND pdt.dated_table_id IN
5183: ( select distinct pde2.dated_table_id table_id
5184: from pay_datetracked_events pde2
5185: where pde2.event_group_id = p_event_group_id
5186: and cp_bulk_processing = 'N'
5187: union all
5188: select distinct pdt2.dated_table_id
5251: peu.event_update_id = ppe.event_update_id + 0
5252: AND peu.dated_table_id = pdt.dated_table_id
5253: AND pdt.dated_table_id IN
5254: ( select distinct pde2.dated_table_id table_id
5255: from pay_datetracked_events pde2
5256: where pde2.event_group_id = p_event_group_id
5257: and cp_bulk_processing = 'N'
5258: union all
5259: select distinct pdt2.dated_table_id
5312: peu.event_update_id = ppe.event_update_id + 0
5313: AND peu.dated_table_id = pdt.dated_table_id
5314: AND pdt.dated_table_id IN
5315: ( select distinct pde2.dated_table_id table_id
5316: from pay_datetracked_events pde2
5317: where pde2.event_group_id = p_event_group_id
5318: and cp_bulk_processing = 'N'
5319: union all
5320: select distinct pdt2.dated_table_id
5384: peu.event_update_id = ppe.event_update_id + 0
5385: AND peu.dated_table_id = pdt.dated_table_id
5386: AND pdt.dated_table_id IN
5387: ( select distinct pde2.dated_table_id table_id
5388: from pay_datetracked_events pde2
5389: where pde2.event_group_id = p_event_group_id
5390: and cp_bulk_processing = 'N'
5391: union all
5392: select distinct pdt2.dated_table_id
5473: --Added new condition to capture REPORTS events only
5474: AND ppe.change_type = 'REPORTS'
5475: AND pdt.dated_table_id IN
5476: ( select distinct pde2.dated_table_id table_id
5477: from pay_datetracked_events pde2
5478: where pde2.event_group_id = p_event_group_id
5479: and cp_bulk_processing = 'N'
5480: union all
5481: select distinct pdt2.dated_table_id
5550: --Added new condition to capture REPORTS events only
5551: AND ppe.change_type = 'REPORTS'
5552: AND pdt.dated_table_id IN
5553: ( select distinct pde2.dated_table_id table_id
5554: from pay_datetracked_events pde2
5555: where pde2.event_group_id = p_event_group_id
5556: and cp_bulk_processing = 'N'
5557: union all
5558: select distinct pdt2.dated_table_id
6491: SELECT DISTINCT pdt.dated_table_id table_id ,
6492: pdt.table_name table_name ,
6493: pde.column_name column_name ,
6494: pde.update_type update_type
6495: FROM pay_datetracked_events pde,
6496: pay_dated_tables pdt
6497: WHERE pde.event_group_id = p_filter_event_group_id
6498: AND pdt.dated_table_id = pde.dated_table_id
6499: order by pdt.dated_table_id;