DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 2862: FROM ahl_mc_relationships

2858:
2859: -- get root master configuration for the item's position reference.
2860: CURSOR ahl_posn_master_config_csr (p_start_node_id IN NUMBER) IS
2861: SELECT relationship_id
2862: FROM ahl_mc_relationships
2863: WHERE parent_relationship_id IS NULL
2864: START WITH relationship_id = p_start_node_id
2865: CONNECT BY PRIOR parent_relationship_id = relationship_id
2866: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)