APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_POLICIES_V

Line 5205: -- FUNCTION get_rec for: OKL_INS_POLICIES_V

5201: p_to.territory_code := p_from.territory_code;
5202: END migrate;
5203: --Mark
5204: ---------------------------------------------------------------------------
5205: -- FUNCTION get_rec for: OKL_INS_POLICIES_V
5206: ---------------------------------------------------------------------------
5207: FUNCTION get_rec (
5208: px_ipyv_rec IN OUT NOCOPY ipyv_rec_type,
5209: x_no_data_found OUT NOCOPY BOOLEAN

Line 5288: FROM Okl_Ins_Policies_V

5284: LAST_UPDATED_BY,
5285: LAST_UPDATE_DATE,
5286: LAST_UPDATE_LOGIN,
5287: TERRITORY_CODE
5288: FROM Okl_Ins_Policies_V
5289: WHERE okl_ins_policies_v.id = p_id;
5290: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
5291: l_ipyv_rec ipyv_rec_type;
5292: BEGIN

Line 5289: WHERE okl_ins_policies_v.id = p_id;

5285: LAST_UPDATE_DATE,
5286: LAST_UPDATE_LOGIN,
5287: TERRITORY_CODE
5288: FROM Okl_Ins_Policies_V
5289: WHERE okl_ins_policies_v.id = p_id;
5290: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
5291: l_ipyv_rec ipyv_rec_type;
5292: BEGIN
5293: x_no_data_found := TRUE;

Line 5727: OKL_INS_POLICIES_V IPYV

5723: -- attached to assets of the contract.
5724: cursor chk_claims (c_khr_id NUMBER ,c_qte_eff_date DATE )is
5725: Select CLMB.ID,CLMB.claim_date
5726: From okl_ins_claims_B CLMB,
5727: OKL_INS_POLICIES_V IPYV
5728: WHERE CLMB.ipy_id = IPYV.id
5729: AND trunc(CLMB.claim_date) >= trunc(c_qte_eff_date)
5730: AND CLMB.CSU_CODE <> 'SUBMITTED'
5731: AND IPYV.ISS_CODE ='ACTIVE'