DBA Data[Home] [Help]

APPS.OE_EXTERNAL_CREDIT_PVT dependencies on HR_OPERATING_UNITS

Line 128: FROM hr_operating_units

124: IF p_org_id IS NOT NULL AND p_org_id<>FND_API.G_MISS_NUM THEN
125: BEGIN
126: SELECT organization_id
127: INTO l_org_id
128: FROM hr_operating_units
129: WHERE organization_id = p_org_id;
130: x_org_id := p_org_id;
131: EXCEPTION
132: WHEN NO_DATA_FOUND THEN

Line 149: FROM hr_operating_units

145: p_operating_unit_name <> FND_API.G_MISS_CHAR THEN
146: BEGIN
147: SELECT organization_id
148: INTO l_org_id
149: FROM hr_operating_units
150: WHERE name = p_operating_unit_name;
151: x_org_id := l_org_id;
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN