APPS.PAY_INTERPRETER_PKG dependencies on PAY_DATETRACKED_EVENTS

Line 609: FROM pay_datetracked_events pde,

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

Line 3190: from pay_Datetracked_events

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: --

Line 4981: from pay_datetracked_events pde2

4977: peu.event_update_id = ppe.event_update_id + 0
4978: AND peu.dated_table_id = pdt.dated_table_id
4979: AND pdt.dated_table_id IN
4980: ( select distinct pde2.dated_table_id table_id
4981: from pay_datetracked_events pde2
4982: where pde2.event_group_id = p_event_group_id
4983: and cp_bulk_processing = 'N'
4984: union all
4985: select distinct pdt2.dated_table_id

Line 5040: from pay_datetracked_events pde2

5036: peu.event_update_id = ppe.event_update_id + 0
5037: AND peu.dated_table_id = pdt.dated_table_id
5038: AND pdt.dated_table_id IN
5039: ( select distinct pde2.dated_table_id table_id
5040: from pay_datetracked_events pde2
5041: where pde2.event_group_id = p_event_group_id
5042: and cp_bulk_processing = 'N'
5043: union all
5044: select distinct pdt2.dated_table_id

Line 5110: from pay_datetracked_events pde2

5106: peu.event_update_id = ppe.event_update_id + 0
5107: AND peu.dated_table_id = pdt.dated_table_id
5108: AND pdt.dated_table_id IN
5109: ( select distinct pde2.dated_table_id table_id
5110: from pay_datetracked_events pde2
5111: where pde2.event_group_id = p_event_group_id
5112: and cp_bulk_processing = 'N'
5113: union all
5114: select distinct pdt2.dated_table_id

Line 5171: from pay_datetracked_events pde2

5167: peu.event_update_id = ppe.event_update_id + 0
5168: AND peu.dated_table_id = pdt.dated_table_id
5169: AND pdt.dated_table_id IN
5170: ( select distinct pde2.dated_table_id table_id
5171: from pay_datetracked_events pde2
5172: where pde2.event_group_id = p_event_group_id
5173: and cp_bulk_processing = 'N'
5174: union all
5175: select distinct pdt2.dated_table_id

Line 5243: from pay_datetracked_events pde2

5239: peu.event_update_id = ppe.event_update_id + 0
5240: AND peu.dated_table_id = pdt.dated_table_id
5241: AND pdt.dated_table_id IN
5242: ( select distinct pde2.dated_table_id table_id
5243: from pay_datetracked_events pde2
5244: where pde2.event_group_id = p_event_group_id
5245: and cp_bulk_processing = 'N'
5246: union all
5247: select distinct pdt2.dated_table_id

Line 5330: from pay_datetracked_events pde2

5326: --Added new condition to capture REPORTS events only
5327: AND ppe.change_type = 'REPORTS'
5328: AND pdt.dated_table_id IN
5329: ( select distinct pde2.dated_table_id table_id
5330: from pay_datetracked_events pde2
5331: where pde2.event_group_id = p_event_group_id
5332: and cp_bulk_processing = 'N'
5333: union all
5334: select distinct pdt2.dated_table_id

Line 6146: FROM pay_datetracked_events pde,

6142: SELECT DISTINCT pdt.dated_table_id table_id ,
6143: pdt.table_name table_name ,
6144: pde.column_name column_name ,
6145: pde.update_type update_type
6146: FROM pay_datetracked_events pde,
6147: pay_dated_tables pdt
6148: WHERE pde.event_group_id = p_filter_event_group_id
6149: AND pdt.dated_table_id = pde.dated_table_id
6150: order by pdt.dated_table_id;