[Home] [Help]
1746: ,per_periods_of_service pps
1747: ,pay_assignment_actions pac
1748: ,pay_payroll_actions ppa
1749: ,pay_element_entries_f pee
1750: ,pay_run_results prr
1751: ,pay_element_types_f pet
1752: ,pay_balance_types pbt
1753: WHERE paa.assignment_id = c_assignment_id
1754: AND pet.element_information_category = 'AU_EARNINGS'
1780: select distinct NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
1781: , prv.result_value balance_value
1782: from
1783: pay_element_entries_f pee,
1784: pay_run_results prr,
1785: pay_run_result_values prv,
1786: pay_element_types_f pet,
1787: pay_balance_types pbt
1788: where
2075: --, pay_balance_dimensions pbd
2076: --, per_periods_of_service pps
2077: , pay_payroll_actions ppa
2078: , pay_assignment_actions pac
2079: , pay_run_results prr
2080: where pac.assignment_id = c_assignment_id
2081: and pac.tax_unit_id = p_registered_employer --2610141
2082: and paa.assignment_id = pac.assignment_id
2083: and pac.payroll_action_id = ppa.payroll_Action_id
2261: ,ppa.effective_date
2262: from pay_element_types_f pet
2263: ,pay_input_values_f piv
2264: ,per_all_assignments_f paa
2265: ,pay_run_results prr
2266: ,pay_run_result_values prv
2267: ,pay_assignment_actions pac
2268: ,pay_payroll_actions ppa
2269: ,pay_payrolls_f papf /* bug Number 4278361 */
2441: , pay_balance_types pbt
2442: , pay_defined_balances pdb
2443: , pay_payroll_actions ppa
2444: , pay_assignment_actions pac
2445: , pay_run_results prr
2446: , pay_balance_feeds_f pbf
2447: , pay_input_values_f piv
2448: where pac.assignment_id = p_assignment_id
2449: and pac.tax_unit_id = p_registered_employer
2956: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
2957: from pay_element_types_f pet
2958: ,pay_input_values_f piv
2959: ,per_all_assignments_f paa
2960: ,pay_run_results prr
2961: ,pay_run_result_values prv
2962: ,pay_assignment_actions pac
2963: ,pay_payroll_actions ppa
2964: where pet.element_type_id = piv.element_type_id