APPS.OE_NOTIFY_USER_WF dependencies on HZ_PARTIES

Line 450: hz_parties party

446: INTO l_customer_id
447: FROM hz_cust_site_uses_all site,
448: hz_cust_acct_sites_all cas,
449: hz_cust_accounts cust,
450: hz_parties party
451: WHERE site.site_use_code = 'BILL_TO'
452: AND site.site_use_id = l_invoice_to_org_id
453: AND site.cust_acct_site_id = cas.cust_acct_site_id
454: AND cas.cust_account_id = cust.cust_account_id

Line 491: AND hr.subject_table_name = 'HZ_PARTIES'

487: AND hr.subject_id = fu.customer_id
488: AND hr.party_id = hcar.party_id
489: AND hr.relationship_code = 'CONTACT_OF'
490: AND hr.status = 'A'
491: AND hr.subject_table_name = 'HZ_PARTIES'
492: AND (hr.end_date IS NULL OR hr.end_date > SYSDATE)
493: AND (fu.end_date IS NULL OR fu.end_date > SYSDATE)
494: AND fnd_profile.value_specific('ONT_SEND_STATUS_UPDATE_NOTIFICATION',fu.user_id) = 'Y'
495: );