APPS.AHL_MC_TREE_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 125: FROM AHL_MC_RELATIONSHIPS

121: p_rel_id IN NUMBER
122: )
123: IS
124: SELECT NVL(COUNT(*), 0) NUM_CHILDREN
125: FROM AHL_MC_RELATIONSHIPS
126: WHERE PARENT_RELATIONSHIP_ID = p_rel_id;
127:
128: -- Define cursor to check whether the particular node has any subconfig_association
129: CURSOR check_subconfig_assos

Line 146: FROM AHL_MC_RELATIONSHIPS

142: )
143: IS
144: SELECT RELATIONSHIP_ID,
145: ACTIVE_END_DATE
146: FROM AHL_MC_RELATIONSHIPS
147: WHERE MC_HEADER_ID = p_mc_header_id AND
148: PARENT_RELATIONSHIP_ID IS NULL;
149:
150: -- Define cursor to retrieve the position path id given a position path

Line 638: FROM AHL_MC_RELATIONSHIPS REL,

634: REL.MC_HEADER_ID,
635: HDR.MC_ID,
636: HDR.VERSION_NUMBER,
637: HDR.CONFIG_STATUS_CODE
638: FROM AHL_MC_RELATIONSHIPS REL,
639: AHL_MC_HEADERS_V HDR,
640: FND_LOOKUP_VALUES_VL FPRC,
641: FND_LOOKUP_VALUES_VL FPNC,
642: FND_LOOKUP_VALUES_VL FATA

Line 685: FROM AHL_MC_RELATIONSHIPS REL,

681: REL.MC_HEADER_ID,
682: HDR.MC_ID,
683: HDR.VERSION_NUMBER,
684: HDR.CONFIG_STATUS_CODE
685: FROM AHL_MC_RELATIONSHIPS REL,
686: AHL_MC_HEADERS_V HDR,
687: FND_LOOKUP_VALUES_VL FPRC,
688: FND_LOOKUP_VALUES_VL FPNC,
689: FND_LOOKUP_VALUES_VL FATA

Line 727: FROM AHL_MC_RELATIONSHIPS REL,

723: REL.MC_HEADER_ID,
724: HDR.MC_ID,
725: HDR.VERSION_NUMBER,
726: HDR.CONFIG_STATUS_CODE
727: FROM AHL_MC_RELATIONSHIPS REL,
728: AHL_MC_HEADERS_V HDR,
729: FND_LOOKUP_VALUES_VL FPRC,
730: FND_LOOKUP_VALUES_VL FPNC,
731: FND_LOOKUP_VALUES_VL FATA