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_PROCESS_EVENTS

Line 699: FROM pay_process_events ppe,

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

Line 711: FROM pay_process_events ppe,

707: AND peu.dated_table_id=p_dated_table_id;
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

Line 724: FROM pay_process_events ppe,

720: AND peu.dated_table_id=p_dated_table_id;
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

Line 2297: -- The following cursor selects the rows from pay_process_events where

2293: Notes : PUBLIC
2294: ****************************************************************************/
2295: PROCEDURE asg_action_affected(p_assignment_action_id IN NUMBER) AS
2296:
2297: -- The following cursor selects the rows from pay_process_events where
2298: -- Change_type in DATE_PROCESSED, DATE_EARNED, GRE, PAYMENT, COST_CENTRE
2299: -- and status = 'U'
2300: CURSOR c_pay_process_events(p_assignment_id IN NUMBER) IS
2301: SELECT process_event_id ,

Line 2300: CURSOR c_pay_process_events(p_assignment_id IN NUMBER) IS

2296:
2297: -- The following cursor selects the rows from pay_process_events where
2298: -- Change_type in DATE_PROCESSED, DATE_EARNED, GRE, PAYMENT, COST_CENTRE
2299: -- and status = 'U'
2300: CURSOR c_pay_process_events(p_assignment_id IN NUMBER) IS
2301: SELECT process_event_id ,
2302: event_update_id ,
2303: change_type ,
2304: assignment_id ,

Line 2307: FROM pay_process_events

2303: change_type ,
2304: assignment_id ,
2305: surrogate_key ,
2306: effective_date
2307: FROM pay_process_events
2308: WHERE assignment_id = p_assignment_id
2309: AND change_type IN ('DATE_PROCESSED',
2310: 'DATE_EARNED' ,
2311: 'PAYMENT' ,

Line 2335: l_process_event_id pay_process_events.process_event_id%TYPE ;

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

Line 2336: l_change_type1 pay_process_events.change_type%TYPE ;

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

Line 2337: l_assignment_id pay_process_events.assignment_id%TYPE ;

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

Line 2338: l_surrogate_key pay_process_events.surrogate_key%TYPE ;

2334:
2335: l_process_event_id pay_process_events.process_event_id%TYPE ;
2336: l_change_type1 pay_process_events.change_type%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 ;

Line 2339: l_effective_date pay_process_events.effective_date%TYPE ;

2335: l_process_event_id pay_process_events.process_event_id%TYPE ;
2336: l_change_type1 pay_process_events.change_type%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 ;

Line 2356: FOR cppe IN c_pay_process_events(l_assignment_id)

2352: LOOP
2353: l_assignment_id := caa.assignment_id;
2354: END LOOP;
2355:
2356: FOR cppe IN c_pay_process_events(l_assignment_id)
2357: LOOP
2358: l_process_event_id := cppe.process_event_id ;
2359: l_event_update_id := cppe.event_update_id ;
2360: l_change_type1 := cppe.change_type ;

Line 2419: FROM pay_process_events

2415: CURSOR c_process_events(p_process_event_id IN NUMBER) IS
2416: SELECT change_type ,
2417: event_update_id ,
2418: effective_date
2419: FROM pay_process_events
2420: WHERE process_event_id = p_process_event_id ;
2421:
2422: CURSOR c_pay_tables(p_table_id IN NUMBER) IS
2423: SELECT table_name ,

Line 3523: from pay_process_events

3519: -- Get the min date of the Delete rows for this
3520: -- Date Track transaction
3521: select min(effective_date)
3522: into l_effective_date
3523: from pay_process_events
3524: where surrogate_key = p_pro_evt_rec.surrogate_key
3525: and event_update_id = p_pro_evt_rec.event_update_id
3526: and creation_date = p_pro_evt_rec.creation_date;
3527: --

Line 3536: pay_process_events ppe

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'
3540: and peu.change_type = p_pro_evt_rec.change_mode

Line 3992: p_surrogate_key IN pay_process_events.surrogate_key%type ,

3988:
3989: ---------------------------------------------------------- */
3990: PROCEDURE get_dbt_i_p_cache
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

Line 3993: p_event_update_id IN pay_process_events.event_update_id%type ,

3989: ---------------------------------------------------------- */
3990: PROCEDURE get_dbt_i_p_cache
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

Line 4006: FROM PAY_PROCESS_EVENTS

4002: cp_mode in varchar2,
4003: cp_assignment_id in number) is
4004: SELECT min(creation_date),
4005: max(creation_date)
4006: FROM PAY_PROCESS_EVENTS
4007: WHERE event_update_id = cp_event_update_id
4008: AND surrogate_key = cp_base_record_id
4009: AND assignment_id is not null
4010: AND assignment_id = cp_assignment_id

Line 4019: FROM PAY_PROCESS_EVENTS

4015: cp_event_update_id in number,
4016: cp_mode in varchar2) is
4017: SELECT min(creation_date),
4018: max(creation_date)
4019: FROM PAY_PROCESS_EVENTS
4020: WHERE event_update_id = cp_event_update_id
4021: AND surrogate_key = cp_base_record_id
4022: AND assignment_id is null
4023: AND change_type = nvl(cp_mode,change_type);

Line 4921: type t_effective_date is table of pay_process_events.effective_date%type

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
4924: index by binary_integer;
4925: type t_surrogate_key is table of pay_process_events.surrogate_key%type

Line 4923: type t_assignment_id is table of pay_process_events.assignment_id%type

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
4924: index by binary_integer;
4925: type t_surrogate_key is table of pay_process_events.surrogate_key%type
4926: index by binary_integer;
4927: type t_process_event_id is table of pay_process_events.process_event_id%type

Line 4925: type t_surrogate_key is table of pay_process_events.surrogate_key%type

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
4924: index by binary_integer;
4925: type t_surrogate_key is table of pay_process_events.surrogate_key%type
4926: index by binary_integer;
4927: type t_process_event_id is table of pay_process_events.process_event_id%type
4928: index by binary_integer;
4929: type t_description is table of pay_process_events.description%type

Line 4927: type t_process_event_id is table of pay_process_events.process_event_id%type

4923: type t_assignment_id is table of pay_process_events.assignment_id%type
4924: index by binary_integer;
4925: type t_surrogate_key is table of pay_process_events.surrogate_key%type
4926: index by binary_integer;
4927: type t_process_event_id is table of pay_process_events.process_event_id%type
4928: index by binary_integer;
4929: type t_description is table of pay_process_events.description%type
4930: index by binary_integer;
4931: type t_calculation_date is table of pay_process_events.calculation_date%type

Line 4929: type t_description is table of pay_process_events.description%type

4925: type t_surrogate_key is table of pay_process_events.surrogate_key%type
4926: index by binary_integer;
4927: type t_process_event_id is table of pay_process_events.process_event_id%type
4928: index by binary_integer;
4929: type t_description is table of pay_process_events.description%type
4930: index by binary_integer;
4931: type t_calculation_date is table of pay_process_events.calculation_date%type
4932: index by binary_integer;
4933: type t_creation_date is table of pay_process_events.creation_date%type

Line 4931: type t_calculation_date is table of pay_process_events.calculation_date%type

4927: type t_process_event_id is table of pay_process_events.process_event_id%type
4928: index by binary_integer;
4929: type t_description is table of pay_process_events.description%type
4930: index by binary_integer;
4931: type t_calculation_date is table of pay_process_events.calculation_date%type
4932: index by binary_integer;
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

Line 4933: type t_creation_date is table of pay_process_events.creation_date%type

4929: type t_description is table of pay_process_events.description%type
4930: index by binary_integer;
4931: type t_calculation_date is table of pay_process_events.calculation_date%type
4932: index by binary_integer;
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

Line 4935: type t_change_type is table of pay_process_events.change_type%type

4931: type t_calculation_date is table of pay_process_events.calculation_date%type
4932: index by binary_integer;
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: --

Line 4959: SELECT /+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N3) USE_NL(PPE) /

4955: cp_bulk_processing IN VARCHAR,
4956: cp_cstart_date IN DATE ,
4957: cp_cend_date IN DATE ) IS
4958:
4959: SELECT /*+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N3) USE_NL(PPE) */
4960: peu.column_name updated_column_name ,
4961: peu.event_type event_type ,
4962: peu.event_update_id event_update_id ,
4963: ppe.effective_date effective_date ,

Line 4974: pay_process_events ppe ,

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

Line 5018: SELECT /+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N3) USE_NL(PDT) /

5014: )
5015: )
5016: )
5017: UNION ALL
5018: SELECT /*+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N3) USE_NL(PDT) */
5019: peu.column_name updated_column_name ,
5020: peu.event_type event_type ,
5021: peu.event_update_id event_update_id ,
5022: ppe.effective_date effective_date ,

Line 5034: pay_process_events ppe

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
5038: AND pdt.dated_table_id IN

Line 5088: SELECT /+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N5) USE_NL(PPE) /

5084: cp_bulk_processing IN VARCHAR2,
5085: cp_estart_date IN DATE ,
5086: cp_eend_date IN DATE ) IS
5087:
5088: SELECT /*+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N5) USE_NL(PPE) */
5089: peu.column_name updated_column_name ,
5090: peu.event_type event_type ,
5091: peu.event_update_id event_update_id ,
5092: ppe.effective_date effective_date ,

Line 5103: pay_process_events ppe ,

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

Line 5149: SELECT /+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N5) USE_NL(PDT) /

5145: )
5146: )
5147: )
5148: UNION ALL
5149: SELECT /*+ no_expand ORDERED INDEX(PPE PAY_PROCESS_EVENTS_N5) USE_NL(PDT) */
5150: peu.column_name updated_column_name ,
5151: peu.event_type event_type ,
5152: peu.event_update_id event_update_id ,
5153: ppe.effective_date effective_date ,

Line 5165: pay_process_events ppe

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
5169: AND pdt.dated_table_id IN

Line 5236: pay_process_events ppe ,

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

Line 5321: pay_process_events ppe ,

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

Line 5739: -- pay_process_events are all events that have occurred

5735: --all this code is within record_disco_events
5736:
5737: -- EG
5738: -- PROCESS EVENTS
5739: -- pay_process_events are all events that have occurred
5740: -- DATETRACKED EVENTS
5741: -- All events the user has declared they are interested in,
5742: -- ie child of event group
5743: -- DISCO(vered) EVENTS

Line 6017: from pay_process_events

6013: --
6014: if ( l_business_group_id is null) then
6015: select max(business_group_id)
6016: into l_business_group_id
6017: from pay_process_events
6018: where assignment_id = p_assignment_id;
6019: end if;
6020:
6021: