APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 582: SELECT department_id FROM bom_departments dept, hr_all_organization_units org

578: x_msg_data OUT NOCOPY VARCHAR2
579: ) IS
580:
581: CURSOR l_dept_id_csr(p_dept_name IN VARCHAR2, p_org_name IN VARCHAR2) IS
582: SELECT department_id FROM bom_departments dept, hr_all_organization_units org
583: WHERE org.name = p_org_name AND
584: dept.ORGANIZATION_ID = org.ORGANIZATION_ID AND
585: dept.description = p_dept_name;
586:

Line 857: FROM bom_departments dept, hr_all_organization_units org

853: -- Added department name as Select field
854:
855: CURSOR l_dept_id_csr(p_dept_name IN VARCHAR2, p_org_name IN VARCHAR2) IS
856: SELECT department_id, org.organization_id, dept.description dept_name
857: FROM bom_departments dept, hr_all_organization_units org
858: WHERE org.name = p_org_name AND
859: dept.ORGANIZATION_ID = org.ORGANIZATION_ID AND
860: EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = dept.DEPARTMENT_ID) AND
861: ( (p_dept_name is not null and dept.description = p_dept_name)

Line 872: SELECT name FROM hr_all_organization_units WHERE

868: SELECT description FROM bom_departments WHERE
869: department_id = l_dept_id and exists ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = bom_departments.DEPARTMENT_ID);
870: --
871: CURSOR l_validate_org_csr(l_org_name IN VARCHAR2) IS
872: SELECT name FROM hr_all_organization_units WHERE
873: name = l_org_name;
874: --
875: CURSOR l_validate_plan_csr(l_plan_id IN NUMBER) IS
876: SELECT 'x' FROM ahl_simulation_plans_b WHERE

Line 925: l_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;

921:
922: l_resource_dtl_rec l_resource_dtl_csr%rowtype;
923: -- yazhou 24Aug2005 ends
924:
925: l_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
926: l_deprt_id NUMBER;
927: l_orga_id NUMBER;
928: l_junk VARCHAR2(1);
929: l_dept_name bom_departments.description%type;

Line 1553: SELECT department_id,org.organization_id FROM bom_departments dept, hr_all_organization_units org

1549: to add the exists condition to retrieve only department with shifts
1550: */
1551:
1552: CURSOR l_dept_id_csr(p_dept_name IN VARCHAR2, p_org_name IN VARCHAR2) IS
1553: SELECT department_id,org.organization_id FROM bom_departments dept, hr_all_organization_units org
1554: WHERE org.name = p_org_name AND
1555: dept.ORGANIZATION_ID = org.ORGANIZATION_ID AND
1556: dept.description = p_dept_name and exists ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = dept.DEPARTMENT_ID);
1557:

Line 3751: HR_ALL_ORGANIZATION_UNITS A, BOM_DEPARTMENTS B

3747: CURSOR l_get_dept_cur (c_dept_name IN VARCHAR2,
3748: c_org_name IN VARCHAR2)
3749: IS
3750: SELECT B.department_id,A.organization_id FROM
3751: HR_ALL_ORGANIZATION_UNITS A, BOM_DEPARTMENTS B
3752: WHERE A.organization_id = B.organization_id
3753: AND a.name = c_org_name
3754: AND b.description = c_dept_name;
3755: --