DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on PAY_LINK_INPUT_VALUES_F

Line 1269: INDEX(pliv PAY_LINK_INPUT_VALUES_F_N1)

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

Line 1316: from pay_link_input_values_f pliv,

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

Line 1737: INDEX(pliv PAY_LINK_INPUT_VALUES_F_N1)

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

Line 1750: from pay_link_input_values_f pliv,

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