APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_APPLICABLE_INSTANCES

Line 2075: FROM ahl_applicable_instances appl,

2071:
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

Line 2086: FROM ahl_applicable_instances appl,

2082: mch.mc_header_id = uch.master_config_id and
2083: uch.unit_config_header_id = p_x_nonroutine_rec.unit_config_header_id
2084: UNION ALL
2085: SELECT 'x'
2086: FROM ahl_applicable_instances appl,
2087: ahl_unit_config_headers uch
2088: WHERE appl.position_id = p_x_nonroutine_rec.position_path_id and
2089: appl.csi_item_instance_id = uch.csi_item_instance_id and
2090: uch.unit_config_header_id = p_x_nonroutine_rec.unit_config_header_id;

Line 2635: FROM ahl_applicable_instances appl,

2631: p_unit_config_id number
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

Line 2646: FROM ahl_applicable_instances appl,

2642: mch.mc_header_id = uch.master_config_id and
2643: uch.unit_config_header_id = p_unit_config_id
2644: UNION ALL
2645: SELECT mch.ata_code
2646: FROM ahl_applicable_instances appl,
2647: ahl_mc_relationships mch,
2648: ahl_unit_config_headers uch
2649: WHERE appl.position_id = p_position_path_id and
2650: appl.csi_item_instance_id = uch.csi_item_instance_id and