APPS.HRENTMNT dependencies on PAY_ELEMENT_TYPES_F

Line 1131: pay_element_types_f et

1127: iv.value_set_id,
1128: et.input_currency_code
1129: from pay_element_entry_values_f eev,
1130: pay_input_values_f iv,
1131: pay_element_types_f et
1132: where eev.element_entry_id = p_element_entry_id
1133: and iv.input_value_id = eev.input_value_id
1134: and et.element_type_id = iv.element_type_id
1135: and eev.effective_end_date = p_date

Line 1737: pay_element_types_f pet,

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
1741: and pec.classification_id = pet.classification_id

Line 2304: pay_element_types_f et

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
2308: and ee.entry_type='E'

Line 2984: pay_element_types_f et

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')))
2988: and not exists

Line 3263: pay_element_types_f et

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: --
3267: -- Local Variables

Line 3355: ,pay_element_types_f et

3351: p_adjust_ee_source varchar2
3352: ) is
3353: select ee.*
3354: from pay_element_entries_f ee
3355: ,pay_element_types_f et
3356: where ee.assignment_id = p_assignment_id
3357: and ee.effective_start_date <= p_validation_end_date
3358: and ee.effective_end_date >= p_validation_start_date
3359: and ee.element_type_id = et.element_type_id

Line 3711: pay_element_types_f et

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')));
3715: --

Line 3919: PAY_ELEMENT_TYPES_F et,

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 =
3923: el.business_group_id

Line 4848: pay_element_types_f et

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
4852: and et.processing_type = 'R')

Line 5172: pay_element_types_f et

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')
5176: and ee.effective_end_date =

Line 5183: pay_element_types_f et

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
5187: and el.effective_end_date

Line 5476: pay_element_types_f et

5472: -- change 115.40
5473: --select null
5474: select /*+ index(ee pay_element_entries_f_n51) */ null
5475: from pay_element_entries_f ee,
5476: pay_element_types_f et
5477: where ee.element_type_id = et.element_type_id
5478: and et.processing_type = 'R'
5479: and ee.entry_type = 'E'
5480: and ee.assignment_id = p_assignment_id

Line 7004: , pay_element_types_f et

7000: ee.updating_action_id,
7001: ee.object_version_number
7002: from per_all_assignments_f asg
7003: , pay_element_entries_f ee
7004: , pay_element_types_f et
7005: where asg.assignment_id = c_assignment_id
7006: and asg.assignment_id = ee.assignment_id
7007: and ee.element_type_id = et.element_type_id
7008: and et.post_termination_rule = 'F'