DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 4204: FROM ahl_mc_path_position_nodes A,

4200:
4201: --For fixing bug 4085156, added by Jerry on 12/27/2004
4202: CURSOR get_pos_mandatory(c_path_position_id NUMBER) IS
4203: SELECT B.position_necessity_code
4204: FROM ahl_mc_path_position_nodes A,
4205: ahl_mc_relationships B,
4206: ahl_mc_headers_b C
4207: WHERE A.path_position_id = c_path_position_id
4208: and A.sequence = (select max(D.sequence)

Line 4209: from ahl_mc_path_position_nodes D

4205: ahl_mc_relationships B,
4206: ahl_mc_headers_b C
4207: WHERE A.path_position_id = c_path_position_id
4208: and A.sequence = (select max(D.sequence)
4209: from ahl_mc_path_position_nodes D
4210: group by D.path_position_id
4211: having D.path_position_id = c_path_position_id)
4212: and A.mc_id = C.mc_id
4213: and A.version_number = C.version_number