APPS.CS_SERVICEREQUEST_UTIL dependencies on HR_OPERATING_UNITS

Line 9332: -- hr_operating_units

9328: -- Date Name Description
9329: ---------- -------- ------------------------------------------------------------
9330: -- 04/21/05 smisra Created
9331: -- 08/15/05 smisra Changed the table name from hr_all_organization_units to
9332: -- hr_operating_units
9333: -- 8/25/05 smisra truncated local variable l_sys_dt because table
9334: -- hr_operating_units does not store time component.
9335: -- -----------------------------------------------------------------------------
9336: PROCEDURE validate_org_id

Line 9334: -- hr_operating_units does not store time component.

9330: -- 04/21/05 smisra Created
9331: -- 08/15/05 smisra Changed the table name from hr_all_organization_units to
9332: -- hr_operating_units
9333: -- 8/25/05 smisra truncated local variable l_sys_dt because table
9334: -- hr_operating_units does not store time component.
9335: -- -----------------------------------------------------------------------------
9336: PROCEDURE validate_org_id
9337: ( p_org_id NUMBER
9338: , x_return_status OUT NOCOPY VARCHAR2

Line 9353: hr_operating_units

9349: INTO
9350: l_dt_from
9351: , l_dt_to
9352: FROM
9353: hr_operating_units
9354: WHERE organization_id = p_org_id;
9355: IF l_sys_dt < NVL(l_dt_from, l_sys_dt) OR
9356: l_sys_dt > NVL(l_dt_to , l_sys_dt)
9357: THEN