DBA Data[Home] [Help]

APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on AHL_MR_VISIT_TYPES_V

Line 203: FROM AHL_MR_VISIT_TYPES_V

199: ATTRIBUTE12,
200: ATTRIBUTE13,
201: ATTRIBUTE14,
202: ATTRIBUTE15
203: FROM AHL_MR_VISIT_TYPES_V
204: WHERE MR_VISIT_TYPE_ID=C_MR_VISIT_TYPE_ID;
205:
206: l_mrvisittype_rec CurMrVisitType%rowtype;
207:

Line 478: FROM AHL_MR_VISIT_TYPES vt,

474: -- Cursor to check if visit type exists for a Planned MR
475: CURSOR Check_Visit_Type(c_mr_header_id NUMBER)
476: IS
477: SELECT 'x'
478: FROM AHL_MR_VISIT_TYPES vt,
479: AHL_MR_HEADERS_B mrh
480: WHERE vt.mr_header_id = mrh.mr_header_id
481: AND mrh.implement_status_code IN ('MANDATORY','OPTIONAL_IMPLEMENT')
482: AND mrh.mr_header_id = c_mr_header_id;