[Home] [Help]
443: ,p_business_group_id NUMBER
444: ,p_effective_date DATE) IS
445: CURSOR get_cac_wc IS
446: SELECT 'x'
447: FROM hr_organization_information hoi,hr_all_organization_units hou
448: WHERE hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
449: AND hou.organization_id = hoi.organization_id
450: AND org_information1 = p_org_info
451: AND hou.business_group_id = p_business_group_id
458: and hoi1.org_information2 = 'Y');
459:
460: CURSOR get_cac_statutory IS
461: SELECT 'x'
462: FROM hr_organization_information hoi,hr_all_organization_units hou
463: WHERE hoi.org_information_context = 'ES_STATUTORY_INFO'
464: AND hou.organization_id = hoi.organization_id
465: AND org_information8 = p_org_info
466: AND hou.business_group_id = p_business_group_id
505: ,p_business_group_id NUMBER
506: ,p_effective_date DATE) IS
507: CURSOR get_ss_code IS
508: SELECT 'x'
509: FROM hr_organization_information hoi,hr_all_organization_units hou
510: WHERE hoi.org_information_context in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS')
511: AND hou.organization_id = hoi.organization_id
512: AND org_information1 = p_org_info
513: AND hou.business_group_id = p_business_group_id
544: ,p_business_group_id NUMBER
545: ,p_effective_date DATE) IS
546: CURSOR get_cif IS
547: SELECT 'x'
548: FROM hr_organization_information hoi,hr_all_organization_units hou
549: WHERE hoi.org_information_context = 'ES_STATUTORY_INFO'
550: AND hou.organization_id = hoi.organization_id
551: AND org_information5 = p_org_info
552: AND hou.business_group_id = p_business_group_id
579:
580: CURSOR csr_chk_wc_sec_ref IS
581: SELECT 'x'
582: FROM hr_organization_information hoi
583: ,hr_all_organization_units hou
584: WHERE hoi.org_information_context = p_context
585: AND hoi.org_information1 = p_org_information1
586: AND hoi.organization_id = hou.organization_id
587: AND hou.business_group_id = p_business_group_id