APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 125: FROM hr_all_organization_units hou

121: csr_get_ivid_rec csr_get_ivid%ROWTYPE;
122:
123: CURSOR csr_get_orgid(c_org_name VARCHAR2) IS
124: SELECT hou.organization_id
125: FROM hr_all_organization_units hou
126: WHERE hou.name = c_org_name
127: AND (hou.business_group_id = p_bg_id OR
128: hou.business_group_id is null);
129:

Line 684: FROM hr_all_organization_units horg

680: csr_get_orginfo_rec csr_get_orginfo%ROWTYPE;
681:
682: CURSOR csr_get_orgid (c_pb_orgid NUMBER) IS
683: SELECT horg.organization_id
684: FROM hr_all_organization_units horg
685: WHERE horg.organization_id = c_pb_orgid
686: AND horg.name = p_professional_body_name
687: AND ( horg.business_group_id = p_business_group_id
688: OR horg.business_group_id IS NULL);