DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on HZ_PARTIES

Line 864: hz_parties hzp,

860: zx_rates_b at,
861: ar_cash_receipts_all ac,
862: ra_customer_trx tr,
863: hz_cust_accounts rc,
864: hz_parties hzp,
865: hz_cust_acct_sites cs,
866: hz_cust_site_uses csu
867: WHERE aa.applied_customer_trx_id = tr.customer_trx_id
868: AND aa.cash_receipt_id = P_CASH_RECEIPT_ID

Line 1115: l_contact hz_parties.party_name%TYPE;

1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;
1114: l_postal_code hz_locations.postal_code%TYPE;
1115: l_contact hz_parties.party_name%TYPE;
1116: l_phone_number hz_contact_points.phone_number%TYPE;
1117: -- Added for Glob-006 ER
1118: l_province VARCHAR2(120);
1119: l_comm_num VARCHAR2(30);