APPS.OTA_LP_NOTIFY_SS dependencies on HZ_PARTIES

Line 64: l_contact_name HZ_PARTIES.party_name%TYPE;

60:
61: l_creator_person_id per_all_people_f.person_id%type;
62: l_person_id per_all_people_f.person_id%type;
63: l_contact_id number;
64: l_contact_name HZ_PARTIES.party_name%TYPE;
65:
66: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
67: l_role_name wf_roles.name%type;
68: l_role_display_name wf_roles.display_name%type;

Line 128: HZ_PARTIES party,

124:
125: CURSOR csr_get_contact_name IS
126: SELECT PARTY.party_name contact_name
127: FROM HZ_CUST_ACCOUNT_ROLES acct_role,
128: HZ_PARTIES party,
129: HZ_RELATIONSHIPS rel,
130: HZ_ORG_CONTACTS org_cont,
131: HZ_CUST_ACCOUNTS role_acct
132: WHERE acct_role.party_id = rel.party_id

Line 136: and rel.subject_table_name = 'HZ_PARTIES'

132: WHERE acct_role.party_id = rel.party_id
133: and acct_role.role_type = 'CONTACT'
134: and org_cont.party_relationship_id = rel.relationship_id
135: and rel.subject_id = party.party_id
136: and rel.subject_table_name = 'HZ_PARTIES'
137: and rel.object_table_name = 'HZ_PARTIES'
138: and acct_role.cust_account_id = role_acct.cust_account_id
139: and role_acct.party_id = rel.object_id
140: AND acct_role.cust_account_role_id = l_contact_id;

Line 137: and rel.object_table_name = 'HZ_PARTIES'

133: and acct_role.role_type = 'CONTACT'
134: and org_cont.party_relationship_id = rel.relationship_id
135: and rel.subject_id = party.party_id
136: and rel.subject_table_name = 'HZ_PARTIES'
137: and rel.object_table_name = 'HZ_PARTIES'
138: and acct_role.cust_account_id = role_acct.cust_account_id
139: and role_acct.party_id = rel.object_id
140: AND acct_role.cust_account_role_id = l_contact_id;
141:

Line 170: hz_parties party,

166:
167: CURSOR csr_get_contact_user_name(p_contact_id IN NUMBER) IS
168: SELECT usr.user_name
169: FROM
170: hz_parties party,
171: fnd_user usr,
172: hz_cust_account_roles rol
173: WHERE
174: rol.party_id = party.party_id

Line 305: hz_parties party,

301:
302: --Modified for bug#4644019
303: /*SELECT usr.user_name INTO l_user_name
304: FROM
305: hz_parties party,
306: fnd_user usr,
307: hz_cust_account_roles rol
308: WHERE
309: rol.party_id = party.party_id