APPS.HR_ENTRY_API dependencies on PAY_LINK_INPUT_VALUES_F

Line 1268: INDEX(pliv PAY_LINK_INPUT_VALUES_F_N1)

1264: p_element_link_id number,
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,

Line 1315: from pay_link_input_values_f pliv,

1311: p_input_value_id13,'SET',
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

Line 1735: INDEX(pliv PAY_LINK_INPUT_VALUES_F_N1)

1731: p_element_link_id number,
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,

Line 1748: from pay_link_input_values_f pliv,

1744: piv.uom,
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