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 1086: l_contact hz_parties.party_name%TYPE;

1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;
1084: l_city hz_locations.city%TYPE;
1085: l_postal_code hz_locations.postal_code%TYPE;
1086: l_contact hz_parties.party_name%TYPE;
1087: l_phone_number hz_contact_points.phone_number%TYPE;
1088: -- Added for Glob-006 ER
1089: l_province VARCHAR2(120);
1090: l_comm_num VARCHAR2(30);