[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
450: AND org_information1 = p_org_info
451: AND hou.business_group_id = p_business_group_id
452: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
453: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
454: AND exists (select 1 from hr_organization_information hoi1
455: where hoi1.org_information1 = 'ES_WORK_CENTER'
456: and hoi1.org_information_context = 'CLASS'
457: and hoi1.organization_id = hoi.organization_id
458: and hoi1.org_information2 = 'Y');
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
465: AND org_information8 = p_org_info
466: AND hou.business_group_id = p_business_group_id
467: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
468: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
469: AND exists (select 1 from hr_organization_information hoi1
470: where hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
471: and hoi1.org_information_context = 'CLASS'
472: and hoi1.organization_id = hoi.organization_id
473: and hoi1.org_information2 = 'Y');
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
512: AND org_information1 = p_org_info
513: AND hou.business_group_id = p_business_group_id
514: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
515: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
516: AND exists (select 1 from hr_organization_information hoi1
517: where hoi1.org_information1 in( 'ES_SS_OFFICE_INFO','ES_SS_PROVINCE_INFO')
518: and hoi1.org_information_context = 'CLASS'
519: and hoi1.organization_id = hoi.organization_id
520: and hoi1.org_information2 = 'Y');
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
551: AND org_information5 = p_org_info
552: AND hou.business_group_id = p_business_group_id
553: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
554: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
555: AND exists (select 1 from hr_organization_information hoi1
556: where hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
557: and hoi1.org_information_context = 'CLASS'
558: and hoi1.organization_id = hoi.organization_id
559: and hoi1.org_information2 = 'Y');
578:
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