APPS.ASP_ORDER_ALERT_AGENT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 80: hz_cust_accounts_all cust_acct

76: CURSOR get_customer_id(c_blanket_header_id in number) is
77: SELECT party.party_id as customer_id
78: FROM oe_blanket_headers_all oobha,
79: hz_parties party,
80: hz_cust_accounts_all cust_acct
81: WHERE oobha.header_id = c_blanket_header_id
82: and oobha.sold_to_org_id = cust_acct.cust_account_id(+)
83: and cust_acct.party_id = party.party_id(+)
84: and oobha.sales_document_type_code = 'B'