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 218: from pay_assignment_link_usages_f ALU

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

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

406: id_flex_num number);
407: --
408: -- Bugfix 3720575
409: -- Added these extra user-defined types to enable bulk-inserts...
410: type t_alu_id is table of pay_assignment_link_usages_f.assignment_link_usage_id%type
411: index by binary_integer;
412: --
413: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
414: index by binary_integer;

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

409: -- Added these extra user-defined types to enable bulk-inserts...
410: type t_alu_id is table of pay_assignment_link_usages_f.assignment_link_usage_id%type
411: index by binary_integer;
412: --
413: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
414: index by binary_integer;
415: --
416: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
417: index by binary_integer;

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

412: --
413: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
414: index by binary_integer;
415: --
416: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
417: index by binary_integer;
418: --
419: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
420: index by binary_integer;

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

415: --
416: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
417: index by binary_integer;
418: --
419: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
420: index by binary_integer;
421: --
422: -- find all instances of the assignment that has a people group
423: --

Line 571: delete from pay_assignment_link_usages_f alu

567: then
568: --
569: -- Delete all the alu's for the assignment
570: --
571: delete from pay_assignment_link_usages_f alu
572: where alu.assignment_id = p_assignment_id;
573: --
574: --
575: open csr_assignment(p_assignment_id);

Line 697: insert into pay_assignment_link_usages_f

693: -- Bugfix 3720575
694: -- Create the ALUs in bulk
695: --
696: forall i in 1..v_counter
697: insert into pay_assignment_link_usages_f
698: (assignment_link_usage_id,
699: effective_start_date,
700: effective_end_date,
701: element_link_id,

Line 1953: from pay_assignment_link_usages_f alu

1949: )
1950: and (el.people_group_id is null
1951: or exists
1952: (select null
1953: from pay_assignment_link_usages_f alu
1954: where alu.assignment_id = p_assignment_id
1955: and alu.element_link_id = el.element_link_id
1956: and alu.effective_start_date <= p_validation_end_date
1957: and alu.effective_end_date >= p_validation_start_date

Line 2411: from pay_assignment_link_usages_f alu

2407: el.employment_category = asg.employment_category)
2408: and (el.people_group_id is null or
2409: exists
2410: (select null
2411: from pay_assignment_link_usages_f alu
2412: where alu.assignment_id = ee.assignment_id
2413: and alu.element_link_id = ee.element_link_id
2414: and alu.effective_start_date <=
2415: asg.effective_end_date

Line 3026: from pay_assignment_link_usages_f alu

3022: el.employment_category = asg.employment_category)
3023: and (el.people_group_id is null or
3024: exists
3025: (select null
3026: from pay_assignment_link_usages_f alu
3027: where alu.assignment_id = ee.assignment_id
3028: and alu.element_link_id = ee.element_link_id
3029: and alu.effective_start_date <=
3030: asg.effective_end_date

Line 3431: from pay_assignment_link_usages_f alu

3427: and (el.employment_category is null
3428: or el.employment_category = asg.employment_category)
3429: and (el.people_group_id is null
3430: or exists (select null
3431: from pay_assignment_link_usages_f alu
3432: where alu.assignment_id = ee.assignment_id
3433: and alu.element_link_id = ee.element_link_id
3434: and alu.effective_start_date <=
3435: asg.effective_end_date

Line 3761: select count(*) into v_alu_cnt from pay_assignment_link_usages_f where

3757: /* Bug : 6809717 Added the following block of code to calculate the validation start date
3758: properly in case of people group change in assignment information*/
3759: --Start
3760: if p_dt_mode='DELETE_NEXT_CHANGE' then
3761: select count(*) into v_alu_cnt from pay_assignment_link_usages_f where
3762: assignment_id=p_assignment_id
3763: and effective_start_date>=p_val_start_date_minus_one
3764: and effective_end_date>=p_val_start_date_minus_one;
3765: if g_debug then

Line 5657: from pay_assignment_link_usages_f alu

5653: p_employment_category = asg.employment_category)
5654: and (p_people_group_id is null or
5655: exists
5656: (select null
5657: from pay_assignment_link_usages_f alu
5658: where alu.assignment_id = p_assignment_id
5659: and alu.element_link_id = p_element_link_id
5660: and alu.effective_start_date <= asg.effective_end_date
5661: and alu.effective_end_date >= asg.effective_start_date))

Line 6074: from pay_assignment_link_usages_f alu

6070: p_employment_category = asg.employment_category)
6071: and (p_people_group_id is null or
6072: exists
6073: (select null
6074: from pay_assignment_link_usages_f alu
6075: where alu.assignment_id = asg.assignment_id
6076: and alu.element_link_id = p_element_link_id
6077: and alu.effective_start_date <= asg.effective_end_date
6078: and alu.effective_end_date >= asg.effective_start_date))