DBA Data[Home] [Help]

APPS.AHL_FMP_MR_ACTION_PVT dependencies on AHL_MR_HEADERS_B

Line 320: FROM AHL_MR_HEADERS_B

316:
317: CURSOR GetMrDet(c_mr_header_id NUMBER )
318: IS
319: SELECT MR_STATUS_CODE,nvl(TYPE_CODE,'X') TYPE_CODE
320: FROM AHL_MR_HEADERS_B
321: WHERE MR_HEADER_ID=c_mr_header_id
322: and MR_STATUS_CODE IN('DRAFT','APPROVAL_REJECTED');
323:
324: l_mr_rec GetMrDet%rowtype;