APPS.OKS_AUTH_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 5611: FROM HZ_PARTY_SITES

5607:
5608: CURSOR l_csr_Get_party_sites(p_party_id IN NUMBER)
5609: IS
5610: SELECT party_site_id
5611: FROM HZ_PARTY_SITES
5612: WHERE party_id = p_party_id
5613: AND identifying_address_flag = 'Y';
5614:
5615: -- Get customer account id

Line 5657: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;

5653: l_inv_organization_id NUMBER;
5654: l_dnz_chr_id NUMBER;
5655: l_party_id NUMBER;
5656: l_uom OKC_K_ITEMS.uom_code%TYPE;
5657: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
5658: l_rgp_id OKC_RULE_GROUPS_B.id%TYPE;
5659: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
5660:
5661:

Line 5784: p_instance_rec.location_type_code := 'HZ_PARTY_SITES';

5780: p_instance_rec.active_start_date := '';
5781: p_instance_rec.active_end_date := '';
5782:
5783: p_instance_rec.in_transit_order_line_id := NULL;
5784: p_instance_rec.location_type_code := 'HZ_PARTY_SITES';
5785: p_instance_rec.location_id := NVL(ship_to(p_cle_id), l_party_site_id ) ;
5786:
5787:
5788: