DBA Data[Home] [Help]

APPS.CSM_SERVICE_REQUESTS_PKG dependencies on CSF_M_SR_CONTACTS_INQ

Line 22: FROM CSF_M_SR_CONTACTS_INQ

18:
19: /* Select all contact records for incident from inq table */
20: CURSOR c_contact( b_incident_id NUMBER, b_tranid NUMBER, b_user_name VARCHAR2 ) IS
21: SELECT *
22: FROM CSF_M_SR_CONTACTS_INQ
23: WHERE INCIDENT_ID = b_incident_id
24: AND TRANID$$ = b_tranid
25: AND clid$$cs = b_user_name;
26: --Since from r12 the app_id and responsiblity id is available in asg_user table the cursor is mordied to take the values