APPS.GHR_MRE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 287: from HR_ORGANIZATION_INFORMATION

283:
284: -- Bug#2651909 Cursor to get OPM Organizational Component of Target Organization
285: cursor c_opm_org_component(p_organization_id IN NUMBER) is
286: Select org_information4
287: from HR_ORGANIZATION_INFORMATION
288: WHERE organization_id = p_organization_id
289: and ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO';
290:
291: l_assignment_id per_assignments_f.assignment_id%type;