APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 419: FROM ahl_mc_relationships mcr,

415: /*
416: CURSOR get_rec_from_id ( c_relationship_id NUMBER )
417: IS
418: SELECT relationship_id
419: FROM ahl_mc_relationships mcr,
420: ahl_mc_headers_b mch, ahl_mc_path_position_nodes mcp
421: where mch.mc_header_id = mcr.mc_header_id and
422: mch.mc_id = mcp.mc_id and
423: mch.version_number = nvl(mcp.version_number, mch.version_number) and

Line 433: FROM ahl_mc_relationships

429:
430: CURSOR check_reln_valid_csr (c_relationship_id IN NUMBER)
431: IS
432: SELECT 'x'
433: FROM ahl_mc_relationships
434: WHERE parent_relationship_id IS NULL
435: START WITH relationship_id = c_relationship_id
436: AND trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1))
437: CONNECT BY PRIOR parent_relationship_id = relationship_id

Line 623: FROM ahl_mc_relationships mcr,

619:
620: CURSOR check_alternate( c_relationship_id NUMBER, c_inventory_item_id NUMBER )
621: IS
622: SELECT 'X'
623: FROM ahl_mc_relationships mcr,
624: ahl_mc_headers_b mch,
625: ahl_mc_path_position_nodes mcp,
626: --ahl_item_associations_v igass ,
627: ahl_item_associations_vl igass, --priyan changes due to performance reasons , Refer Bug # 5078530