[Home] [Help]
1243: iby_creditcard_issuers_vl i,
1244: hz_parties hzcc,
1245: hz_party_site_uses psu,
1246: hz_party_sites hps,
1247: hz_locations loc,
1248: fnd_territories_vl terr,
1249: fnd_lookup_values_vl ccunk
1250: WHERE cust.cust_account_id = p_customer_id
1251: AND pp1.party_id = cust.party_id
1349: hz_parties hzcc,
1350: hz_cust_accounts cust,
1351: hz_party_site_uses psu,
1352: hz_party_sites hps,
1353: hz_locations loc,
1354: fnd_territories_vl terr
1355: WHERE
1356: cust.cust_account_id = p_customer_id
1357: AND p.cust_account_id = cust.cust_account_id
2998: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
2999: l_party_site_number VARCHAR2(30);
3000: l_object_version_number NUMBER(15,0);
3001: CURSOR location_id_cur IS
3002: 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
3003: and hps.location_id = hl.location_id;
3004: location_id_rec location_id_cur%ROWTYPE;
3005:
3006: l_procedure_name VARCHAR2(30);
5864: l_object_version_number NUMBER(15,0);
5865:
5866: CURSOR location_id_cur IS
5867: select hps.location_id, hl.object_version_number
5868: from hz_party_sites hps, hz_locations hl
5869: where party_site_id = x_cc_bill_to_site_id
5870: and hps.location_id = hl.location_id;
5871:
5872: location_id_rec location_id_cur%ROWTYPE;