APPS.PAY_JP_ENTRIES_PKG dependencies on PAY_INPUT_VALUES_F

Line 158: from pay_input_values_f piv

154: select piv.input_value_id,
155: piv.display_sequence,
156: piv.uom,
157: piv.mandatory_flag
158: from pay_input_values_f piv
159: where piv.element_type_id = p_element_type_id
160: and p_eff_date
161: between piv.effective_start_date and piv.effective_end_date;
162: Begin

Line 314: from pay_input_values_f piv,

310: piv.lookup_type,
311: decode(piv.hot_default_flag,
312: 'Y',nvl(pliv.default_value,piv.default_value),
313: pliv.default_value))) D_DEFAULT_VALUE
314: from pay_input_values_f piv,
315: pay_link_input_values_f pliv
316: where pliv.element_link_id = p_element_link_id
317: and p_effective_date
318: between pliv.effective_start_date and pliv.effective_end_date

Line 508: pay_input_values_f_tl pivtl,

504: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
505: pliv.warning_or_error) WARNING_OR_ERROR,
506: pet.input_currency_code
507: from pay_element_types_f pet,
508: pay_input_values_f_tl pivtl,
509: pay_input_values_f piv,
510: pay_link_input_values_f pliv
511: where pliv.element_link_id = p_element_link_id
512: and pliv.input_value_id = p_input_value_id

Line 509: pay_input_values_f piv,

505: pliv.warning_or_error) WARNING_OR_ERROR,
506: pet.input_currency_code
507: from pay_element_types_f pet,
508: pay_input_values_f_tl pivtl,
509: pay_input_values_f piv,
510: pay_link_input_values_f pliv
511: where pliv.element_link_id = p_element_link_id
512: and pliv.input_value_id = p_input_value_id
513: and p_effective_date