DBA Data[Home] [Help]

APPS.POA_REPORT_UTIL dependencies on HR_OPERATING_UNITS

Line 844: FROM hr_operating_units

840: FUNCTION Validate_SavingsOperatingUnit(p_oper_unit_name IN VARCHAR2,
841: p_oper_unit_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
842: CURSOR c0 IS
843: SELECT organization_id
844: FROM hr_operating_units
845: WHERE name = p_oper_unit_name;
846: CURSOR c1 IS
847: SELECT organization_id
848: FROM hr_operating_units

Line 848: FROM hr_operating_units

844: FROM hr_operating_units
845: WHERE name = p_oper_unit_name;
846: CURSOR c1 IS
847: SELECT organization_id
848: FROM hr_operating_units
849: WHERE name = p_oper_unit_name
850: and organization_id IN
851: (SELECT id from bis_operating_units_v
852: WHERE responsibility_id IN

Line 909: FROM hr_operating_units

905: FUNCTION Validate_PPS_OperatingUnit(p_oper_unit_name IN VARCHAR2,
906: p_oper_unit_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
907: CURSOR c0 IS
908: SELECT organization_id
909: FROM hr_operating_units
910: WHERE name = p_oper_unit_name;
911: CURSOR c1 IS
912: SELECT organization_id
913: FROM hr_operating_units

Line 913: FROM hr_operating_units

909: FROM hr_operating_units
910: WHERE name = p_oper_unit_name;
911: CURSOR c1 IS
912: SELECT organization_id
913: FROM hr_operating_units
914: WHERE name = p_oper_unit_name
915: and organization_id IN
916: (SELECT id FROM bis_operating_units_v
917: WHERE responsibility_id IN