DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 2233: FROM ahl_mc_relationships

2229:
2230: -- get root master configuration for the item's position reference.
2231: CURSOR ahl_posn_master_config_csr (p_start_node_id IN NUMBER) IS
2232: SELECT relationship_id
2233: FROM ahl_mc_relationships
2234: WHERE parent_relationship_id IS NULL
2235: START WITH relationship_id = p_start_node_id
2236: CONNECT BY PRIOR parent_relationship_id = relationship_id
2237: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)