DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on CSI_II_RELATIONSHIPS

Line 2169: csi_ii_relationships cii,

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
2173: (appl.csi_item_instance_id = cii.subject_id or appl.csi_item_instance_id = cii.object_id) and

Line 2730: csi_ii_relationships cii,

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
2734: appl.csi_item_instance_id = cii.subject_id and