APPS.HR_BPL_ALERT_RECIPIENT dependencies on HR_ORGANIZATION_INFORMATION

Line 1063: FROM hr_organization_information

1059: CURSOR c_bg_details
1060: ( cp_business_group_id NUMBER )
1061: IS
1062: SELECT org_information9 bg_lang
1063: FROM hr_organization_information
1064: WHERE org_information_context = 'Business Group Information'
1065: AND organization_id = cp_business_group_id;
1066: --
1067: l_lang VARCHAR2(10) DEFAULT NULL;