APPS.AHL_VWP_MR_CST_PR_PVT dependencies on AHL_VISITS_B

Line 222: From ahl_visits_b V, ahl_visit_tasks_b T

218: -- Cursor to retrieve visit info
219: Cursor c_visit_csr(c_visit_task_id in number)
220: Is
221: Select v.visit_id, v.any_task_chg_flag
222: From ahl_visits_b V, ahl_visit_tasks_b T
223: where T.visit_task_id=c_visit_task_id
224: AND V.visit_id = T.visit_id;
225:
226: l_visit_rec c_visit_csr%rowtype;

Line 507: From ahl_visits_b

503: OUTSIDE_PARTY_FLAG,
504: ORGANIZATION_ID,
505: START_DATE_TIME,
506: any_task_chg_flag
507: From ahl_visits_b
508: where visit_id=c_visit_id;
509:
510: l_visit_rec c_visit_csr%rowtype;
511:

Line 1120: Update AHL_VISITS_B

1116: l_estimated_price_diff := l_estimate_price - l_task_rec. Estimated_price ;
1117: l_visit_rec.Estimated_price :=l_visit_rec. Estimated_price + l_estimated_price_diff;
1118: End if;
1119:
1120: Update AHL_VISITS_B
1121: set actual_price=l_visit_rec.actual_price,
1122: estimated_price=l_visit_rec.estimated_price
1123: where visit_id=l_visit_rec.visit_id;
1124:

Line 1241: From AHL_VISITS_B

1237: price_list_id,
1238: service_Request_id,
1239: organization_id,
1240: outside_party_flag
1241: From AHL_VISITS_B
1242: Where VISIT_ID=C_VISIT_ID;
1243:
1244: l_visit_rec c_visit_csr%rowtype;
1245:

Line 2068: FROM ahl_visits_b

2064:
2065: -- Define Local Cursors
2066: CURSOR visit_info_csr(p_visit_id IN NUMBER) IS
2067: SELECT status_code
2068: FROM ahl_visits_b
2069: WHERE visit_id = p_visit_id;
2070:
2071:
2072: Cursor c_task_rec(c_visit_task_id NUMBER)

Line 2151: 'Visit id not found in ahl_visits_b table'

2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: G_MODULE_NAME||'.'||l_api_name,
2151: 'Visit id not found in ahl_visits_b table'
2152: );
2153: END IF;
2154: CLOSE visit_info_csr;
2155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;