DBA Data[Home] [Help]

APPS.HR_PAY_INTERFACE_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 1069: pay_link_input_values_f pliv

1065: piv.default_value,
1066: pliv.default_value) screen_entry_value
1067: into hot_default_value
1068: from pay_input_values_f piv,
1069: pay_link_input_values_f pliv
1070: where pliv.element_link_id = p_element_link_id
1071: and pliv.effective_start_date =
1072: (select max(pliv2.effective_start_date)
1073: from pay_link_input_values_f pliv2

Line 1073: from pay_link_input_values_f pliv2

1069: pay_link_input_values_f pliv
1070: where pliv.element_link_id = p_element_link_id
1071: and pliv.effective_start_date =
1072: (select max(pliv2.effective_start_date)
1073: from pay_link_input_values_f pliv2
1074: where pliv2.effective_start_date <= trunc(sysdate)
1075: and pliv2.element_link_id = p_element_link_id
1076: and pliv2.input_value_id = p_input_value_id)
1077: and pliv.input_value_id = p_input_value_id