APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISIT_TYPES_B

Line 5690: FROM AHL_VISIT_TYPES_B

5686: * Cursor to check whether it's a Component Visit given the visit type code.
5687: */
5688: CURSOR chk_comp_visit_csr (c_visit_type_code VARCHAR2) IS
5689: SELECT 'Y'
5690: FROM AHL_VISIT_TYPES_B
5691: WHERE visit_type_code = c_visit_type_code
5692: AND status_code = 'COMPLETE'
5693: AND component_visit_flag = 'Y';
5694:

Line 5705: AHL_VISIT_TYPES_B AVTB

5701: AVB.start_date_time,
5702: AVB.close_date_time
5703:
5704: FROM AHL_VISITS_B AVB,
5705: AHL_VISIT_TYPES_B AVTB
5706:
5707: WHERE AVB.organization_id = c_org_id
5708: AND AVB.visit_type_code = AVTB.visit_type_code
5709: AND AVTB.status_code = 'COMPLETE'