APPS.HR_ENTRY_API dependencies on PAY_INPUT_VALUES_F

Line 745: pay_input_values_f IV,

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'
749: and ET.element_type_id = IV.element_type_id

Line 763: from pay_input_values_f

759: -- bug 372339, 604543 and 651458 mlisieck/09.01.1998/07.04.1998
760: --
761: cursor csr_benefit_entry is
762: select input_value_id
763: from pay_input_values_f
764: where input_value_id = p_input_value_id and
765: name = 'Coverage';
766: --
767: cursor csr_session_date is

Line 774: from pay_input_values_f piv

770: where session_id = userenv('sessionid');
771: --
772: cursor csr_val_fmla is
773: select piv.formula_id
774: from pay_input_values_f piv
775: where piv.input_value_id = p_input_value_id
776: and p_session_date between piv.effective_start_date
777: and piv.effective_end_date;
778: --

Line 1270: INDEX(piv PAY_INPUT_VALUES_F_PK)

1266: p_session_date date
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,

Line 1317: pay_input_values_f piv,

1313: p_input_value_id14,'SET',
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

Line 1386: pay_input_values_f piv,

1382: p_input_value_id15,'SET',
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

Line 1738: INDEX(piv PAY_INPUT_VALUES_F_PK)

1734: p_session_date date
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,

Line 1751: pay_input_values_f piv,

1747: piv.mandatory_flag,
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

Line 1782: pay_input_values_f piv,

1778: eev.screen_entry_value peev_default_value,
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