DBA Data[Home] [Help]

APPS.AHL_FMP_PROGTYPE_SUBTYPE_PVT dependencies on AHL_MR_HEADERS_B

Line 485: FROM AHL_MR_HEADERS_B

481: --AMSRINIV. Bug 2730079. Added code to throw error if subtype asccociated to MRs is selected for delete.
482: --START
483: l_cnt_mrs_subtype :=0;
484: SELECT COUNT(MR_HEADER_ID) INTO l_cnt_mrs_subtype
485: FROM AHL_MR_HEADERS_B
486: WHERE PROGRAM_TYPE_CODE = (SELECT PROGRAM_TYPE_CODE
487: FROM AHL_PROG_TYPE_SUBTYPES
488: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID)
489: AND PROGRAM_SUBTYPE_CODE = (SELECT PROGRAM_SUBTYPE_CODE