1162:
1163: PROCEDURE get_bill_to_address (
1164: p_contract_id IN NUMBER,
1165: p_message_yn IN BOOLEAN,
1166: x_bill_to_address_rec OUT NOCOPY okx_cust_site_uses_v%ROWTYPE,
1167: x_return_status OUT NOCOPY VARCHAR2) IS
1168:
1169: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
1170: -- Get Bill to Values for LESSEE
1185: -- Removed cp_id2 from parameters and from WHERE
1186: -- Select bill_to record
1187: CURSOR l_bill_to_address_csr (cp_id1 NUMBER) IS
1188: SELECT *
1189: FROM okx_cust_site_uses_v cst
1190: WHERE cst.id1 = cp_id1;
1191: -- AND cst.id2 = cp_id2;
1192:
1193: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1191: -- AND cst.id2 = cp_id2;
1192:
1193: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1194: l_rulv_rec okl_rule_pub.rulv_rec_type;
1195: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1196:
1197: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
1198: l_bto_values_rec l_bto_values_csr%ROWTYPE;
1199: l_party_name VARCHAR2(320);