479: CURSOR csr_start_month
480: IS
481: --
482: SELECT org_information11 -- Switch Period Month
483: FROM hr_organization_information
484: WHERE organization_id = p_business_group_id
485: AND org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
486: AND org_information1 = p_contribution_area
487: AND org_information2 = p_phf_si_type
1818: -- 1.1 06-Jul-2004 sshankar Modified code as required to support --
1819: -- Enterprise Annuity. (Bug 3593118) --
1820: -- 1.2 15-Sep-2004 snekkala Modified code to fetch hukuo type --
1821: -- 1.3 05-Oct-2004 snekkala Modified the datatype from VARCHAR2(30) --
1822: -- to hr_organization_information --
1823: -- org_information5%TYPE
1824: -- 1.4 14-Mar-2008 dduvvuri Modified call to get_phf_si_rates (6828199) --
1825: ----------------------------------------------------------------------------
1826: FUNCTION get_employer_info(p_assignment_id IN NUMBER
1842: /* Changes for bug 6828199 end */
1843: l_ee_rounding_method VARCHAR2(30);
1844: l_er_rounding_method VARCHAR2(30);
1845: --
1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1844: l_er_rounding_method VARCHAR2(30);
1845: --
1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1845: --
1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --
1856: -- Bug 3904374 Changes end
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --
1856: -- Bug 3904374 Changes end
1857: --
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --
1856: -- Bug 3904374 Changes end
1857: --
1858:
1882: --
1883: CURSOR csr_org_currency(p_business_group_id IN NUMBER)
1884: IS
1885: SELECT hoi.org_information10
1886: FROM hr_organization_information hoi
1887: WHERE hoi.organization_id = p_business_group_id
1888: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'Business_Group_Information';
1889: --
1890:
1892: --
1893: CURSOR csr_ent_org_category(p_legal_employer_id IN NUMBER)
1894: IS
1895: SELECT hr_general.decode_lookup('CN_ENTRP_CATEGORY',hoi.org_information8)
1896: FROM hr_organization_information hoi
1897: WHERE hoi.organization_id = p_legal_employer_id
1898: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'PER_CORPORATE_INFO_CN';
1899: --
1900:
1902: --
1903: CURSOR csr_ent_org_code(p_legal_employer_id IN NUMBER)
1904: IS
1905: SELECT hoi.org_information7
1906: FROM hr_organization_information hoi
1907: WHERE hoi.organization_id = p_legal_employer_id
1908: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'PER_CORPORATE_INFO_CN';
1909: --
1910:
1918: ,hoi.org_information17 -- Maternity
1919: ,hoi.org_information19 -- Unemployment
1920: ,hoi.org_information7 -- Medical
1921: ,hoi.org_information3 -- Enterprise Annuity. (Bug 3593118)
1922: FROM hr_organization_information hoi
1923: WHERE hoi.organization_id = p_legal_employer_id
1924: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'PER_EMPLOYER_INFO_CN';
1925: --
1926: