DBA Data[Home] [Help]

APPS.PAY_IE_PAYE_API dependencies on PAY_INPUT_VALUES_F

Line 42: FROM pay_input_values_f

38: element_rec element_csr%ROWTYPE;
39: --
40: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
41: SELECT input_value_id
42: FROM pay_input_values_f
43: WHERE element_type_id = p_element_type_id
44: AND name = p_name
45: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
46: AND nvl(legislation_code, 'IE') = 'IE'

Line 229: FROM pay_input_values_f

225: element_rec element_csr%ROWTYPE;
226: --
227: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
228: SELECT input_value_id
229: FROM pay_input_values_f
230: WHERE element_type_id = p_element_type_id
231: AND name = p_name
232: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
233: AND nvl(legislation_code, 'IE') = 'IE'

Line 554: FROM pay_input_values_f

550: element_rec element_csr%ROWTYPE;
551: --
552: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
553: SELECT input_value_id
554: FROM pay_input_values_f
555: WHERE element_type_id = p_element_type_id
556: AND name = p_name
557: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
558: AND nvl(legislation_code, 'IE') = 'IE'