DBA Data[Home] [Help]

APPS.PAY_IE_MEDICAL_ADJUST dependencies on PAY_INPUT_VALUES_F

Line 30: FROM pay_input_values_f

26: element_rec element_csr%ROWTYPE;
27: --
28: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
29: SELECT input_value_id
30: FROM pay_input_values_f
31: WHERE element_type_id = p_element_type_id
32: AND name = p_name
33: --AND nvl(business_group_id, p_bg_id) = p_bg_id
34: AND legislation_code = 'IE'

Line 197: from pay_input_values_f

193: -- Cursor to get input_val_id
194: cursor csr_get_input_val_id (p_ele_type_id in number,
195: p_input_val_name in varchar2) IS
196: select distinct input_value_id
197: from pay_input_values_f
198: where name = p_input_val_name
199: and legislation_code = 'IE'
200: and element_type_id = p_ele_type_id;
201: