APPS.PRP_IH_EMAIL_PVT dependencies on HZ_PARTIES

Line 64: FROM HZ_PARTIES HZP

60: CURSOR c1 IS SELECT jtf_ih_media_items_s1.nextval FROM dual;
61:
62: CURSOR c_party_type(l_party_id NUMBER) IS
63: SELECT HZP.PARTY_TYPE
64: FROM HZ_PARTIES HZP
65: WHERE HZP.PARTY_ID = l_party_id;
66:
67: CURSOR c_contact_party(l_contact_point_id NUMBER) IS
68: SELECT HZP.PARTY_ID,

Line 71: HZ_PARTIES HZP

67: CURSOR c_contact_party(l_contact_point_id NUMBER) IS
68: SELECT HZP.PARTY_ID,
69: HZP.PARTY_TYPE
70: FROM HZ_CONTACT_POINTS HCP,
71: HZ_PARTIES HZP
72: WHERE HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'
73: AND HZP.PARTY_ID = HCP.OWNER_TABLE_ID
74: AND HCP.CONTACT_POINT_TYPE = 'EMAIL'
75: AND HCP.CONTACT_POINT_ID = l_contact_point_id;

Line 72: WHERE HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'

68: SELECT HZP.PARTY_ID,
69: HZP.PARTY_TYPE
70: FROM HZ_CONTACT_POINTS HCP,
71: HZ_PARTIES HZP
72: WHERE HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'
73: AND HZP.PARTY_ID = HCP.OWNER_TABLE_ID
74: AND HCP.CONTACT_POINT_TYPE = 'EMAIL'
75: AND HCP.CONTACT_POINT_ID = l_contact_point_id;
76:

Line 79: FROM HZ_PARTIES HZP,

75: AND HCP.CONTACT_POINT_ID = l_contact_point_id;
76:
77: CURSOR c_party_person(l_party_id NUMBER) IS
78: SELECT HPR.PARTY_ID
79: FROM HZ_PARTIES HZP,
80: HZ_RELATIONSHIPS HPR
81: WHERE HZP.PARTY_ID = HPR.PARTY_ID
82: AND HPR.SUBJECT_ID = l_party_id;
83:

Line 86: FROM HZ_PARTIES HZP,

82: AND HPR.SUBJECT_ID = l_party_id;
83:
84: CURSOR c_party_rel(l_party_id NUMBER, l_object_id NUMBER) IS
85: SELECT HPR.SUBJECT_ID
86: FROM HZ_PARTIES HZP,
87: HZ_RELATIONSHIPS HPR
88: WHERE HZP.PARTY_ID = HPR.SUBJECT_ID
89: AND HPR.PARTY_ID = l_party_id
90: AND HPR.OBJECT_ID = l_object_id;