APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 1213: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu

1209: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type) IS
1210:
1211:
1212: CURSOR only_units_csr(p_unit_name in VARCHAR2) IS
1213: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu
1214: where UPPER(ahlu.name) like upper(p_unit_name);
1215:
1216:
1217: l_unit_related_ii_sql VARCHAR2(4000);

Line 1247: l_unit_related_ii_sql := l_unit_related_ii_sql || ', ahl_unit_config_headers uc ';

1243: l_unit_related_ii_sql := l_unit_related_ii_sql || ', mtl_system_items_kfv mtl ';
1244: END IF;
1245:
1246: IF p_search_mr_instance_rec.unit_name is NOT NULL THEN
1247: l_unit_related_ii_sql := l_unit_related_ii_sql || ', ahl_unit_config_headers uc ';
1248: END IF;
1249:
1250: l_unit_related_ii_sql := l_unit_related_ii_sql || 'where 0=0 ';
1251: