APPS.AHL_MC_TREE_PVT dependencies on AHL_MC_HEADERS_B

Line 694: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR

690: DECODE (MCB.CONFIG_STATUS_CODE,
691: 'CLOSED', MCB.CONFIG_STATUS_CODE,
692: DECODE (SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
693: 1, MCB.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
694: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
695: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
696: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
697: ) HDR,
698: FND_LOOKUP_VALUES FPRC,

Line 744: AHL_MC_HEADERS_B HDR,

740: 'CLOSED', HDR.CONFIG_STATUS_CODE,
741: DECODE (SIGN(TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
742: 1, HDR.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
743: FROM AHL_MC_RELATIONSHIPS REL,
744: AHL_MC_HEADERS_B HDR,
745: FND_LOOKUP_VALUES FPRC,
746: FND_LOOKUP_VALUES FPNC,
747: FND_LOOKUP_VALUES FATA
748: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL

Line 796: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR

792: DECODE (MCB.CONFIG_STATUS_CODE,
793: 'CLOSED', MCB.CONFIG_STATUS_CODE,
794: DECODE (SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
795: 1, MCB.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
796: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
797: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
798: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
799: ) HDR,
800: FND_LOOKUP_VALUES FPRC,