DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_INPUT_VALUES_F

Line 204: FROM pay_input_values_f piv,

200:
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'

Line 394: pay_input_values_f piv

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
398: and prr.input_value_id = piv.input_value_id