APPS.PAY_KR_ENTRIES_PKG dependencies on PAY_INPUT_VALUES_F

Line 161: from pay_input_values_f piv

157: select piv.input_value_id,
158: piv.display_sequence,
159: piv.uom,
160: piv.mandatory_flag
161: from pay_input_values_f piv
162: where piv.element_type_id = p_element_type_id
163: and p_effective_date between piv.effective_start_date
164: and piv.effective_end_date;
165:

Line 341: from pay_input_values_f piv,

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

Line 535: pay_input_values_f_tl pivtl,

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

Line 536: pay_input_values_f piv,

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