eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AUTO_REMINDER dependencies on HZ_CUST_ACCOUNT_ROLES

Line 198: FROM hz_cust_account_roles car,

194: p_quote_to_contact_id IN NUMBER
195: )
196: IS
197: SELECT hzp.party_id
198: FROM hz_cust_account_roles car,
199: hz_relationships rln,
200: hz_parties hzp
201: WHERE car.cust_account_role_id = p_quote_to_contact_id
202: AND car.party_id = rln.party_id

Line 398: FROM hz_cust_account_roles car,

394: -- SSO changes
395: CURSOR csr_qtc_person_party_id
396: IS
397: SELECT hzp.party_id
398: FROM hz_cust_account_roles car,
399: hz_relationships rln,
400: hz_parties hzp,
401: oks_k_headers_b ks
402: WHERE ks.quote_to_contact_id = car.cust_account_role_id

Line 2631: FROM hz_cust_account_roles car,

2627: p_quote_to_contact_id IN NUMBER
2628: )
2629: IS
2630: SELECT hzp.party_id
2631: FROM hz_cust_account_roles car,
2632: hz_relationships rln,
2633: hz_parties hzp
2634: WHERE car.cust_account_role_id = p_quote_to_contact_id
2635: AND car.party_id = rln.party_id