DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on HZ_CUST_ACCOUNTS

Line 1823: hz_cust_accounts cust,

1819: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1820: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
1821: FROM hz_cust_acct_sites_all acct_site,
1822: hz_cust_site_uses_all site_use,
1823: hz_cust_accounts cust,
1824: oe_order_headers_all header
1825: WHERE header.header_id = p_header_id
1826: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
1827: AND acct_site.cust_account_id = cust.cust_account_id

Line 1999: hz_cust_accounts cust,

1995: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1996: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
1997: FROM hz_cust_acct_sites_all acct_site,
1998: hz_cust_site_uses_all site_use,
1999: hz_cust_accounts cust,
2000: oe_order_headers_all header
2001: WHERE header.header_id = p_header_id
2002: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
2003: AND acct_site.cust_account_id = cust.cust_account_id

Line 2965: FROM hz_cust_accounts

2961: l_orgIdTbl orgIdTbl;
2962:
2963: CURSOR party_id_csr(p_cust_account_id NUMBER) IS
2964: SELECT party_id
2965: FROM hz_cust_accounts
2966: WHERE cust_account_id = p_cust_account_id;
2967:
2968: CURSOR party_site_id_csr(p_account_site_id NUMBER) IS
2969: SELECT a.party_site_id