DBA Data[Home] [Help]

APPS.OKL_INTEREST_CALC_PVT dependencies on OKC_CONTACTS

Line 122: from okc_contacts ct,

118:
119:
120: Cursor sales_csr(v_khr_id NUMBER) IS
121: SELECT ct.object1_id1 id
122: from okc_contacts ct,
123: okc_contact_sources csrc,
124: okc_k_party_roles_b pty,
125: okc_k_headers_b chr
126: where ct.cpl_id = pty.id

Line 138: l_sales_rep OKC_CONTACTS.object1_id1%TYPE;

134: and pty.dnz_chr_id = chr.id
135: and pty.chr_id = chr.id
136: and chr.id = v_khr_id;
137:
138: l_sales_rep OKC_CONTACTS.object1_id1%TYPE;
139:
140: CURSOR trx_csr IS
141: SELECT cust_trx_type_id
142: FROM ra_cust_trx_types