DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 205: pay_element_types_f pet

201: CURSOR csr_input_value_id (l_element_name VARCHAR2,
202: l_piv_name VARCHAR2) IS
203: SELECT input_value_id
204: FROM pay_input_values_f piv,
205: pay_element_types_f pet
206: WHERE piv.element_type_id = pet.element_type_id
207: AND pet.element_name = l_element_name
208: AND pet.legislation_code = 'GB'
209: AND piv.name = l_piv_name;

Line 393: pay_element_types_f pet,

389: cursor result_type_value(p_piv_id NUMBER, p_assig_act_id NUMBER) is
390: SELECT result_value
391: FROM pay_run_result_values prr,
392: pay_run_results pr,
393: pay_element_types_f pet,
394: pay_input_values_f piv
395: WHERE pr.assignment_action_id = p_assig_act_id
396: and pr.element_type_id = pet.element_type_id
397: and pr.run_result_id = prr.run_result_id