[Home] [Help]
1919: END get_element_info;
1920:
1921: --For bug fix 3567562
1922: --Added a new procedure to get the PAYE reference attributed to payrolls within a consolidation set.
1923: PROCEDURE get_paye_reference(p_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
1924: ,g_paye_ref in out nocopy varchar2
1925: ,p_business_group_id varchar2
1926: ,p_start_date date
1927: ,p_end_date date
2080: AND org.org_information2 = g_paye_ref;
2081:
2082:
2083: -- cursor csr_get_org_tax_address
2084: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
2085: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
2086: ) IS
2087: SELECT org_info.org_information3 employer_tax_addr1
2088: ,org_info.org_information4 employer_tax_addr2
2095: ,pcs.business_group_id business_group_id
2096: --
2097: FROM hr_all_organization_units org_all
2098: ,hr_organization_information org_info
2099: ,pay_consolidation_sets pcs
2100: WHERE pcs.consolidation_set_id = c_consolidation_set
2101: AND org_all.organization_id = pcs.business_group_id
2102: AND org_info.organization_id = org_all.organization_id
2103: AND org_info.org_information_context = 'IE_ORG_INFORMATION'
3223: AND org.org_information2 = g_paye_ref;
3224:
3225:
3226: -- cursor csr_get_org_tax_address
3227: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
3228: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
3229: ) IS
3230: SELECT hrl.address_line_1 employer_tax_addr1
3231: ,hrl.address_line_2 employer_tax_addr2
3238: ,pcs.business_group_id business_group_id
3239: --
3240: FROM hr_all_organization_units org_all
3241: ,hr_organization_information org_info
3242: ,pay_consolidation_sets pcs
3243: ,hr_locations_all hrl
3244: WHERE pcs.consolidation_set_id = c_consolidation_set
3245: AND org_all.business_group_id = pcs.business_group_id
3246: AND org_info.organization_id = org_all.organization_id