APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 2078: ahl_unit_config_headers uch

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
2081: to_number(cii.position_reference) = mch.relationship_id and
2082: mch.mc_header_id = uch.master_config_id and

Line 2087: ahl_unit_config_headers uch

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;
2091:

Line 2638: ahl_unit_config_headers uch

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
2641: cii.position_reference = mch.relationship_id and
2642: mch.mc_header_id = uch.master_config_id and

Line 2648: ahl_unit_config_headers uch

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
2651: mch.mc_header_id = uch.master_config_id and
2652: uch.unit_config_header_id = p_unit_config_id;