[Home] [Help]
504: ,p_business_group_id NUMBER
505: ,p_effective_date DATE) IS
506: CURSOR get_cac_wc IS
507: SELECT 'x'
508: FROM hr_organization_information hoi,hr_all_organization_units hou
509: WHERE hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
510: AND hou.organization_id = hoi.organization_id
511: AND org_information1 = p_org_info
512: AND hou.business_group_id = p_business_group_id
511: AND org_information1 = p_org_info
512: AND hou.business_group_id = p_business_group_id
513: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
514: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
515: AND exists (select 1 from hr_organization_information hoi1
516: where hoi1.org_information1 = 'ES_WORK_CENTER'
517: and hoi1.org_information_context = 'CLASS'
518: and hoi1.organization_id = hoi.organization_id
519: and hoi1.org_information2 = 'Y');
519: and hoi1.org_information2 = 'Y');
520:
521: CURSOR get_cac_statutory IS
522: SELECT 'x'
523: FROM hr_organization_information hoi,hr_all_organization_units hou
524: WHERE hoi.org_information_context = 'ES_STATUTORY_INFO'
525: AND hou.organization_id = hoi.organization_id
526: AND org_information8 = p_org_info
527: AND hou.business_group_id = p_business_group_id
526: AND org_information8 = p_org_info
527: AND hou.business_group_id = p_business_group_id
528: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
529: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
530: AND exists (select 1 from hr_organization_information hoi1
531: where hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
532: and hoi1.org_information_context = 'CLASS'
533: and hoi1.organization_id = hoi.organization_id
534: and hoi1.org_information2 = 'Y');
585: ,p_business_group_id NUMBER
586: ,p_effective_date DATE) IS
587: CURSOR get_ss_code IS
588: SELECT 'x'
589: FROM hr_organization_information hoi,hr_all_organization_units hou
590: WHERE hoi.org_information_context in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS')
591: AND hou.organization_id = hoi.organization_id
592: AND org_information1 = p_org_info
593: AND hou.business_group_id = p_business_group_id
592: AND org_information1 = p_org_info
593: AND hou.business_group_id = p_business_group_id
594: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
595: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
596: AND exists (select 1 from hr_organization_information hoi1
597: where hoi1.org_information1 in( 'ES_SS_OFFICE_INFO','ES_SS_PROVINCE_INFO')
598: and hoi1.org_information_context = 'CLASS'
599: and hoi1.organization_id = hoi.organization_id
600: and hoi1.org_information2 = 'Y');
624: ,p_business_group_id NUMBER
625: ,p_effective_date DATE) IS
626: CURSOR get_cif IS
627: SELECT 'x'
628: FROM hr_organization_information hoi,hr_all_organization_units hou
629: WHERE hoi.org_information_context = 'ES_STATUTORY_INFO'
630: AND hou.organization_id = hoi.organization_id
631: AND org_information5 = p_org_info
632: AND hou.business_group_id = p_business_group_id
631: AND org_information5 = p_org_info
632: AND hou.business_group_id = p_business_group_id
633: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
634: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
635: AND exists (select 1 from hr_organization_information hoi1
636: where hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
637: and hoi1.org_information_context = 'CLASS'
638: and hoi1.organization_id = hoi.organization_id
639: and hoi1.org_information2 = 'Y');
658:
659:
660: CURSOR csr_chk_wc_sec_ref IS
661: SELECT 'x'
662: FROM hr_organization_information hoi
663: ,hr_all_organization_units hou
664: WHERE hoi.org_information_context = p_context
665: AND hoi.org_information1 = p_org_information1
666: AND hoi.organization_id = hou.organization_id