APPS.OKL_OPI_PVT dependencies on HZ_LOCATIONS

Line 768: l_bill_to_address_id HZ_LOCATIONS.LOCATION_ID%TYPE;

764:
765: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
766: l_bill_to_add_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
767: l_party_rec party_rec_type;
768: l_bill_to_address_id HZ_LOCATIONS.LOCATION_ID%TYPE;
769:
770: CURSOR l_party_csr(cp_party_id IN NUMBER) IS
771: SELECT hp.party_name
772: ,hp.party_type

Line 807: FROM hz_locations hzl

803: ,hzl.floor
804: ,hzl.suite
805: ,hzl.room
806: ,hzl.postal_plus4_code
807: FROM hz_locations hzl
808: WHERE hzl.location_id = cp_bill_to_address_id;
809: BEGIN
810: l_return_status := OKL_CONTRACT_INFO.get_customer(p_contract_id, l_party_rec.party_id);
811: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 914: ,hz_locations hl

910: ,hl.postal_plus4_code
911: FROM okc_k_party_roles_b opr
912: ,hz_parties hp
913: ,hz_party_sites hps
914: ,hz_locations hl
915: ,hz_party_site_uses hpsu
916: WHERE opr.dnz_chr_id = cp_contract_id
917: AND opr.rle_code = 'GUARANTOR'
918: AND opr.object1_id1 = hp.party_id

Line 1374: FROM hz_locations hl

1370: ,hl.floor
1371: ,hl.suite
1372: ,hl.room
1373: ,hl.postal_plus4_code
1374: FROM hz_locations hl
1375: ,(SELECT location_id
1376: FROM hz_party_sites
1377: WHERE party_site_id = cp_location_id) hps
1378: WHERE hl.location_id = hps.location_id;