DBA Data[Home] [Help]

APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_MR_RELATIONSHIPS_APP_V

Line 1188: FROM AHL_MR_HEADERS_B AMHB, AHL_MR_RELATIONSHIPS_APP_V REL

1184: -- SKPATHAK :: Bug 9971127 :: 13-AUG-2010
1185: -- Added this cursor to validate if any of the child MR for a group MR are in TERMINATED status
1186: CURSOR c_validate_child_mrs (c_mr_header_id IN NUMBER) IS
1187: SELECT 'X'
1188: FROM AHL_MR_HEADERS_B AMHB, AHL_MR_RELATIONSHIPS_APP_V REL
1189: WHERE REL.MR_HEADER_ID = c_mr_header_id
1190: AND REL.RELATED_MR_HEADER_ID = AMHB.MR_HEADER_ID
1191: AND AMHB.MR_STATUS_CODE = 'TERMINATED'
1192: AND AMHB.VERSION_NUMBER IN