[Home] [Help]
1515: x_party_name hz_parties.party_name%TYPE := NULL;
1516: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
1517: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;
1518: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;
1519: x_location hz_locations.city%TYPE := NULL;
1520: x_bank_id hz_parties.party_id%TYPE := NULL;
1521: x_branch_id hz_parties.party_id%TYPE := NULL;
1522: x_acct_id IBY_EXT_BANK_ACCOUNTS.EXT_BANK_ACCOUNT_ID%TYPE := NULL;
1523: x_account_assignment_id NUMBER;
2167: x_party_name hz_parties.party_name%TYPE := NULL;
2168: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
2169: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;
2170: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;
2171: x_location hz_locations.city%TYPE := NULL;
2172:
2173:
2174:
2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2792: x_party_name hz_parties.party_name%TYPE := NULL;
2793: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
2794: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;
2795: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;
2796: x_location hz_locations.city%TYPE := NULL;
2797:
2798: l_inv_trx_type_id NUMBER;
2799:
2800: l_cur_code VARCHAR2(30);
3406: x_party_site_name,
3407: x_location
3408: FROM hz_party_sites hps,
3409: ap_supplier_sites_all vs,
3410: hz_locations loc
3411: WHERE vs.vendor_site_id = p_vendor_site_id
3412: AND vs.party_site_id = hps.party_site_id
3413: AND hps.location_id = loc.location_id
3414: AND hps.party_id = p_party_id
3429: INTO x_party_site_id,
3430: x_party_site_name,
3431: x_location
3432: FROM hz_party_sites hps,
3433: hz_locations loc
3434: WHERE hps.party_id = p_party_id
3435: AND hps.location_id = loc.location_id
3436: AND hps.identifying_address_flag = 'Y'
3437: AND ROWNUM =1;