DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 28580: l_customer_id okc_k_party_roles_v.object1_id1%TYPE;

28576: AND chr_id = dnz_chr_id
28577: AND jtot_object1_code = 'OKX_PARTY'
28578: AND rle_code = 'LESSEE';
28579:
28580: l_customer_id okc_k_party_roles_v.object1_id1%TYPE;
28581: l_customer_number okl_header_interface.customer_number%TYPE;
28582:
28583: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28584: SELECT sales.object1_id1

Line 28586: okc_k_party_roles_v party

28582:
28583: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28584: SELECT sales.object1_id1
28585: FROM okc_contacts_v sales,
28586: okc_k_party_roles_v party
28587: WHERE sales.cpl_id = party.id
28588: AND party.rle_code = 'LESSOR'
28589: AND party.chr_id = p_chr_id
28590: AND party.dnz_chr_id = p_chr_id -- Bug# 3862650