APPS.OKL_INS_QUOTE_PVT dependencies on OKL_INS_POLICIES_V

Line 3135: -- FUNCTION get_rec for: OKL_INS_POLICIES_V

3131: '_PROCESS'
3132: );
3133: END create_contract_line;
3134: ---------------------------------------------------------------------------
3135: -- FUNCTION get_rec for: OKL_INS_POLICIES_V
3136: ---------------------------------------------------------------------------
3137: FUNCTION get_rec (
3138: p_ipyv_rec IN ipyv_rec_type,
3139: x_no_data_found OUT NOCOPY BOOLEAN

Line 3218: FROM Okl_Ins_Policies_V

3214: LAST_UPDATED_BY,
3215: LAST_UPDATE_DATE,
3216: LAST_UPDATE_LOGIN,
3217: TERRITORY_CODE
3218: FROM Okl_Ins_Policies_V
3219: WHERE okl_ins_policies_v.id = p_id;
3220: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
3221: l_ipyv_rec ipyv_rec_type;
3222: BEGIN

Line 3219: WHERE okl_ins_policies_v.id = p_id;

3215: LAST_UPDATE_DATE,
3216: LAST_UPDATE_LOGIN,
3217: TERRITORY_CODE
3218: FROM Okl_Ins_Policies_V
3219: WHERE okl_ins_policies_v.id = p_id;
3220: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
3221: l_ipyv_rec ipyv_rec_type;
3222: BEGIN
3223: x_no_data_found := TRUE;

Line 5897: FROM Okl_Ins_Policies_V

5893: KHR_ID,
5894: KLE_ID,
5895: ISS_CODE,
5896: IPY_TYPE
5897: FROM Okl_Ins_Policies_V
5898: WHERE Okl_Ins_Policies_V.KHR_ID = p_id
5899: AND ISS_CODE = 'ACCEPTED' ;
5900: l_okl_ipyv_pk_csr okl_ipyv_pk_csr%ROWTYPE;
5901: l_ipyv_rec ipyv_rec_type;

Line 5898: WHERE Okl_Ins_Policies_V.KHR_ID = p_id

5894: KLE_ID,
5895: ISS_CODE,
5896: IPY_TYPE
5897: FROM Okl_Ins_Policies_V
5898: WHERE Okl_Ins_Policies_V.KHR_ID = p_id
5899: AND ISS_CODE = 'ACCEPTED' ;
5900: l_okl_ipyv_pk_csr okl_ipyv_pk_csr%ROWTYPE;
5901: l_ipyv_rec ipyv_rec_type;
5902: lx_ipyv_rec ipyv_rec_type;

Line 7789: FROM OKL_INS_POLICIES_V

7785: ) RETURN VARCHAR2 IS
7786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7787: CURSOR inq_type_csr (quote_id IN NUMBER) IS
7788: SELECT IPY_TYPE
7789: FROM OKL_INS_POLICIES_V
7790: WHERE OKL_INS_POLICIES_V.ID = quote_id;
7791: BEGIN
7792: OPEN inq_type_csr(p_quote_id);
7793: FETCH inq_type_csr INTO x_quote_type ;

Line 7790: WHERE OKL_INS_POLICIES_V.ID = quote_id;

7786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7787: CURSOR inq_type_csr (quote_id IN NUMBER) IS
7788: SELECT IPY_TYPE
7789: FROM OKL_INS_POLICIES_V
7790: WHERE OKL_INS_POLICIES_V.ID = quote_id;
7791: BEGIN
7792: OPEN inq_type_csr(p_quote_id);
7793: FETCH inq_type_csr INTO x_quote_type ;
7794: IF (inq_type_csr%NOTFOUND) THEN