APPS.PAY_KR_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_effective_date between piv.effective_start_date
161: and piv.effective_end_date;
162:

Line 338: from pay_input_values_f piv,

334: piv.lookup_type,
335: decode(piv.hot_default_flag,
336: 'Y',nvl(pliv.default_value,piv.default_value),
337: pliv.default_value))) D_DEFAULT_VALUE
338: from pay_input_values_f piv,
339: pay_link_input_values_f pliv
340: where pliv.element_link_id = p_element_link_id
341: and p_effective_date between pliv.effective_start_date
342: and pliv.effective_end_date

Line 532: pay_input_values_f_tl pivtl,

528: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
529: pliv.warning_or_error) WARNING_OR_ERROR,
530: pet.input_currency_code
531: from pay_element_types_f pet,
532: pay_input_values_f_tl pivtl,
533: pay_input_values_f piv,
534: pay_link_input_values_f pliv
535: where pliv.element_link_id = p_element_link_id
536: and pliv.input_value_id = p_input_value_id

Line 533: pay_input_values_f piv,

529: pliv.warning_or_error) WARNING_OR_ERROR,
530: pet.input_currency_code
531: from pay_element_types_f pet,
532: pay_input_values_f_tl pivtl,
533: pay_input_values_f piv,
534: pay_link_input_values_f pliv
535: where pliv.element_link_id = p_element_link_id
536: and pliv.input_value_id = p_input_value_id
537: and p_effective_date between pliv.effective_start_date