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_EVENT_UPDATES

Line 700: pay_event_updates peu

696:
697: SELECT count(*)
698: into insert_row
699: FROM pay_process_events ppe,
700: pay_event_updates peu
701: WHERE ppe.assignment_id=p_assignment_id
702: AND ppe.surrogate_key=p_surrogate_key
703: AND ppe.business_group_id=p_business_group_id
704: AND ppe.event_update_id=peu.event_update_id

Line 712: pay_event_updates peu

708:
709: SELECT count(*)
710: INTo upd_end_date
711: FROM pay_process_events ppe,
712: pay_event_updates peu
713: WHERE ppe.assignment_id=p_assignment_id
714: AND ppe.surrogate_key=p_surrogate_key
715: AND ppe.business_group_id=p_business_group_id
716: AND ppe.event_update_id=peu.event_update_id

Line 725: pay_event_updates peu

721:
722: SELECT count(*)
723: INTo upd_start_date
724: FROM pay_process_events ppe,
725: pay_event_updates peu
726: WHERE ppe.assignment_id=p_assignment_id
727: AND ppe.surrogate_key=p_surrogate_key
728: AND ppe.business_group_id=p_business_group_id
729: AND ppe.event_update_id=peu.event_update_id

Line 2331: FROM pay_event_updates a ,

2327: b.table_name table_name ,
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 ;

Line 2341: l_event_update_id pay_event_updates.event_update_id%TYPE ;

2337: l_assignment_id pay_process_events.assignment_id%TYPE ;
2338: l_surrogate_key pay_process_events.surrogate_key%TYPE ;
2339: l_effective_date pay_process_events.effective_date%TYPE ;
2340:
2341: l_event_update_id pay_event_updates.event_update_id%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 ;

Line 2342: l_table_id pay_event_updates.dated_table_id%TYPE ;

2338: l_surrogate_key pay_process_events.surrogate_key%TYPE ;
2339: l_effective_date pay_process_events.effective_date%TYPE ;
2340:
2341: l_event_update_id pay_event_updates.event_update_id%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 ;

Line 2343: l_column_name pay_event_updates.column_name%TYPE ;

2339: l_effective_date pay_process_events.effective_date%TYPE ;
2340:
2341: l_event_update_id pay_event_updates.event_update_id%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 ;

Line 2344: l_change_type2 pay_event_updates.change_type%TYPE ;

2340:
2341: l_event_update_id pay_event_updates.event_update_id%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 ;

Line 2345: l_event_type pay_event_updates.event_type%TYPE ;

2341: l_event_update_id pay_event_updates.event_update_id%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 ;

Line 2396: FROM pay_event_updates a

2392: p_change_type IN VARCHAR2 ) IS
2393: SELECT a.dated_table_id table_id ,
2394: a.column_name column_name ,
2395: a.event_type event_type
2396: FROM pay_event_updates a
2397: WHERE a.event_update_id = p_event_update_id
2398: AND a.change_type = p_change_type ;
2399:
2400: CURSOR c_event_tables(p_table_id IN NUMBER ,

Line 2406: FROM pay_event_updates a,

2402: p_start_col IN VARCHAR2 ,
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

Line 3535: pay_event_updates peu,

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
3539: and peu.event_type = 'I'

Line 3995: p_change_mode IN pay_event_updates.change_type%type,

3991: (
3992: p_surrogate_key IN pay_process_events.surrogate_key%type ,
3993: p_event_update_id IN pay_process_events.event_update_id%type ,
3994: p_assignment_id IN per_all_assignments.assignment_id%type,
3995: p_change_mode IN pay_event_updates.change_type%type,
3996: p_cache_number IN OUT NOCOPY NUMBER
3997: ) IS
3998:
3999: CURSOR csr_get_cache_asgid (

Line 4915: type t_column_name is table of pay_event_updates.column_name%type

4911: ) AS
4912: --
4913: -- Setup the types
4914: --
4915: type t_column_name is table of pay_event_updates.column_name%type
4916: index by binary_integer;
4917: type t_event_type is table of pay_event_updates.event_type%type
4918: index by binary_integer;
4919: type t_event_update_id is table of pay_event_updates.event_update_id%type

Line 4917: type t_event_type is table of pay_event_updates.event_type%type

4913: -- Setup the types
4914: --
4915: type t_column_name is table of pay_event_updates.column_name%type
4916: index by binary_integer;
4917: type t_event_type is table of pay_event_updates.event_type%type
4918: index by binary_integer;
4919: type t_event_update_id is table of pay_event_updates.event_update_id%type
4920: index by binary_integer;
4921: type t_effective_date is table of pay_process_events.effective_date%type

Line 4919: type t_event_update_id is table of pay_event_updates.event_update_id%type

4915: type t_column_name is table of pay_event_updates.column_name%type
4916: index by binary_integer;
4917: type t_event_type is table of pay_event_updates.event_type%type
4918: index by binary_integer;
4919: type t_event_update_id is table of pay_event_updates.event_update_id%type
4920: index by binary_integer;
4921: type t_effective_date is table of pay_process_events.effective_date%type
4922: index by binary_integer;
4923: type t_assignment_id is table of pay_process_events.assignment_id%type

Line 4975: pay_event_updates peu

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
4978: AND peu.dated_table_id = pdt.dated_table_id
4979: AND pdt.dated_table_id IN

Line 5033: pay_event_updates peu ,

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
5037: AND peu.dated_table_id = pdt.dated_table_id

Line 5104: pay_event_updates peu

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
5107: AND peu.dated_table_id = pdt.dated_table_id
5108: AND pdt.dated_table_id IN

Line 5164: pay_event_updates peu ,

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
5168: AND peu.dated_table_id = pdt.dated_table_id

Line 5237: pay_event_updates peu

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
5240: AND peu.dated_table_id = pdt.dated_table_id
5241: AND pdt.dated_table_id IN

Line 5322: pay_event_updates peu

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
5325: AND peu.dated_table_id = pdt.dated_table_id
5326: --Added new condition to capture REPORTS events only