APPS.AHL_UA_COMMON_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 802: HR_ALL_ORGANIZATION_UNITS HROU,

798: VB.ATTRIBUTE15,
799: VB.UNIT_SCHEDULE_ID
800: FROM AHL_VISITS_B VB,
801: AHL_UNIT_CONFIG_HEADERS UC,
802: HR_ALL_ORGANIZATION_UNITS HROU,
803: BOM_DEPARTMENTS BDPT
804: WHERE
805: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
806: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND

Line 869: HR_ALL_ORGANIZATION_UNITS HROU,

865: VB.*
866: FROM
867: AHL_VISITS_B VB,
868: AHL_UNIT_CONFIG_HEADERS UC,
869: HR_ALL_ORGANIZATION_UNITS HROU,
870: BOM_DEPARTMENTS BDPT
871: WHERE
872: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
873: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND

Line 1173: HR_ALL_ORGANIZATION_UNITS HROU,

1169: VB.ATTRIBUTE15,
1170: VB.UNIT_SCHEDULE_ID
1171: FROM AHL_VISITS_B VB,
1172: AHL_UNIT_CONFIG_HEADERS UC,
1173: HR_ALL_ORGANIZATION_UNITS HROU,
1174: BOM_DEPARTMENTS BDPT
1175: WHERE
1176: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
1177: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND

Line 1237: HR_ALL_ORGANIZATION_UNITS HROU,

1233: VB.*
1234: FROM
1235: AHL_VISITS_B VB,
1236: AHL_UNIT_CONFIG_HEADERS UC,
1237: HR_ALL_ORGANIZATION_UNITS HROU,
1238: BOM_DEPARTMENTS BDPT
1239: WHERE
1240: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
1241: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND