DBA Data[Home] [Help]

APPS.PAY_P45_PKG2 dependencies on PAY_ELEMENT_TYPES_F

Line 167: FROM pay_element_types_f

163: l_paye_id number;
164: --
165: cursor csr_paye_id(c_effective_date in date) is
166: SELECT element_type_id
167: FROM pay_element_types_f
168: WHERE element_name = 'PAYE Details'
169: AND c_effective_date BETWEEN effective_start_date
170: AND effective_end_date;
171: --

Line 285: FROM pay_element_types_f

281: l_max_run_result_id number;
282: --
283: CURSOR csr_paye_element IS
284: SELECT element_type_id
285: FROM pay_element_types_f
286: WHERE element_name = 'PAYE';
287: --
288: CURSOR csr_input_value(p_ipv_name IN VARCHAR2) IS
289: SELECT input_value_id