[Home] [Help]
2259: ,ppa.payroll_action_id
2260: ,pac.assignment_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
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
2450: and paa.assignment_id = pac.assignment_id
2451: and pac.payroll_action_id = ppa.payroll_Action_id
2661: , pet.element_information_category
2662: , pet.element_information1
2663: from pay_balance_types pbt
2664: , pay_balance_feeds_f pbf
2665: , pay_input_values_f piv
2666: , pay_element_types_f pet
2667: , pay_element_entries_f pee
2668: , pay_element_links_f pel
2669: , per_all_people_f pap
2889: from hr_organization_information hoi,
2890: hr_organization_units hou,
2891: hr_soft_coding_keyflex hsc,
2892: pay_element_types_f pet,
2893: pay_input_values_f piv,
2894: pay_element_links_f pel,
2895: pay_element_entries_f pee,
2896: pay_element_entry_values_f pev,
2897: per_all_assignments_f paa,
2954: c_year_start date ,
2955: c_year_end date ) IS
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
3802: is
3803: select pev.screen_entry_value tfn_no
3804: from
3805: pay_element_types_f pet,
3806: pay_input_values_f piv,
3807: pay_element_links_f pel,
3808: pay_element_entries_f pee,
3809: pay_element_entry_values_f pev
3810: where pet.element_name = 'Tax Information'