DBA Data[Home] [Help]

APPS.PAY_KR_SEP_FORM_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 1020: pay_link_input_values_f pliv

1016: pet.input_currency_code
1017: from pay_element_types_f pet,
1018: pay_input_values_f_tl pivtl,
1019: pay_input_values_f piv,
1020: pay_link_input_values_f pliv
1021: where pliv.element_link_id = p_element_link_id
1022: and pliv.input_value_id = p_input_value_id
1023: and p_effective_date
1024: between pliv.effective_start_date and pliv.effective_end_date

Line 1859: pay_link_input_values_f pliv

1855: 'Y',nvl(pliv.default_value,piv.default_value),
1856: pliv.default_value)) b_default_value
1857: from pay_element_types_f pet,
1858: pay_input_values_f piv,
1859: pay_link_input_values_f pliv
1860: where pliv.element_link_id = p_element_link_id
1861: and p_effective_date
1862: between pliv.effective_start_date and pliv.effective_end_date
1863: and piv.input_value_id = pliv.input_value_id

Line 2059: pay_link_input_values_f pliv

2055: 'Y',nvl(pliv.default_value,piv.default_value),
2056: pliv.default_value)))),piv.uom,pet.output_currency_code),1,60) entry_value
2057: from pay_element_types_f pet,
2058: pay_input_values_f piv,
2059: pay_link_input_values_f pliv
2060: where pliv.element_link_id = p_el_element_link_id
2061: and pliv.input_value_id = l_input_value_id
2062: and g_session_date /* set by get_input_value_id */
2063: between pliv.effective_start_date and pliv.effective_end_date