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 4989: pay_event_updates peu

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,
4993: ben_ext_dfn bed

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

5051: ) AS
5052: --
5053: -- Setup the types
5054: --
5055: type t_column_name is table of pay_event_updates.column_name%type
5056: index by binary_integer;
5057: type t_event_type is table of pay_event_updates.event_type%type
5058: index by binary_integer;
5059: type t_event_update_id is table of pay_event_updates.event_update_id%type

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

5053: -- Setup the types
5054: --
5055: type t_column_name is table of pay_event_updates.column_name%type
5056: index by binary_integer;
5057: type t_event_type is table of pay_event_updates.event_type%type
5058: index by binary_integer;
5059: type t_event_update_id is table of pay_event_updates.event_update_id%type
5060: index by binary_integer;
5061: type t_effective_date is table of pay_process_events.effective_date%type

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

5055: type t_column_name is table of pay_event_updates.column_name%type
5056: index by binary_integer;
5057: type t_event_type is table of pay_event_updates.event_type%type
5058: index by binary_integer;
5059: type t_event_update_id is table of pay_event_updates.event_update_id%type
5060: index by binary_integer;
5061: type t_effective_date is table of pay_process_events.effective_date%type
5062: index by binary_integer;
5063: type t_assignment_id is table of pay_process_events.assignment_id%type

Line 5119: pay_event_updates peu

5115: pdt.table_name table_name
5116: FROM
5117: pay_dated_tables pdt ,
5118: pay_process_events ppe ,
5119: pay_event_updates peu
5120: WHERE
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

Line 5177: pay_event_updates peu ,

5173: ppe.change_type change_mode,
5174: pdt.table_name table_name
5175: FROM
5176: pay_dated_tables pdt ,
5177: pay_event_updates peu ,
5178: pay_process_events ppe
5179: WHERE
5180: peu.event_update_id = ppe.event_update_id + 0
5181: AND peu.dated_table_id = pdt.dated_table_id

Line 5249: pay_event_updates peu

5245: pdt.table_name table_name
5246: FROM
5247: pay_dated_tables pdt ,
5248: pay_process_events ppe ,
5249: pay_event_updates peu
5250: WHERE
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

Line 5309: pay_event_updates peu ,

5305: ppe.change_type change_mode,
5306: pdt.table_name table_name
5307: FROM
5308: pay_dated_tables pdt ,
5309: pay_event_updates peu ,
5310: pay_process_events ppe
5311: WHERE
5312: peu.event_update_id = ppe.event_update_id + 0
5313: AND peu.dated_table_id = pdt.dated_table_id

Line 5382: pay_event_updates peu

5378: pdt.table_name table_name
5379: FROM
5380: pay_dated_tables pdt ,
5381: pay_process_events ppe ,
5382: pay_event_updates peu
5383: WHERE
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

Line 5469: pay_event_updates peu

5465: pdt.table_name table_name
5466: FROM
5467: pay_dated_tables pdt ,
5468: pay_process_events ppe ,
5469: pay_event_updates peu
5470: WHERE
5471: peu.event_update_id = ppe.event_update_id + 0
5472: AND peu.dated_table_id = pdt.dated_table_id
5473: --Added new condition to capture REPORTS events only

Line 5546: pay_event_updates peu

5542: pdt.table_name table_name
5543: FROM
5544: pay_dated_tables pdt ,
5545: pay_process_events ppe ,
5546: pay_event_updates peu
5547: WHERE
5548: peu.event_update_id = ppe.event_update_id + 0
5549: AND peu.dated_table_id = pdt.dated_table_id
5550: --Added new condition to capture REPORTS events only