APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 2224: FROM hz_cust_accounts acct,

2220: acct_site.global_attribute8,
2221: acct_site.global_attribute9,
2222: site_use.location,
2223: site_use.tax_reference
2224: FROM hz_cust_accounts acct,
2225: hz_cust_site_uses_all site_use ,
2226: hz_cust_acct_sites_all acct_site
2227: WHERE acct.CUST_ACCOUNT_ID = acct_site.CUST_ACCOUNT_ID
2228: and acct_site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID

Line 2236: hz_cust_accounts acct

2232:
2233: CURSOR migrated_party_cur (c_cust_acct_id ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE) IS
2234: SELECT party.party_id
2235: FROM HZ_PARTIES PARTY,
2236: hz_cust_accounts acct
2237: WHERE PARTY.PARTY_ID = acct.party_id
2238: And acct.cust_account_id = c_cust_acct_id;
2239:
2240:

Line 2695: FROM hz_cust_accounts acct,

2691: acct_site.global_attribute8,
2692: acct_site.global_attribute9,
2693: site_use.location,
2694: site_use.tax_reference
2695: FROM hz_cust_accounts acct,
2696: hz_cust_site_uses_all site_use ,
2697: hz_cust_acct_sites_all acct_site
2698: WHERE acct.CUST_ACCOUNT_ID = acct_site.CUST_ACCOUNT_ID
2699: and acct_site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID

Line 2706: FROM hz_cust_accounts acct

2702: and site_use.site_use_code = c_ship_bill;
2703:
2704: CURSOR party_id_cur (c_cust_acct_id ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE) IS
2705: SELECT acct.party_id
2706: FROM hz_cust_accounts acct
2707: WHERE acct.cust_account_id = c_cust_acct_id;
2708:
2709: CURSOR party_site_id_cur ( c_cust_site_use_id ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_ID%TYPE) IS
2710: SELECT acct_site.party_site_id