APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 4654: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI

4650: WHERE part_change_id = p_part_change_id;
4651: --
4652: CURSOR get_pos_mandatory_csr(p_instance_id IN NUMBER) IS
4653: SELECT rel.position_necessity_code
4654: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI
4655: WHERE csi.subject_id = p_instance_id
4656: AND rel.relationship_id = TO_NUMBER(CSI.position_reference)
4657: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4658: AND TRUNC(nvl(CSI.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)

Line 4665: ahl_mc_relationships B,

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)
4669: from ahl_mc_path_position_nodes D