DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 4664: FROM ahl_mc_path_position_nodes A,

4660:
4661: --For fixing bug 4085156, added by Jerry on 12/27/2004
4662: CURSOR get_pos_mandatory(c_path_position_id NUMBER) IS
4663: SELECT B.position_necessity_code
4664: FROM ahl_mc_path_position_nodes A,
4665: ahl_mc_relationships B,
4666: ahl_mc_headers_b C
4667: WHERE A.path_position_id = c_path_position_id
4668: and A.sequence = (select max(D.sequence)

Line 4669: from ahl_mc_path_position_nodes D

4665: ahl_mc_relationships B,
4666: ahl_mc_headers_b C
4667: WHERE A.path_position_id = c_path_position_id
4668: and A.sequence = (select max(D.sequence)
4669: from ahl_mc_path_position_nodes D
4670: group by D.path_position_id
4671: having D.path_position_id = c_path_position_id)
4672: and A.mc_id = C.mc_id
4673: and A.version_number = C.version_number