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 1271: INDEX(et PAY_ELEMENT_TYPES_F_PK)

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

Line 1318: pay_element_types_f et

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

Line 1387: pay_element_types_f et

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

Line 1739: INDEX(et PAY_ELEMENT_TYPES_F_PK)

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

Line 1752: pay_element_types_f et

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

Line 1783: pay_element_types_f et

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

Line 2237: from pay_element_types_f elt,

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

Line 2337: from pay_element_types_f ELT,

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

Line 2603: pay_element_types_f et

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

Line 2659: ,pay_element_types_f et

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

Line 2705: ,pay_element_types_f et

2701: where exists
2702: (select null
2703: from pay_element_entries_f ee
2704: ,pay_element_links_f el
2705: ,pay_element_types_f et
2706: where ee.assignment_id = p_assignment_id
2707: /*Bug fix 12364433 */
2708: /*and ee.element_link_id = p_element_link_id*/
2709: and ee.element_entry_id = p_original_entry_id

Line 2806: l_ele_type_id pay_element_types_f.element_type_id%type;

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

Line 3720: l_element_type_id pay_element_types_f.element_type_id%type;

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

Line 5507: pay_element_types_f et

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

Line 8008: pay_element_types_f et,

8004: ee.personal_payment_method_id
8005: into v_entry_rec
8006: from pay_element_entries_f ee,
8007: pay_element_links_f el,
8008: pay_element_types_f et,
8009: pay_element_classifications ec
8010: where ee.element_entry_id = p_element_entry_id
8011: and el.element_link_id = ee.element_link_id
8012: and et.element_type_id = el.element_type_id