DBA Data[Home] [Help]

APPS.PAY_LINK_INPUT_VALUES_API dependencies on HR_LOOKUPS

Line 194: l_lookup_type hr_lookups.lookup_type%type;

190: l_default_value pay_link_input_values_f.default_value%type := p_default_value;
191: l_element_link_id pay_link_input_values_f.element_link_id%type;
192: l_input_value_id pay_link_input_values_f.input_value_id%type;
193: l_object_version_number pay_link_input_values_f.object_version_number%type;
194: l_lookup_type hr_lookups.lookup_type%type;
195:
196: Cursor c_link_input_value_id
197: is
198: select element_link_id, input_value_id

Line 221: from hr_lookups

217:
218: Cursor c_lookup_code(p_lookup_type varchar2)
219: is
220: select lookup_code
221: from hr_lookups
222: where lookup_type = p_lookup_type
223: and upper(meaning) = p_default_value
224: and enabled_flag = 'Y'
225: and p_effective_date between nvl(start_date_active, p_effective_date)