APPS.OTA_LP_NOTIFY_SS dependencies on HZ_PARTIES

Line 65: l_contact_name HZ_PARTIES.party_name%TYPE;

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

Line 129: HZ_PARTIES party,

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

Line 137: and rel.subject_table_name = 'HZ_PARTIES'

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

Line 138: and rel.object_table_name = 'HZ_PARTIES'

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

Line 172: hz_parties party,

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

Line 326: hz_parties party,

322:
323: --Modified for bug#4644019
324: /*SELECT usr.user_name INTO l_user_name
325: FROM
326: hz_parties party,
327: fnd_user usr,
328: hz_cust_account_roles rol
329: WHERE
330: rol.party_id = party.party_id