DBA Data[Home] [Help]

APPS.RCV_INTRANSIT_SV dependencies on HR_ORGANIZATION_UNITS

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

129: FROM PO_VENDORS
130: WHERE vendor_id = p_vendor_id;
131:
132: ELSE
133: --Bug 5217526. Fetch Org Name from HR_ORGANIZATION_UNITS
134: SELECT MAX(NVL(NAME, NULL))
135: INTO v_Result
136: FROM HR_ORGANIZATION_UNITS
137: WHERE ORGANIZATION_ID = p_org_id;

Line 136: FROM HR_ORGANIZATION_UNITS

132: ELSE
133: --Bug 5217526. Fetch Org Name from HR_ORGANIZATION_UNITS
134: SELECT MAX(NVL(NAME, NULL))
135: INTO v_Result
136: FROM HR_ORGANIZATION_UNITS
137: WHERE ORGANIZATION_ID = p_org_id;
138: END IF;
139:
140: