DBA Data[Home] [Help]

APPS.AR_CAO_ASSIGN_PKG dependencies on HZ_LOCATIONS

Line 170: country hz_locations.country%TYPE,

166: (cash_receipt_id NUMBER(15),
167: cust_account_id NUMBER(15),
168: site_use_id NUMBER(15),
169: profile_class_id NUMBER(15),
170: country hz_locations.country%TYPE,
171: org_id NUMBER(15),
172: currency_code ar_cash_receipts_all.currency_code%TYPE,
173: unidentified_amount NUMBER,
174: unapplied_amount NUMBER);

Line 233: 'hz_locations hl, '||

229: 'decode(acr.status, ''UNAPP'', ABS(aps.amount_due_remaining), 0) unapplied_amount '||
230: 'FROM ar_cash_receipts acr, '||
231: 'hz_cust_accounts hca, '||
232: 'hz_cust_site_uses hcsu, '||
233: 'hz_locations hl, '||
234: 'hz_party_sites hps, '||
235: 'hz_cust_acct_sites hcas, '||
236: 'ar_payment_schedules aps, '||
237: 'hz_customer_profiles hcp, '||