DBA Data[Home] [Help]

APPS.AHL_VWP_MR_CST_PR_PVT dependencies on CS_INCIDENTS_ALL_B

Line 74: from CS_INCIDENTS_ALL_B

70:
71: Cursor c_customer (c_incident_id in number)
72: Is
73: select customer_id
74: from CS_INCIDENTS_ALL_B
75: where incident_id=c_incident_id;
76:
77:
78: Cursor c_visit_csr(c_visit_id in number)

Line 533: from CS_INCIDENTS_ALL_B

529:
530: Cursor c_customer (c_incident_id in number)
531: Is
532: select customer_id
533: from CS_INCIDENTS_ALL_B
534: where incident_id=c_incident_id;
535:
536: l_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE;
537:

Line 536: l_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE;

532: select customer_id
533: from CS_INCIDENTS_ALL_B
534: where incident_id=c_incident_id;
535:
536: l_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE;
537:
538: -- Cursor to get MR billing Item and UOM code
539:
540: -- AnRaj: Changed query for fixing the prformance bug# 4919272

Line 1290: from CS_INCIDENTS_ALL_B

1286:
1287: Cursor c_customer_csr (c_incident_id in number)
1288: Is
1289: select customer_id
1290: from CS_INCIDENTS_ALL_B
1291: where incident_id=c_incident_id;
1292:
1293:
1294: -- AnRaj: Changed query for fixing the prformance bug# 4919272