APPS.AHL_FMP_MR_DOC_ASSO_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 85: From AHL_MR_HEADERS_APP_V

81:
82: CURSOR mr_details_csr_type(p_mr_header_id NUMBER)
83: IS
84: SELECT mr_status_code,type_code
85: From AHL_MR_HEADERS_APP_V
86: Where mr_header_id=p_mr_header_id
87: And mr_status_code IN('DRAFT','APPROVAL_REJECTED');
88:
89: l_mr_rec mr_details_csr_type%rowtype;