APPS.AR_IREC_PAYMENTS dependencies on HZ_PARTY_SITES

Line 1318: hz_party_sites hps,

1314: iby_external_payers_all p,
1315: IBY_FNDCPT_PAYER_ASSGN_INSTR_V c,
1316: hz_parties hzcc,
1317: hz_party_site_uses psu,
1318: hz_party_sites hps,
1319: hz_locations loc,
1320: fnd_territories_vl terr,
1321: (select ENCRYPT_SUPPLEMENTAL_CARD_DATA as supplemental_data_option from iby_sys_security_options) sysoptions
1322: WHERE cust.cust_account_id = p_customer_id

Line 1424: hz_party_sites hps,

1420: iby_pmt_instr_uses_all u,
1421: hz_parties hzcc,
1422: hz_cust_accounts cust,
1423: hz_party_site_uses psu,
1424: hz_party_sites hps,
1425: hz_locations loc,
1426: fnd_territories_vl terr
1427: WHERE
1428: cust.cust_account_id = p_customer_id

Line 3471: select hps.location_id, hl.object_version_number from hz_party_sites hps, hz_locations hl where party_site_id = x_cc_bill_to_site_id

3467: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
3468: l_party_site_number VARCHAR2(30);
3469: l_object_version_number NUMBER(15,0);
3470: CURSOR location_id_cur IS
3471: select hps.location_id, hl.object_version_number from hz_party_sites hps, hz_locations hl where party_site_id = x_cc_bill_to_site_id
3472: and hps.location_id = hl.location_id;
3473: location_id_rec location_id_cur%ROWTYPE;
3474:
3475: l_procedure_name VARCHAR2(30);

Line 6516: from hz_party_sites hps, hz_locations hl

6512: l_object_version_number NUMBER(15,0);
6513:
6514: CURSOR location_id_cur IS
6515: select hps.location_id, hl.object_version_number
6516: from hz_party_sites hps, hz_locations hl
6517: where party_site_id = x_cc_bill_to_site_id
6518: and hps.location_id = hl.location_id;
6519:
6520: location_id_rec location_id_cur%ROWTYPE;