APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_APPLICABLE_INSTANCES

Line 2168: FROM ahl_applicable_instances appl,

2164:
2165: CURSOR check_pos_path_exists
2166: IS
2167: SELECT 'x'
2168: FROM ahl_applicable_instances appl,
2169: csi_ii_relationships cii,
2170: ahl_mc_relationships mch,
2171: ahl_unit_config_headers uch
2172: WHERE appl.position_id = p_x_nonroutine_rec.position_path_id and

Line 2179: FROM ahl_applicable_instances appl,

2175: mch.mc_header_id = uch.master_config_id and
2176: uch.unit_config_header_id = p_x_nonroutine_rec.unit_config_header_id
2177: UNION ALL
2178: SELECT 'x'
2179: FROM ahl_applicable_instances appl,
2180: ahl_unit_config_headers uch
2181: WHERE appl.position_id = p_x_nonroutine_rec.position_path_id and
2182: appl.csi_item_instance_id = uch.csi_item_instance_id and
2183: uch.unit_config_header_id = p_x_nonroutine_rec.unit_config_header_id;

Line 2729: FROM ahl_applicable_instances appl,

2725: p_unit_config_id number
2726: )
2727: IS
2728: SELECT mch.ata_code
2729: FROM ahl_applicable_instances appl,
2730: csi_ii_relationships cii,
2731: ahl_mc_relationships mch,
2732: ahl_unit_config_headers uch
2733: WHERE appl.position_id = p_position_path_id and

Line 2740: FROM ahl_applicable_instances appl,

2736: mch.mc_header_id = uch.master_config_id and
2737: uch.unit_config_header_id = p_unit_config_id
2738: UNION ALL
2739: SELECT mch.ata_code
2740: FROM ahl_applicable_instances appl,
2741: ahl_mc_relationships mch,
2742: ahl_unit_config_headers uch
2743: WHERE appl.position_id = p_position_path_id and
2744: appl.csi_item_instance_id = uch.csi_item_instance_id and