APPS.CSL_SERVICE_REQUESTS_PKG dependencies on CS_INCIDENTS_ALL_B

Line 37: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

33:
34: -- Commented Out for Sql Repository Performance Fix
35:
36: /* CURSOR c_org_rel_contacts
37: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
38: ) IS
39: SELECT b.party_id
40: FROM CSC_HZ_PARTIES_V b
41: WHERE b.object_id = b_customer_id

Line 51: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

47: -- AND b.obj_party_type = 'ORGANIZATION' -- can be both org and person caller type
48: AND rownum <= 1;
49:
50: CURSOR c_person_contacts
51: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
52: ) IS
53: SELECT b.subject_id
54: FROM CSC_HZ_PARTIES_V b
55: WHERE b.object_id = b_customer_id

Line 68: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

64: AND status ='A'; */
65:
66:
67: CURSOR c_org_rel_contacts
68: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
69: ) IS
70: SELECT b.party_id FROM HZ_RELATIONSHIPS b
71: WHERE b.object_id = b_customer_id
72: AND object_table_name = 'HZ_PARTIES'

Line 79: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

75: AND rownum <= 1;
76:
77:
78: CURSOR c_person_contacts
79: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
80: ) IS
81: SELECT b.subject_id FROM HZ_RELATIONSHIPS b
82: WHERE b.object_id = b_customer_id
83: AND object_table_name = 'HZ_PARTIES'

Line 89: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

85: AND rownum <= 1;
86:
87:
88: CURSOR c_party_contact
89: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
90: ) IS
91: SELECT PARTY_ID FROM HZ_PARTIES
92: WHERE party_id = b_customer_id AND status = 'A';
93:

Line 98: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

94:
95: /* ER 3746707
96: Cursor to get the Bill to Address */
97: CURSOR c_bill_to_site_id
98: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
99: ) IS
100: SELECT use.party_site_use_id FROM
101: hz_party_sites site, hz_party_site_uses use
102: WHERE site.party_site_id = use.party_site_id

Line 114: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

110:
111: /* ER 3746707
112: Cursor to get the Ship to Address */
113: CURSOR c_ship_to_site_id
114: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
115: ) IS
116: SELECT use.party_site_use_id FROM
117: hz_party_sites site, hz_party_site_uses use
118: WHERE site.party_site_id = use.party_site_id

Line 130: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE

126:
127: /* ER 3746707
128: Cursor to get the customer account id */
129: CURSOR c_customer_account
130: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
131: ) IS
132: SELECT custa.cust_account_id FROM hz_cust_accounts custa
133: WHERE custa.status = 'A'
134: AND custa.party_id = b_customer_id;

Line 452: from CS_INCIDENTS_ALL_B

448: ( b_incident_id NUMBER
449: )
450: is
451: SELECT LAST_UPDATE_DATE
452: from CS_INCIDENTS_ALL_B
453: where incident_id = b_incident_id;
454:
455: r_last_update_date c_last_update_date%ROWTYPE;
456:

Line 464: FROM CS_INCIDENTS_ALL_B

460: is
461: SELECT CREDIT_CARD_NUMBER, CREDIT_CARD_TYPE_CODE,
462: CREDIT_CARD_EXPIRATION_DATE, CREDIT_CARD_HOLDER_FNAME,
463: CREDIT_CARD_HOLDER_MNAME, CREDIT_CARD_HOLDER_LNAME, CREDIT_CARD_ID
464: FROM CS_INCIDENTS_ALL_B
465: WHERE incident_id = b_incident_id;
466:
467: r_credit_card c_credit_card%ROWTYPE;
468: