APPS.OTA_LP_NOTIFY_SS dependencies on HZ_CUST_ACCOUNT_ROLES

Line 128: FROM HZ_CUST_ACCOUNT_ROLES acct_role,

124: AND lpt.language = USERENV('LANG');
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

Line 174: hz_cust_account_roles rol

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
177: AND rol.party_id = usr.customer_id
178: AND rol.cust_account_role_id = p_contact_id;

Line 328: hz_cust_account_roles rol

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
331: AND rol.party_id = usr.customer_id
332: AND rol.cust_account_role_id = l_contact_id;*/