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 1269: INDEX(piv PAY_INPUT_VALUES_F_PK)

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

Line 1316: pay_input_values_f piv,

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

Line 1385: pay_input_values_f piv,

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

Line 1736: INDEX(piv PAY_INPUT_VALUES_F_PK)

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

Line 1749: pay_input_values_f piv,

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

Line 1780: pay_input_values_f piv,

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