DBA Data[Home] [Help]

APPS.OKL_INTEREST_CALC_PVT dependencies on OKC_CONTACTS

Line 116: from okc_contacts ct,

112:
113:
114: Cursor sales_csr(v_khr_id NUMBER) IS
115: SELECT ct.object1_id1 id
116: from okc_contacts ct,
117: okc_contact_sources csrc,
118: okc_k_party_roles_b pty,
119: okc_k_headers_b chr
120: where ct.cpl_id = pty.id

Line 132: l_sales_rep OKC_CONTACTS.object1_id1%TYPE;

128: and pty.dnz_chr_id = chr.id
129: and pty.chr_id = chr.id
130: and chr.id = v_khr_id;
131:
132: l_sales_rep OKC_CONTACTS.object1_id1%TYPE;
133:
134: CURSOR trx_csr IS
135: SELECT cust_trx_type_id
136: FROM ra_cust_trx_types