APPS.PAY_JP_ENTRIES_PKG dependencies on PAY_INPUT_VALUES_F

Line 152: from pay_input_values_f piv

148: select piv.input_value_id,
149: piv.display_sequence,
150: piv.uom,
151: piv.mandatory_flag
152: from pay_input_values_f piv
153: where piv.element_type_id = p_element_type_id
154: and p_effective_date
155: between piv.effective_start_date and piv.effective_end_date;
156: Begin

Line 298: from pay_input_values_f piv,

294: piv.lookup_type,
295: decode(piv.hot_default_flag,
296: 'Y',nvl(pliv.default_value,piv.default_value),
297: pliv.default_value))) D_DEFAULT_VALUE
298: from pay_input_values_f piv,
299: pay_link_input_values_f pliv
300: where pliv.element_link_id = p_element_link_id
301: and p_effective_date
302: between pliv.effective_start_date and pliv.effective_end_date

Line 492: pay_input_values_f_tl pivtl,

488: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
489: pliv.warning_or_error) WARNING_OR_ERROR,
490: pet.input_currency_code
491: from pay_element_types_f pet,
492: pay_input_values_f_tl pivtl,
493: pay_input_values_f piv,
494: pay_link_input_values_f pliv
495: where pliv.element_link_id = p_element_link_id
496: and pliv.input_value_id = p_input_value_id

Line 493: pay_input_values_f piv,

489: pliv.warning_or_error) WARNING_OR_ERROR,
490: pet.input_currency_code
491: from pay_element_types_f pet,
492: pay_input_values_f_tl pivtl,
493: pay_input_values_f piv,
494: pay_link_input_values_f pliv
495: where pliv.element_link_id = p_element_link_id
496: and pliv.input_value_id = p_input_value_id
497: and p_effective_date