36: -- Modified by zrehman on 18-Jan-2008 Bug#6763287
37: -- Check whether contract or IA
38: CURSOR chk_inv_csr(p_dnz_chr_id NUMBER) IS
39: select 1
40: from okc_k_headers_all_b
41: where id = p_dnz_chr_id
42: and scs_code = 'INVESTOR';
43:
44: PROCEDURE get_base_evg_recs(p_from IN passthru_dtl_rec_type,
1111: CURSOR l_inv_id_csr IS
1112: select hz.party_name
1113: from
1114: okc_k_lines_b cle
1115: , okc_k_headers_all_b chr
1116: , hz_parties hz
1117: , hz_cust_accounts hca
1118: where
1119: cle.chr_id = chr.id
1127: CURSOR l_inv_name_csr IS
1128: select hz.party_id
1129: from
1130: okc_k_lines_b cle
1131: , okc_k_headers_all_b chr
1132: , hz_parties hz
1133: , hz_cust_accounts hca
1134: where
1135: cle.chr_id = chr.id