DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on CSI_II_RELATIONSHIPS

Line 2076: csi_ii_relationships cii,

2072: CURSOR check_pos_path_exists
2073: IS
2074: SELECT 'x'
2075: FROM ahl_applicable_instances appl,
2076: csi_ii_relationships cii,
2077: ahl_mc_relationships mch,
2078: ahl_unit_config_headers uch
2079: WHERE appl.position_id = p_x_nonroutine_rec.position_path_id and
2080: (appl.csi_item_instance_id = cii.subject_id or appl.csi_item_instance_id = cii.object_id) and

Line 2636: csi_ii_relationships cii,

2632: )
2633: IS
2634: SELECT mch.ata_code
2635: FROM ahl_applicable_instances appl,
2636: csi_ii_relationships cii,
2637: ahl_mc_relationships mch,
2638: ahl_unit_config_headers uch
2639: WHERE appl.position_id = p_position_path_id and
2640: appl.csi_item_instance_id = cii.subject_id and