DBA Data[Home] [Help]

APPS.PAY_IE_PAYE_API dependencies on PAY_INPUT_VALUES_F

Line 38: FROM pay_input_values_f

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

Line 197: FROM pay_input_values_f

193: element_rec element_csr%ROWTYPE;
194: --
195: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
196: SELECT input_value_id
197: FROM pay_input_values_f
198: WHERE element_type_id = p_element_type_id
199: AND name = p_name
200: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
201: AND nvl(legislation_code, 'IE') = 'IE'

Line 484: FROM pay_input_values_f

480: element_rec element_csr%ROWTYPE;
481: --
482: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
483: SELECT input_value_id
484: FROM pay_input_values_f
485: WHERE element_type_id = p_element_type_id
486: AND name = p_name
487: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
488: AND nvl(legislation_code, 'IE') = 'IE'