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_ELEMENT_LINKS_F

Line 153: from pay_element_links_f EL

149: EL.location_id,
150: EL.pay_basis_id,
151: EL.employment_category,
152: EL.people_group_id
153: from pay_element_links_f EL
154: where EL.element_link_id = p_element_link_id
155: order by EL.effective_start_date;
156: --
157: -- Fetches all assignment rows for a given assignment that match specific

Line 453: from pay_element_links_f el,

449: ) is
450: select el.element_link_id,
451: min(el.effective_start_date) effective_start_date,
452: max(el.effective_end_date) effective_end_date
453: from pay_element_links_f el,
454: pay_people_groups el_pg,
455: pay_people_groups asg_pg
456: where asg_pg.id_flex_num = p_id_flex_num
457: and asg_pg.people_group_id = p_people_group_id

Line 1451: pay_element_links_f EL

1447: cursor csr_ele_info is
1448: select EL.element_type_id element_type_id,
1449: 'Y' salary_element
1450: from pay_element_entries_f EE,
1451: pay_element_links_f EL
1452: where EE.element_entry_id = p_element_entry_id
1453: and EL.element_link_id = EE.element_link_id
1454: and nvl(p_old_date,p_effective_start_date) between
1455: EE.effective_start_date and EE.effective_end_date

Line 1467: pay_element_links_f EL

1463: UNION ALL
1464: select EL.element_type_id element_type_id,
1465: 'N' salary_element
1466: from pay_element_entries_f EE,
1467: pay_element_links_f EL
1468: where EE.element_entry_id = p_element_entry_id
1469: and EL.element_link_id = EE.element_link_id
1470: and nvl(p_old_date,p_effective_start_date) between
1471: EE.effective_start_date and EE.effective_end_date

Line 1736: from pay_element_links_f pel,

1732: -- with datetrack joins here.
1733: begin
1734: select nvl(pec.non_payments_flag, 'N')
1735: into l_non_payments_flag
1736: from pay_element_links_f pel,
1737: pay_element_types_f pet,
1738: pay_element_classifications pec
1739: where pel.element_link_id = p_element_link_id
1740: and pet.element_type_id = pel.element_type_id

Line 1871: from pay_element_links_f el

1867: open p_eligible_links_cv for
1868: select el.element_link_id,
1869: min(el.effective_start_date) effective_start_date,
1870: max(el.effective_end_date) effective_end_date
1871: from pay_element_links_f el
1872: where el.element_type_id = p_element_type_id
1873: and el.standard_link_flag = 'N'
1874: and el.business_group_id = p_business_group_id
1875: --

Line 2303: pay_element_links_f el,

2299: el.standard_link_flag,
2300: el.element_type_id
2301: from
2302: pay_element_entries_f ee,
2303: pay_element_links_f el,
2304: pay_element_types_f et
2305: where ee.assignment_id = p_assignment_id
2306: and ee.effective_start_date <= p_validation_end_date
2307: and ee.effective_end_date >= p_validation_start_date

Line 2983: from pay_element_links_f el,

2979: and ((ee.entry_type <> 'E')
2980: or (ee.entry_type = 'E' and
2981: exists
2982: (select null
2983: from pay_element_links_f el,
2984: pay_element_types_f et
2985: where el.element_link_id = ee.element_link_id
2986: and el.element_type_id = et.element_type_id
2987: and et.processing_type = 'N')))

Line 2991: pay_element_links_f el

2987: and et.processing_type = 'N')))
2988: and not exists
2989: (select null
2990: from per_all_assignments_f asg,
2991: pay_element_links_f el
2992: where el.element_link_id = ee.element_link_id
2993: and asg.assignment_id = ee.assignment_id
2994: and asg.assignment_type = 'E'
2995: and asg.effective_start_date <= ee.effective_end_date

Line 3262: from pay_element_links_f el,

3258: (
3259: p_element_link_id number
3260: ) is
3261: select et.multiple_entries_allowed_flag
3262: from pay_element_links_f el,
3263: pay_element_types_f et
3264: where el.element_link_id = p_element_link_id
3265: and et.element_type_id = el.element_type_id;
3266: --

Line 3396: pay_element_links_f el

3392: --
3393: and not exists
3394: (select null
3395: from per_all_assignments_f asg,
3396: pay_element_links_f el
3397: where asg.assignment_id = ee.assignment_id
3398: and el.element_link_id = ee.element_link_id
3399: and asg.assignment_type = 'E'
3400: and asg.effective_start_date <= ee.effective_end_date

Line 3710: from pay_element_links_f el,

3706: and ((ee.entry_type <> 'E') or
3707: (ee.entry_type = 'E' and
3708: exists
3709: (select null
3710: from pay_element_links_f el,
3711: pay_element_types_f et
3712: where el.element_link_id = ee.element_link_id
3713: and et.element_type_id = el.element_type_id
3714: and et.processing_type = 'N')));

Line 3918: PAY_ELEMENT_LINKS_F el,

3914: b_effective_date in date,
3915: b_element_link_id in number) is
3916: SELECT dfc.descriptive_flex_context_code
3917: FROM PER_BUSINESS_GROUPS_PERF bg,
3918: PAY_ELEMENT_LINKS_F el,
3919: PAY_ELEMENT_TYPES_F et,
3920: PAY_ELEMENT_CLASSIFICATIONS ec,
3921: FND_DESCR_FLEX_CONTEXTS dfc
3922: WHERE bg.business_group_id =

Line 4134: from pay_element_links_f

4130: --
4131: cursor csr_standard_link is
4132: --
4133: select standard_link_flag
4134: from pay_element_links_f
4135: where element_link_id = p_element_link_id
4136: and p_effective_date between effective_start_date
4137: and effective_end_date;
4138: --

Line 4847: from pay_element_links_f el,

4843: where ee.assignment_id = p_assignment_id
4844: and ee.entry_type = 'E'
4845: and exists
4846: (select null
4847: from pay_element_links_f el,
4848: pay_element_types_f et
4849: where el.element_link_id = ee.element_link_id
4850: and el.standard_link_flag = 'Y'
4851: and et.element_type_id = el.element_type_id

Line 5171: from pay_element_links_f el,

5167: and ee.entry_type = 'E'
5168: and nvl(ee.updating_action_type,'null') <> 'S' -- Bugfix 2249308
5169: and exists
5170: (select null
5171: from pay_element_links_f el,
5172: pay_element_types_f et
5173: where el.element_link_id = ee.element_link_id
5174: and el.element_type_id = et.element_type_id
5175: and et.processing_type = 'R')

Line 5182: from pay_element_links_f el,

5178: 'A',nvl(p_actual_term_date,p_sot),
5179: 'L',nvl(p_last_standard_date,p_sot),
5180: 'F',nvl(p_final_process_date,p_sot),
5181: p_sot)
5182: from pay_element_links_f el,
5183: pay_element_types_f et
5184: where el.element_link_id = ee.element_link_id
5185: and et.element_type_id = el.element_type_id
5186: and ee.effective_start_date between el.effective_start_date

Line 5460: from pay_element_links_f el

5456: el.employment_category,
5457: el.people_group_id,
5458: el.element_type_id,
5459: el.standard_link_flag
5460: from pay_element_links_f el
5461: where el.business_group_id = p_business_group_id
5462: and ((el.standard_link_flag = 'Y' and
5463: exists
5464: (select null

Line 5465: from pay_element_links_f el2

5461: where el.business_group_id = p_business_group_id
5462: and ((el.standard_link_flag = 'Y' and
5463: exists
5464: (select null
5465: from pay_element_links_f el2
5466: where el2.element_link_id = el.element_link_id
5467: and el.effective_start_date <= p_validation_end_date
5468: and el.effective_end_date >= p_validation_start_date))
5469: or (el.standard_link_flag = 'N' and

Line 5488: FROM PAY_ELEMENT_LINKS_F el_sub

5484: -- start of change 115.16 --
5485: -- Ensure this non-standard link has not been changed from/to a standard link
5486: and NOT EXISTS
5487: (SELECT null
5488: FROM PAY_ELEMENT_LINKS_F el_sub
5489: WHERE el_sub.element_link_id = el.element_link_id
5490: and el_sub.standard_link_flag = 'Y'
5491: )
5492: -- end of change 115.16 --

Line 5591: FROM PAY_ELEMENT_LINKS_F el,

5587: p_pay_basis_id is null and
5588: NOT EXISTS
5589: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
5590: pb.pay_basis_id
5591: FROM PAY_ELEMENT_LINKS_F el,
5592: PAY_INPUT_VALUES_F iv,
5593: PER_PAY_BASES pb
5594: WHERE el.element_link_id = p_element_link_id
5595: and el.effective_start_date <= asg.effective_start_date

Line 5616: PAY_ELEMENT_LINKS_F el

5612: EXISTS
5613: (SELECT pb.pay_basis_id
5614: FROM PER_PAY_BASES pb,
5615: PAY_INPUT_VALUES_F iv,
5616: PAY_ELEMENT_LINKS_F el
5617: WHERE el.element_link_id = p_element_link_id
5618: and el.effective_start_date <= asg.effective_start_date
5619: and el.effective_end_date >= asg.effective_start_date
5620: and iv.element_type_id =

Line 5635: FROM PAY_ELEMENT_LINKS_F el,

5631: asg.pay_basis_id is null and
5632: EXISTS
5633: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
5634: pb.pay_basis_id
5635: FROM PAY_ELEMENT_LINKS_F el,
5636: PAY_INPUT_VALUES_F iv,
5637: PER_PAY_BASES pb
5638: WHERE el.element_link_id = p_element_link_id
5639: and el.effective_start_date <= asg.effective_start_date

Line 6418: pay_element_links_f pel

6414: pel.pay_basis_id,
6415: pel.link_to_all_payrolls_flag,
6416: pel.standard_link_flag
6417: from pay_element_entries_f pee,
6418: pay_element_links_f pel
6419: where pee.assignment_id = p_assignment_id
6420: and pel.element_link_id = pee.element_link_id;
6421:
6422: begin