DBA Data[Home] [Help]

APPS.HR_PAY_INTERFACE_PKG dependencies on PAY_INPUT_VALUES_F

Line 1068: from pay_input_values_f piv,

1064: null,
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)

Line 1080: from pay_input_values_f piv2

1076: and pliv2.input_value_id = p_input_value_id)
1077: and pliv.input_value_id = p_input_value_id
1078: and piv.effective_start_date =
1079: (select max(piv2.effective_start_date)
1080: from pay_input_values_f piv2
1081: where piv2.effective_start_date <= trunc(sysdate)
1082: and piv2.input_value_id = p_input_value_id
1083: and hot_default_flag = 'Y')
1084: and piv.input_value_id = p_input_value_id