APPS.OTA_LP_NOTIFY_SS dependencies on HZ_CUST_ACCOUNT_ROLES

Line 127: FROM HZ_CUST_ACCOUNT_ROLES acct_role,

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

Line 172: hz_cust_account_roles rol

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

Line 307: hz_cust_account_roles rol

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