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_TYPES_F

Line 991: pay_element_types_f et

987: iv.value_set_id,
988: et.input_currency_code
989: from pay_element_entry_values_f eev,
990: pay_input_values_f iv,
991: pay_element_types_f et
992: where eev.element_entry_id = p_element_entry_id
993: and iv.input_value_id = eev.input_value_id
994: and et.element_type_id = iv.element_type_id
995: and eev.effective_end_date = p_date

Line 2002: pay_element_types_f pet,

1998: begin
1999: select nvl(pec.non_payments_flag, 'N')
2000: into l_non_payments_flag
2001: from pay_element_links_f pel,
2002: pay_element_types_f pet,
2003: pay_element_classifications pec
2004: where pel.element_link_id = p_element_link_id
2005: and pet.element_type_id = pel.element_type_id
2006: and pec.classification_id = pet.classification_id

Line 2399: ,pay_element_types_f et

2395: where exists
2396: (select null
2397: from pay_element_entries_f ee
2398: ,pay_element_links_f el
2399: ,pay_element_types_f et
2400: where ee.assignment_id = p_assignment_id
2401: and ee.element_entry_id = p_element_entry_id
2402: and ee.entry_type = 'E'
2403: and el.element_link_id = ee.element_link_id

Line 2635: pay_element_types_f et

2631: el.element_type_id
2632: from
2633: pay_element_entries_f ee,
2634: pay_element_links_f el,
2635: pay_element_types_f et
2636: where ee.assignment_id = p_assignment_id
2637: and ee.effective_start_date <= p_validation_end_date
2638: and ee.effective_end_date >= p_validation_start_date
2639: and ee.entry_type='E'

Line 3554: pay_element_types_f et

3550: or (ee.entry_type = 'E' and
3551: exists
3552: (select null
3553: from pay_element_links_f el,
3554: pay_element_types_f et
3555: where el.element_link_id = ee.element_link_id
3556: and el.element_type_id = et.element_type_id
3557: and et.processing_type = 'N')))
3558: and not exists

Line 3900: pay_element_types_f et

3896: p_element_link_id number
3897: ) is
3898: select et.multiple_entries_allowed_flag
3899: from pay_element_links_f el,
3900: pay_element_types_f et
3901: where el.element_link_id = p_element_link_id
3902: and et.element_type_id = el.element_type_id;
3903: --
3904: -- Local Variables

Line 3993: ,pay_element_types_f et

3989: p_adjust_ee_source varchar2
3990: ) is
3991: select ee.*
3992: from pay_element_entries_f ee
3993: ,pay_element_types_f et
3994: where ee.assignment_id = p_assignment_id
3995: and ee.effective_start_date <= p_validation_end_date
3996: and ee.effective_end_date >= p_validation_start_date
3997: and ee.element_type_id = et.element_type_id

Line 4386: pay_element_types_f et

4382: (ee.entry_type = 'E' and
4383: exists
4384: (select null
4385: from pay_element_links_f el,
4386: pay_element_types_f et
4387: where el.element_link_id = ee.element_link_id
4388: and et.element_type_id = el.element_type_id
4389: and et.processing_type = 'N')));
4390: --

Line 4654: PAY_ELEMENT_TYPES_F et,

4650: b_element_link_id in number) is
4651: SELECT dfc.descriptive_flex_context_code
4652: FROM PER_BUSINESS_GROUPS_PERF bg,
4653: PAY_ELEMENT_LINKS_F el,
4654: PAY_ELEMENT_TYPES_F et,
4655: PAY_ELEMENT_CLASSIFICATIONS ec,
4656: FND_DESCR_FLEX_CONTEXTS dfc
4657: WHERE bg.business_group_id =
4658: el.business_group_id

Line 5620: pay_element_types_f et

5616: and ee.entry_type = 'E'
5617: and exists
5618: (select null
5619: from pay_element_links_f el,
5620: pay_element_types_f et
5621: where el.element_link_id = ee.element_link_id
5622: and el.standard_link_flag = 'Y'
5623: and et.element_type_id = el.element_type_id
5624: and et.processing_type = 'R')

Line 5950: pay_element_types_f et

5946: and nvl(ee.updating_action_type,'null') <> 'S' -- Bugfix 2249308
5947: and exists
5948: (select null
5949: from pay_element_links_f el,
5950: pay_element_types_f et
5951: where el.element_link_id = ee.element_link_id
5952: and el.element_type_id = et.element_type_id
5953: and et.processing_type = 'R')
5954: and ee.effective_end_date =

Line 5961: pay_element_types_f et

5957: 'L',nvl(p_last_standard_date,p_sot),
5958: 'F',nvl(p_final_process_date,p_sot),
5959: p_sot)
5960: from pay_element_links_f el,
5961: pay_element_types_f et
5962: where el.element_link_id = ee.element_link_id
5963: and et.element_type_id = el.element_type_id
5964: and ee.effective_start_date between el.effective_start_date
5965: and el.effective_end_date

Line 5982: pay_element_types_f et

5978: between effective_start_date and asg.effective_end_date
5979: and ptp.payroll_id = asg.payroll_id
5980: and p_final_process_date between ptp.start_date and ptp.end_date
5981: and exists ( select null from pay_element_entries_f ent,
5982: pay_element_types_f et
5983: where ent.assignment_id = asg.assignment_id
5984: and et.element_type_id = ent.element_type_id
5985: and et.processing_type = 'N'
5986: and ent.effective_end_date >= ptp.start_date);

Line 6308: pay_element_types_f et

6304: -- change 115.40
6305: --select null
6306: select /*+ index(ee pay_element_entries_f_n51) */ null
6307: from pay_element_entries_f ee,
6308: pay_element_types_f et
6309: where ee.element_type_id = et.element_type_id
6310: and et.processing_type = 'R'
6311: and ee.entry_type = 'E'
6312: and ee.assignment_id = p_assignment_id

Line 8028: , pay_element_types_f et

8024: ee.updating_action_type,
8025: ee.object_version_number
8026: from per_all_assignments_f asg
8027: , pay_element_entries_f ee
8028: , pay_element_types_f et
8029: where asg.assignment_id = c_assignment_id
8030: and asg.assignment_id = ee.assignment_id
8031: and ee.element_type_id = et.element_type_id
8032: and et.post_termination_rule = 'F'