APPS.AHL_CMP_UTIL_PKG dependencies on AHL_VISIT_TYPES_B

Line 43: FROM AHL_VISITS_B VST, AHL_VISIT_TYPES_B VTB

39:
40: -- cursor to get the component visit id for a given org
41: CURSOR get_comp_visit_csr (c_org_id NUMBER) IS
42: SELECT VST.visit_id
43: FROM AHL_VISITS_B VST, AHL_VISIT_TYPES_B VTB
44: WHERE VST.organization_id = c_org_id
45: AND VST.visit_type_code = VTB.visit_type_code
46: AND NVL(VTB.component_visit_flag, 'N') = 'Y'
47: AND VTB.status_code = 'COMPLETE';

Line 245: AHL_VISIT_TYPES_B AVTB

241: SELECT AVB.visit_id,
242: AVB.status_code
243:
244: FROM AHL_VISITS_B AVB,
245: AHL_VISIT_TYPES_B AVTB
246:
247: WHERE AVB.organization_id = c_org_id
248: AND AVB.visit_type_code = AVTB.visit_type_code
249: AND AVTB.status_code = 'COMPLETE'

Line 385: AHL_VISIT_TYPES_B AVTB

381: -- cursor to check whether the given Visit is a Component Visit
382: CURSOR chk_comp_visit_csr (c_visit_id NUMBER) IS
383: SELECT 'Y'
384: FROM AHL_VISITS_B AVB,
385: AHL_VISIT_TYPES_B AVTB
386: WHERE AVB.visit_id = c_visit_id
387: AND AVB.visit_type_code = AVTB.visit_type_code
388: AND AVTB.status_code = 'COMPLETE'
389: AND AVTB.component_visit_flag = 'Y';