[Home] [Help]
1891: -- Cursor to fetch Enterprise Organisation Category
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: --
1983: -- If info required is Insurance Type
1984: --
1985: IF p_info_type = 'INSURANCE_TYPE' THEN
1986: --
1987: l_return_value := hr_general.decode_lookup(p_lookup_type => 'CN_PHF_SI_CODE'
1988: ,p_lookup_code => l_phf_si_type
1989: );
1990: hr_utility.set_location('China : Insurance Type -> '||l_return_value, 40);
1991: return l_return_value;
2276: --
2277: CURSOR csr_ethnic_group
2278: IS
2279: --
2280: SELECT hr_general.decode_lookup('CN_RACE',pap.per_information17)
2281: FROM per_all_assignments_f paa
2282: ,per_all_people_f pap
2283: WHERE paa.assignment_id = p_assignment_id
2284: AND pap.person_id = paa.person_id
2293: /*3592894, Removed table per_people_extra_info*/
2294: CURSOR csr_hukou_type
2295: IS
2296: --
2297: SELECT hr_general.decode_lookup('CN_HUKOU_TYPE',pap.per_information4 )
2298: FROM per_all_assignments_f paa
2299: ,per_all_people_f pap
2300: WHERE paa.assignment_id = p_assignment_id
2301: AND pap.person_id = paa.person_id
2328: --
2329: CURSOR csr_job_category
2330: IS
2331: --
2332: SELECT hr_general.decode_lookup('JOB_CATEGORIES', pjei.jei_information1)
2333: FROM per_all_assignments_f paa
2334: ,per_job_extra_info pjei
2335: WHERE paa.assignment_id = p_assignment_id
2336: AND pjei.job_id = paa.job_id