547: RETURN(l_return_status);
548: END get_contract_status;
549: */
550: ---------------------------------------------------------------------------
551: -- FUNCTION get_rec for: OKL_INS_POLICIES_V
552: ---------------------------------------------------------------------------
553: FUNCTION get_rec (
554: p_ipyv_rec IN ipyv_rec_type,
555: x_no_data_found OUT NOCOPY BOOLEAN
628: CREATION_DATE,
629: LAST_UPDATED_BY,
630: LAST_UPDATE_DATE,
631: LAST_UPDATE_LOGIN
632: FROM Okl_Ins_Policies_V
633: WHERE okl_ins_policies_v.id = p_id;
634: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
635: l_ipyv_rec ipyv_rec_type;
636: BEGIN
629: LAST_UPDATED_BY,
630: LAST_UPDATE_DATE,
631: LAST_UPDATE_LOGIN
632: FROM Okl_Ins_Policies_V
633: WHERE okl_ins_policies_v.id = p_id;
634: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
635: l_ipyv_rec ipyv_rec_type;
636: BEGIN
637: x_no_data_found := TRUE;