APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on CS_INCIDENTS_ALL_B

Line 71: SELECT customer_id FROM cs_incidents_all_b

67: FROM ahl_visits_b
68: WHERE visit_id = p_visit_id;
69:
70: CURSOR customer_id_csr(p_service_request_id IN NUMBER)IS
71: SELECT customer_id FROM cs_incidents_all_b
72: WHERE incident_id = p_service_request_id;
73:
74: CURSOR visit_tasks_csr(p_visit_id IN NUMBER) IS
75: SELECT 'x' FROM ahl_visit_tasks_b

Line 2761: From CS_INCIDENTS_ALL_B

2757:
2758: Cursor c_customer_csr(c_incident_id in number)
2759: Is
2760: Select customer_id
2761: From CS_INCIDENTS_ALL_B
2762: Where incident_id=c_incident_id;
2763:
2764:
2765: -- Get all the root mr