[Home] [Help]
1745: FROM per_all_assignments_f paa
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
1773:
1774:
1775:
1776:
1777: Cursor Get_Retro_allowances(c_element_entry_id pay_element_entries_f.element_entry_id%type
1778: )
1779: IS
1780: select distinct NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
1781: , prv.result_value balance_value
1779: IS
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
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
2670: , per_periods_of_service pps
2671: , per_all_assignments_f paa
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,
2898: per_all_people_f pap,
2899: per_addresses pad,
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'
3811: and piv.name = 'Tax File Number'
3812: and pet.element_type_id = piv.element_type_id