APPS.AHL_APPR_SPACE_UNAVL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 53: FROM HR_ALL_ORGANIZATION_UNITS

49: IF (p_organization_id IS NOT NULL)
50: THEN
51: SELECT organization_id
52: INTO x_organization_id
53: FROM HR_ALL_ORGANIZATION_UNITS
54: WHERE organization_id = p_organization_id;
55: ELSE
56: SELECT organization_id
57: INTO x_organization_id

Line 58: FROM HR_ALL_ORGANIZATION_UNITS

54: WHERE organization_id = p_organization_id;
55: ELSE
56: SELECT organization_id
57: INTO x_organization_id
58: FROM HR_ALL_ORGANIZATION_UNITS
59: WHERE NAME = p_org_name;
60: END IF;
61: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
62: EXCEPTION

Line 106: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP

102: END IF;
103:
104: SELECT department_id
105: INTO x_department_id
106: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP
107: WHERE HAOU.organization_id = BMDP.organization_id
108: AND BMDP.organization_id = p_organization_id
109: AND BMDP.description = p_dept_description;
110: END IF;

Line 114: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP

110: END IF;
111: ELSE
112: SELECT department_id
113: INTO x_department_id
114: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP
115: WHERE HAOU.organization_id = BMDP.organization_id
116: AND BMDP.organization_id = (SELECT organization_id
117: FROM HR_ALL_ORGANIZATION_UNITS
118: WHERE NAME = p_org_name)

Line 117: FROM HR_ALL_ORGANIZATION_UNITS

113: INTO x_department_id
114: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP
115: WHERE HAOU.organization_id = BMDP.organization_id
116: AND BMDP.organization_id = (SELECT organization_id
117: FROM HR_ALL_ORGANIZATION_UNITS
118: WHERE NAME = p_org_name)
119: AND BMDP.description = p_dept_description;
120: END IF;
121: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;