APPS.CSL_SERVICE_REQUESTS_PKG dependencies on HZ_PARTIES

Line 40: FROM CSC_HZ_PARTIES_V b

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
42: -- AND b.party_id = p_customer_contact_id
43: AND b.sub_status = 'A'
44: AND b.obj_status = 'A'

Line 54: FROM CSC_HZ_PARTIES_V b

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
56: -- AND b.subject_id = p_customer_contact_id
57: AND b.sub_status = 'A'
58: AND b.obj_status = 'A'

Line 62: FROM HZ_PARTIES

58: AND b.obj_status = 'A'
59: AND rownum <= 1
60: UNION
61: SELECT PARTY_ID
62: FROM HZ_PARTIES
63: WHERE party_id = b_customer_id
64: AND status ='A'; */
65:
66:

Line 72: AND object_table_name = 'HZ_PARTIES'

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'
73: AND status = 'A'
74: AND b.relationship_code in ('CONTACT_OF','EMPLOYEE_OF')
75: AND rownum <= 1;
76:

Line 83: AND object_table_name = 'HZ_PARTIES'

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'
84: AND status = 'A'
85: AND rownum <= 1;
86:
87:

Line 91: SELECT PARTY_ID FROM HZ_PARTIES

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:
94:
95: /* ER 3746707