[Home] [Help]
1632: END get_element_info;
1633:
1634: --For bug fix 3567562
1635: --Added a new procedure to get the PAYE reference attributed to payrolls within a consolidation set.
1636: PROCEDURE get_paye_reference(p_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
1637: ,g_paye_ref in out nocopy varchar2
1638: ,p_business_group_id varchar2
1639: ,p_start_date date
1640: ,p_end_date date
1793: AND org.org_information2 = g_paye_ref;
1794:
1795:
1796: -- cursor csr_get_org_tax_address
1797: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
1798: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
1799: ) IS
1800: SELECT org_info.org_information3 employer_tax_addr1
1801: ,org_info.org_information4 employer_tax_addr2
1808: ,pcs.business_group_id business_group_id
1809: --
1810: FROM hr_all_organization_units org_all
1811: ,hr_organization_information org_info
1812: ,pay_consolidation_sets pcs
1813: WHERE pcs.consolidation_set_id = c_consolidation_set
1814: AND org_all.organization_id = pcs.business_group_id
1815: AND org_info.organization_id = org_all.organization_id
1816: AND org_info.org_information_context = 'IE_ORG_INFORMATION'
2908: AND org.org_information2 = g_paye_ref;
2909:
2910:
2911: -- cursor csr_get_org_tax_address
2912: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
2913: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
2914: ) IS
2915: SELECT hrl.address_line_1 employer_tax_addr1
2916: ,hrl.address_line_2 employer_tax_addr2
2923: ,pcs.business_group_id business_group_id
2924: --
2925: FROM hr_all_organization_units org_all
2926: ,hr_organization_information org_info
2927: ,pay_consolidation_sets pcs
2928: ,hr_locations_all hrl
2929: WHERE pcs.consolidation_set_id = c_consolidation_set
2930: AND org_all.business_group_id = pcs.business_group_id
2931: AND org_info.organization_id = org_all.organization_id