DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_INPUT_VALUES_F

Line 1563: pay_input_values_f piv,

1559: FROM pay_run_results prr,
1560: pay_run_result_values prrv,
1561: pay_assignment_actions paa,
1562: pay_payroll_actions ppa,
1563: pay_input_values_f piv,
1564: pay_balance_feeds_f pbf,
1565: pay_balance_types pbt,
1566: per_assignments_f paf
1567: WHERE pbt.balance_name = 'Profit Sharing'

Line 1664: ,pay_input_values_f piv

1660:
1661: CURSOR c_input_value_id IS
1662: SELECT piv.input_value_id
1663: FROM pay_element_types_f pet
1664: ,pay_input_values_f piv
1665: WHERE pet.legislation_code = 'MX'
1666: AND pet.element_name = 'Annual Tax Adjustment'
1667: AND piv.element_type_id = pet.element_type_id
1668: AND piv.name = 'Calculation Mode';