APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on CS_INCIDENTS_ALL_B

Line 73: SELECT customer_id FROM cs_incidents_all_b

69: WHERE visit_id = p_visit_id;
70: --salogan::Modified Cursor to add CP request id CP ER 9299910::01-JUN-2009::END
71:
72: CURSOR customer_id_csr(p_service_request_id IN NUMBER)IS
73: SELECT customer_id FROM cs_incidents_all_b
74: WHERE incident_id = p_service_request_id;
75:
76: CURSOR visit_tasks_csr(p_visit_id IN NUMBER) IS
77: SELECT 'x' FROM ahl_visit_tasks_b

Line 2842: From CS_INCIDENTS_ALL_B

2838:
2839: Cursor c_customer_csr(c_incident_id in number)
2840: Is
2841: Select customer_id
2842: From CS_INCIDENTS_ALL_B
2843: Where incident_id=c_incident_id;
2844:
2845:
2846: -- Get all the root mr