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.HRENTMNT dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 219: from pay_assignment_link_usages_f ALU

215: p_employment_category = ASG.employment_category)
216: and (p_people_group_id is null or
217: exists
218: (select null
219: from pay_assignment_link_usages_f ALU
220: where ALU.assignment_id = p_assignment_id
221: and ALU.element_link_id = p_element_link_id
222: and ALU.effective_start_date <= ASG.effective_end_date
223: and ALU.effective_end_date >= ASG.effective_start_date))

Line 417: type t_alu_id is table of pay_assignment_link_usages_f.assignment_link_usage_id%type

413: id_flex_num number);
414: --
415: -- Bugfix 3720575
416: -- Added these extra user-defined types to enable bulk-inserts...
417: type t_alu_id is table of pay_assignment_link_usages_f.assignment_link_usage_id%type
418: index by binary_integer;
419: --
420: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
421: index by binary_integer;

Line 420: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type

416: -- Added these extra user-defined types to enable bulk-inserts...
417: type t_alu_id is table of pay_assignment_link_usages_f.assignment_link_usage_id%type
418: index by binary_integer;
419: --
420: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
421: index by binary_integer;
422: --
423: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
424: index by binary_integer;

Line 423: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type

419: --
420: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
421: index by binary_integer;
422: --
423: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
424: index by binary_integer;
425: --
426: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
427: index by binary_integer;

Line 426: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type

422: --
423: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
424: index by binary_integer;
425: --
426: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
427: index by binary_integer;
428: --
429: -- find all instances of the assignment that has a people group
430: --

Line 2233: from pay_assignment_link_usages_f alu

2229: )
2230: and (el.people_group_id is null
2231: or exists
2232: (select null
2233: from pay_assignment_link_usages_f alu
2234: where alu.assignment_id = p_assignment_id
2235: and alu.element_link_id = el.element_link_id
2236: and alu.effective_start_date <= p_validation_end_date
2237: and alu.effective_end_date >= p_validation_start_date

Line 2742: from pay_assignment_link_usages_f alu

2738: el.employment_category = asg.employment_category)
2739: and (el.people_group_id is null or
2740: exists
2741: (select null
2742: from pay_assignment_link_usages_f alu
2743: where alu.assignment_id = ee.assignment_id
2744: and alu.element_link_id = ee.element_link_id
2745: and alu.effective_start_date <=
2746: asg.effective_end_date

Line 3596: from pay_assignment_link_usages_f alu

3592: el.employment_category = asg.employment_category)
3593: and (el.people_group_id is null or
3594: exists
3595: (select null
3596: from pay_assignment_link_usages_f alu
3597: where alu.assignment_id = ee.assignment_id
3598: and alu.element_link_id = ee.element_link_id
3599: and alu.effective_start_date <=
3600: asg.effective_end_date

Line 4071: from pay_assignment_link_usages_f alu

4067: and (el.employment_category is null
4068: or el.employment_category = asg.employment_category)
4069: and (el.people_group_id is null
4070: or exists (select null
4071: from pay_assignment_link_usages_f alu
4072: where alu.assignment_id = ee.assignment_id
4073: and alu.element_link_id = ee.element_link_id
4074: and alu.effective_start_date <=
4075: asg.effective_end_date

Line 6512: from pay_assignment_link_usages_f alu

6508: p_employment_category = asg.employment_category)
6509: and (p_people_group_id is null or
6510: exists
6511: (select null
6512: from pay_assignment_link_usages_f alu
6513: where alu.assignment_id = p_assignment_id
6514: and alu.element_link_id = p_element_link_id
6515: and alu.effective_start_date <= asg.effective_end_date
6516: and alu.effective_end_date >= asg.effective_start_date))

Line 7008: from pay_assignment_link_usages_f alu

7004: p_employment_category = asg.employment_category)
7005: and (p_people_group_id is null or
7006: exists
7007: (select null
7008: from pay_assignment_link_usages_f alu
7009: where alu.assignment_id = asg.assignment_id
7010: and alu.element_link_id = p_element_link_id
7011: and alu.effective_start_date <= asg.effective_end_date
7012: and alu.effective_end_date >= asg.effective_start_date))

Line 7077: from pay_assignment_link_usages_f alu

7073: p_employment_category = asg.employment_category)
7074: and (p_people_group_id is null or
7075: exists
7076: (select null
7077: from pay_assignment_link_usages_f alu
7078: where alu.assignment_id = asg.assignment_id
7079: and alu.element_link_id = p_element_link_id
7080: and alu.effective_start_date <= asg.effective_end_date
7081: and alu.effective_end_date >= asg.effective_start_date))