APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_POLICIES_V

Line 5198: -- FUNCTION get_rec for: OKL_INS_POLICIES_V

5194: p_to.territory_code := p_from.territory_code;
5195: END migrate;
5196: --Mark
5197: ---------------------------------------------------------------------------
5198: -- FUNCTION get_rec for: OKL_INS_POLICIES_V
5199: ---------------------------------------------------------------------------
5200: FUNCTION get_rec (
5201: px_ipyv_rec IN OUT NOCOPY ipyv_rec_type,
5202: x_no_data_found OUT NOCOPY BOOLEAN

Line 5281: FROM Okl_Ins_Policies_V

5277: LAST_UPDATED_BY,
5278: LAST_UPDATE_DATE,
5279: LAST_UPDATE_LOGIN,
5280: TERRITORY_CODE
5281: FROM Okl_Ins_Policies_V
5282: WHERE okl_ins_policies_v.id = p_id;
5283: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
5284: l_ipyv_rec ipyv_rec_type;
5285: BEGIN

Line 5282: WHERE okl_ins_policies_v.id = p_id;

5278: LAST_UPDATE_DATE,
5279: LAST_UPDATE_LOGIN,
5280: TERRITORY_CODE
5281: FROM Okl_Ins_Policies_V
5282: WHERE okl_ins_policies_v.id = p_id;
5283: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
5284: l_ipyv_rec ipyv_rec_type;
5285: BEGIN
5286: x_no_data_found := TRUE;

Line 5720: OKL_INS_POLICIES_V IPYV

5716: -- attached to assets of the contract.
5717: cursor chk_claims (c_khr_id NUMBER ,c_qte_eff_date DATE )is
5718: Select CLMB.ID,CLMB.claim_date
5719: From okl_ins_claims_B CLMB,
5720: OKL_INS_POLICIES_V IPYV
5721: WHERE CLMB.ipy_id = IPYV.id
5722: AND trunc(CLMB.claim_date) >= trunc(c_qte_eff_date)
5723: AND CLMB.CSU_CODE <> 'SUBMITTED'
5724: AND IPYV.ISS_CODE ='ACTIVE'