APPS.HR_ENTRY_API dependencies on PAY_ELEMENT_TYPES_F

Line 744: from pay_element_types_f ET,

740: p_lookup_code varchar2,
741: v_session_date date
742: ) is
743: select IV.input_value_id
744: from pay_element_types_f ET,
745: pay_input_values_f IV,
746: ben_benefit_classifications BCL
747: where IV.input_value_id = p_input_value_id
748: and IV.name = 'Coverage'

Line 1270: INDEX(et PAY_ELEMENT_TYPES_F_PK)

1266: ) is
1267: select /*+ ORDERED
1268: INDEX(pliv PAY_LINK_INPUT_VALUES_F_N1)
1269: INDEX(piv PAY_INPUT_VALUES_F_PK)
1270: INDEX(et PAY_ELEMENT_TYPES_F_PK)
1271: USE_NL(PLIV ET PIV) */
1272: pliv.input_value_id,
1273: pliv.default_value pliv_default_value,
1274: piv.hot_default_flag,

Line 1317: pay_element_types_f et

1313: p_input_value_id15,'SET',
1314: 'NOT_SET') entry_specified
1315: from pay_link_input_values_f pliv,
1316: pay_input_values_f piv,
1317: pay_element_types_f et
1318: where pliv.element_link_id = p_element_link_id
1319: and piv.input_value_id = pliv.input_value_id
1320: and et.element_type_id = piv.element_type_id
1321: and p_session_date between pliv.effective_start_date

Line 1386: pay_element_types_f et

1382: 'NOT_SET') entry_specified
1383: from pay_element_entry_values_f eev,
1384: pay_element_entries_f ee,
1385: pay_input_values_f piv,
1386: pay_element_types_f et
1387: where ee.element_entry_id = p_element_entry_id
1388: and eev.element_entry_id = ee.element_entry_id
1389: and piv.input_value_id = eev.input_value_id
1390: and et.element_type_id = piv.element_type_id

Line 1737: INDEX(et PAY_ELEMENT_TYPES_F_PK)

1733: ) is
1734: select /*+ ORDERED
1735: INDEX(pliv PAY_LINK_INPUT_VALUES_F_N1)
1736: INDEX(piv PAY_INPUT_VALUES_F_PK)
1737: INDEX(et PAY_ELEMENT_TYPES_F_PK)
1738: USE_NL(PLIV ET PIV) */
1739: pliv.input_value_id,
1740: pliv.default_value pliv_default_value,
1741: piv.hot_default_flag,

Line 1750: pay_element_types_f et

1746: piv.default_value piv_default_value,
1747: et.input_currency_code
1748: from pay_link_input_values_f pliv,
1749: pay_input_values_f piv,
1750: pay_element_types_f et
1751: where pliv.element_link_id = p_element_link_id
1752: and piv.input_value_id = pliv.input_value_id
1753: and et.element_type_id = piv.element_type_id
1754: and p_session_date between pliv.effective_start_date

Line 1781: pay_element_types_f et

1777: eev.screen_entry_value
1778: from pay_element_entry_values_f eev,
1779: pay_element_entries_f ee,
1780: pay_input_values_f piv,
1781: pay_element_types_f et
1782: where ee.element_entry_id = p_element_entry_id
1783: and eev.element_entry_id = ee.element_entry_id
1784: and piv.input_value_id = eev.input_value_id
1785: and et.element_type_id = piv.element_type_id

Line 2235: from pay_element_types_f elt,

2231: and ppm1.assignment_id = p_assignment_id;
2232: --
2233: cursor third_party_element is
2234: select 1
2235: from pay_element_types_f elt,
2236: pay_element_links_f eli
2237: where eli.element_link_id = p_element_link_id
2238: and eli.element_type_id = elt.element_type_id
2239: and p_effective_start_date <= eli.effective_end_date

Line 2335: from pay_element_types_f ELT,

2331: p_entry_type varchar2) is
2332: --
2333: cursor processing_type is
2334: select 1
2335: from pay_element_types_f ELT,
2336: pay_element_links_f ELI
2337: where eli.element_link_id = p_element_link_id
2338: and eli.element_type_id = elt.element_type_id
2339: and p_effective_start_date <= eli.effective_end_date

Line 2601: pay_element_types_f et

2597: and ee.entry_type = 'E'
2598: and exists
2599: (select null
2600: from pay_element_links_f el,
2601: pay_element_types_f et
2602: where el.element_link_id = p_element_link_id
2603: and et.element_type_id = el.element_type_id
2604: and et.processing_type = 'R')
2605: and p_validation_start_date between ee.effective_start_date

Line 2657: ,pay_element_types_f et

2653: is
2654: select 1
2655: from pay_element_entries_f ee
2656: ,pay_element_links_f el
2657: ,pay_element_types_f et
2658: where ee.assignment_id = p_assignment_id
2659: and nvl(ee.original_entry_id, ee.element_entry_id)
2660: = p_original_entry_id
2661: and ee.entry_type = 'E'

Line 2703: ,pay_element_types_f et

2699: where exists
2700: (select null
2701: from pay_element_entries_f ee
2702: ,pay_element_links_f el
2703: ,pay_element_types_f et
2704: where ee.assignment_id = p_assignment_id
2705: and ee.element_link_id = p_element_link_id
2706: and ee.element_entry_id = p_original_entry_id
2707: and ee.entry_type = 'E'

Line 2803: l_ele_type_id pay_element_types_f.element_type_id%type;

2799: FUNCTION derive_element_type_id (p_element_link_id in number
2800: ,p_effective_date in date)
2801: RETURN number IS
2802: --
2803: l_ele_type_id pay_element_types_f.element_type_id%type;
2804: --
2805: BEGIN
2806: select element_type_id
2807: into l_ele_type_id

Line 3717: l_element_type_id pay_element_types_f.element_type_id%type;

3713: --
3714: v_validation_start_date date;
3715: v_validation_end_date date;
3716: --
3717: l_element_type_id pay_element_types_f.element_type_id%type;
3718: --
3719: l_all_entry_values_null varchar2(30);
3720: --
3721: begin

Line 5504: pay_element_types_f et

5500: decode(p_entry_information30,hr_api.g_varchar2,ee.entry_information30,p_entry_information30)
5501: into v_entry_rec
5502: from pay_element_entries_f ee,
5503: pay_element_links_f el,
5504: pay_element_types_f et
5505: where ee.element_entry_id = p_element_entry_id
5506: and el.element_link_id = ee.element_link_id
5507: and et.element_type_id = el.element_type_id
5508: and p_session_date between ee.effective_start_date

Line 7992: pay_element_types_f et,

7988: ee.personal_payment_method_id
7989: into v_entry_rec
7990: from pay_element_entries_f ee,
7991: pay_element_links_f el,
7992: pay_element_types_f et,
7993: pay_element_classifications ec
7994: where ee.element_entry_id = p_element_entry_id
7995: and el.element_link_id = ee.element_link_id
7996: and et.element_type_id = el.element_type_id