DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_INPUT_VALUES_F

Line 201: FROM pay_input_values_f piv,

197:
198: CURSOR csr_input_value_id (l_element_name VARCHAR2,
199: l_piv_name VARCHAR2) IS
200: SELECT input_value_id
201: FROM pay_input_values_f piv,
202: pay_element_types_f pet
203: WHERE piv.element_type_id = pet.element_type_id
204: AND pet.element_name = l_element_name
205: AND pet.legislation_code = 'GB'

Line 386: pay_input_values_f piv

382: SELECT result_value
383: FROM pay_run_result_values prr,
384: pay_run_results pr,
385: pay_element_types_f pet,
386: pay_input_values_f piv
387: WHERE pr.assignment_action_id = p_assig_act_id
388: and pr.element_type_id = pet.element_type_id
389: and pr.run_result_id = prr.run_result_id
390: and prr.input_value_id = piv.input_value_id