DBA Data[Home] [Help]

APPS.OKL_INSURANCE_WF dependencies on OKC_K_HEADERS_B

Line 223: FROM okc_k_headers_b hdr,

219: CURSOR party_info_csr (p_contract_id NUMBER ) IS
220: SELECT hze.party_site_id address,
221: hdr.cust_acct_id acctid,
222: rle.OBJECT1_ID1 partyid
223: FROM okc_k_headers_b hdr,
224: okc_k_party_roles_b rle,
225: hz_cust_acct_sites_all hze,
226: hz_cust_site_uses_all hz
227: WHERE rle.rle_code = 'LESSEE'