APPS.PER_AE_MIGRATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 64: FROM hr_organization_information hoi

60: /*Cursor for checking if default employer is set*/
61: CURSOR csr_get_bg_det IS
62: SELECT org_information2 def_emp
63: ,NVL(org_information3,'N') mig_indicator
64: FROM hr_organization_information hoi
65: WHERE hoi.organization_id = p_business_group_id
66: AND hoi.org_information_context = 'AE_BG_DETAILS';
67: rec_get_bg_det csr_get_bg_det%ROWTYPE;
68:

Line 452: UPDATE hr_organization_information

448:
449: --END LOOP;
450: --CLOSE csr_get_business_group_id;
451: /*Update the org_information to indicate the migration is complete*/
452: UPDATE hr_organization_information
453: SET org_information3 = 'Y'
454: WHERE organization_id = p_business_group_id
455: AND org_information_context = 'AE_BG_DETAILS';
456: END IF;