eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_INTERPRETER_PKG dependencies on PAY_DATED_TABLES

Line 610: pay_dated_tables pdt

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

Line 2332: pay_dated_tables b

2328: b.surrogate_key_name surrogate_key_name ,
2329: b.start_date_name start_date_name ,
2330: b.end_date_name end_date_name
2331: FROM pay_event_updates a ,
2332: pay_dated_tables b
2333: WHERE a.dated_table_id = b.dated_table_id;
2334:
2335: l_process_event_id pay_process_events.process_event_id%TYPE ;
2336: l_change_type1 pay_process_events.change_type%TYPE ;

Line 2346: l_table_name pay_dated_tables.table_name%TYPE ;

2342: l_table_id pay_event_updates.dated_table_id%TYPE ;
2343: l_column_name pay_event_updates.column_name%TYPE ;
2344: l_change_type2 pay_event_updates.change_type%TYPE ;
2345: l_event_type pay_event_updates.event_type%TYPE ;
2346: l_table_name pay_dated_tables.table_name%TYPE ;
2347: l_surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ;
2348: l_start_date_name pay_dated_tables.start_date_name%TYPE ;
2349: l_end_date_name pay_dated_tables.end_date_name%TYPE ;
2350: BEGIN

Line 2347: l_surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ;

2343: l_column_name pay_event_updates.column_name%TYPE ;
2344: l_change_type2 pay_event_updates.change_type%TYPE ;
2345: l_event_type pay_event_updates.event_type%TYPE ;
2346: l_table_name pay_dated_tables.table_name%TYPE ;
2347: l_surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ;
2348: l_start_date_name pay_dated_tables.start_date_name%TYPE ;
2349: l_end_date_name pay_dated_tables.end_date_name%TYPE ;
2350: BEGIN
2351: FOR caa IN c_ass_act_id

Line 2348: l_start_date_name pay_dated_tables.start_date_name%TYPE ;

2344: l_change_type2 pay_event_updates.change_type%TYPE ;
2345: l_event_type pay_event_updates.event_type%TYPE ;
2346: l_table_name pay_dated_tables.table_name%TYPE ;
2347: l_surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ;
2348: l_start_date_name pay_dated_tables.start_date_name%TYPE ;
2349: l_end_date_name pay_dated_tables.end_date_name%TYPE ;
2350: BEGIN
2351: FOR caa IN c_ass_act_id
2352: LOOP

Line 2349: l_end_date_name pay_dated_tables.end_date_name%TYPE ;

2345: l_event_type pay_event_updates.event_type%TYPE ;
2346: l_table_name pay_dated_tables.table_name%TYPE ;
2347: l_surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ;
2348: l_start_date_name pay_dated_tables.start_date_name%TYPE ;
2349: l_end_date_name pay_dated_tables.end_date_name%TYPE ;
2350: BEGIN
2351: FOR caa IN c_ass_act_id
2352: LOOP
2353: l_assignment_id := caa.assignment_id;

Line 2407: pay_dated_tables b

2403: p_end_col IN VARCHAR2) IS
2404: SELECT a.column_name column_name ,
2405: a.event_type event_type
2406: FROM pay_event_updates a,
2407: pay_dated_tables b
2408: WHERE a.dated_table_id = b.dated_table_id
2409: AND a.dated_table_id = p_table_id
2410: AND a.change_type = p_change_type
2411: AND a.column_name NOT IN (p_start_col, p_end_col)

Line 2427: FROM pay_dated_tables

2423: SELECT table_name ,
2424: surrogate_key_name ,
2425: start_date_name ,
2426: end_date_name
2427: FROM pay_dated_tables
2428: WHERE dated_table_id = p_table_id;
2429:
2430: l_counter NUMBER ;
2431: l_tab_count NUMBER ;

Line 3534: from pay_dated_tables pdt,

3530: if (l_effective_date = p_pro_evt_rec.effective_date) then
3531: --
3532: select count(*)
3533: into l_count
3534: from pay_dated_tables pdt,
3535: pay_event_updates peu,
3536: pay_process_events ppe
3537: where pdt.table_name = p_pro_evt_rec.table_name
3538: and pdt.dated_table_id = peu.dated_table_id

Line 4937: type t_table_name is table of pay_dated_tables.table_name%type

4933: type t_creation_date is table of pay_process_events.creation_date%type
4934: index by binary_integer;
4935: type t_change_type is table of pay_process_events.change_type%type
4936: index by binary_integer;
4937: type t_table_name is table of pay_dated_tables.table_name%type
4938: index by binary_integer;
4939: --
4940: l_column_name t_column_name;
4941: l_event_type t_event_type;

Line 4973: pay_dated_tables pdt ,

4969: ppe.creation_date creation_date,
4970: ppe.change_type change_mode,
4971: pdt.table_name table_name
4972: FROM
4973: pay_dated_tables pdt ,
4974: pay_process_events ppe ,
4975: pay_event_updates peu
4976: WHERE
4977: peu.event_update_id = ppe.event_update_id + 0

Line 4986: from pay_dated_tables pdt2

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
4986: from pay_dated_tables pdt2
4987: where cp_bulk_processing = 'Y'
4988: )
4989: AND ppe.assignment_id is not null
4990: AND ppe.assignment_id = p_assignment_id

Line 5032: pay_dated_tables pdt ,

5028: ppe.creation_date creation_date,
5029: ppe.change_type change_mode,
5030: pdt.table_name table_name
5031: FROM
5032: pay_dated_tables pdt ,
5033: pay_event_updates peu ,
5034: pay_process_events ppe
5035: WHERE
5036: peu.event_update_id = ppe.event_update_id + 0

Line 5045: from pay_dated_tables pdt2

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
5045: from pay_dated_tables pdt2
5046: where cp_bulk_processing = 'Y'
5047: )
5048: AND ppe.assignment_id is null
5049: AND ppe.business_group_id = p_business_group_id

Line 5102: pay_dated_tables pdt ,

5098: ppe.creation_date creation_date,
5099: ppe.change_type change_mode,
5100: pdt.table_name table_name
5101: FROM
5102: pay_dated_tables pdt ,
5103: pay_process_events ppe ,
5104: pay_event_updates peu
5105: WHERE
5106: peu.event_update_id = ppe.event_update_id + 0

Line 5115: from pay_dated_tables pdt2

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
5115: from pay_dated_tables pdt2
5116: where cp_bulk_processing = 'Y'
5117: )
5118: AND ppe.assignment_id is not null
5119: AND ppe.assignment_id = p_assignment_id

Line 5163: pay_dated_tables pdt ,

5159: ppe.creation_date creation_date,
5160: ppe.change_type change_mode,
5161: pdt.table_name table_name
5162: FROM
5163: pay_dated_tables pdt ,
5164: pay_event_updates peu ,
5165: pay_process_events ppe
5166: WHERE
5167: peu.event_update_id = ppe.event_update_id + 0

Line 5176: from pay_dated_tables pdt2

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
5176: from pay_dated_tables pdt2
5177: where cp_bulk_processing = 'Y'
5178: )
5179: AND ppe.assignment_id is null
5180: AND ppe.business_group_id = p_business_group_id

Line 5235: pay_dated_tables pdt ,

5231: ppe.creation_date creation_date,
5232: ppe.change_type change_mode,
5233: pdt.table_name table_name
5234: FROM
5235: pay_dated_tables pdt ,
5236: pay_process_events ppe ,
5237: pay_event_updates peu
5238: WHERE
5239: peu.event_update_id = ppe.event_update_id + 0

Line 5248: from pay_dated_tables pdt2

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
5248: from pay_dated_tables pdt2
5249: where cp_bulk_processing = 'Y'
5250: )
5251: AND ppe.assignment_id is not null
5252: AND ppe.assignment_id = p_assignment_id

Line 5320: pay_dated_tables pdt ,

5316: ppe.creation_date creation_date,
5317: ppe.change_type change_mode,
5318: pdt.table_name table_name
5319: FROM
5320: pay_dated_tables pdt ,
5321: pay_process_events ppe ,
5322: pay_event_updates peu
5323: WHERE
5324: peu.event_update_id = ppe.event_update_id + 0

Line 5335: from pay_dated_tables pdt2

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
5335: from pay_dated_tables pdt2
5336: where cp_bulk_processing = 'Y'
5337: )
5338: AND ppe.assignment_id is not null
5339: AND ppe.assignment_id = p_assignment_id

Line 6147: pay_dated_tables pdt

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