APPS.RCV_SETUP_S2 dependencies on HR_ORGANIZATION_UNITS

Line 15: --Bug 5217526. Fetch Org Name from HR_ORGANIZATION_UNITS

11: FUNCTION get_org_name(p_org_id IN NUMBER) RETURN VARCHAR2
12: IS
13: x_org_name VARCHAR2(240);
14: Begin
15: --Bug 5217526. Fetch Org Name from HR_ORGANIZATION_UNITS
16: SELECT ood.name
17: INTO x_org_name
18: FROM HR_ORGANIZATION_UNITS ood
19: WHERE ood.organization_id = p_org_id;

Line 18: FROM HR_ORGANIZATION_UNITS ood

14: Begin
15: --Bug 5217526. Fetch Org Name from HR_ORGANIZATION_UNITS
16: SELECT ood.name
17: INTO x_org_name
18: FROM HR_ORGANIZATION_UNITS ood
19: WHERE ood.organization_id = p_org_id;
20:
21: return (x_org_name);
22: