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