DBA Data[Home] [Help]

APPS.AHL_FMP_MR_ROUTE_SEQNCE_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 349: From AHL_MR_HEADERS_APP_V

345:
346: CURSOR GetMrDet(c_mr_header_id NUMBER)
347: IS
348: SELECT MR_STATUS_CODE,TYPE_CODE
349: From AHL_MR_HEADERS_APP_V
350: Where MR_HEADER_ID=c_mr_header_id
351: And MR_STATUS_CODE IN('DRAFT','APPROVAL_REJECTED');
352:
353: l_mr_rec GetMrDet%rowtype;