DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 28283: l_customer_id okc_k_party_roles_v.object1_id1%TYPE;

28279: AND chr_id = dnz_chr_id
28280: AND jtot_object1_code = 'OKX_PARTY'
28281: AND rle_code = 'LESSEE';
28282:
28283: l_customer_id okc_k_party_roles_v.object1_id1%TYPE;
28284: l_customer_number okl_header_interface.customer_number%TYPE;
28285:
28286: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28287: SELECT sales.object1_id1

Line 28289: okc_k_party_roles_v party

28285:
28286: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28287: SELECT sales.object1_id1
28288: FROM okc_contacts_v sales,
28289: okc_k_party_roles_v party
28290: WHERE sales.cpl_id = party.id
28291: AND party.rle_code = 'LESSOR'
28292: AND party.chr_id = p_chr_id
28293: AND party.dnz_chr_id = p_chr_id -- Bug# 3862650