APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_VP_ASSOCIATIONS

Line 4676: AND exists( select 1 from okl_vp_associations vpaso

4672: AND prl.object1_id1 = p_object1_id1
4673: AND prl.object1_id2 = p_object1_id2
4674: AND prl.jtot_object1_code = p_customer_code
4675: AND CHR.contract_number = p_source_contract_number
4676: AND exists( select 1 from okl_vp_associations vpaso
4677: where vpaso.chr_id = l_prog_id);
4678:
4679: -- cursor when only customer and program is selected
4680: CURSOR l_leaseAppTmpl2_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS

Line 4709: AND exists( select 1 from okl_vp_associations vpaso

4705: AND CHR.scs_code = p_scs_code
4706: AND CHR.chr_type = 'CYA'
4707: AND NVL(CHR.template_yn,'N') = p_temp_yn
4708: AND CHR.contract_number = p_source_contract_number
4709: AND exists( select 1 from okl_vp_associations vpaso
4710: where vpaso.chr_id = l_prog_id);
4711:
4712: -- cursor when only program is selected
4713: CURSOR l_leaseAppTmpl3_crs(l_prog_id NUMBER) IS

Line 4763: from okl_vp_associations vpaso

4759: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM
4760: AND CHR.contract_number = p_source_contract_number;
4761: /*
4762: AND exists( select 1
4763: from okl_vp_associations vpaso
4764: where vpaso.chr_id = p_prog_id
4765: and vpaso.assoc_object_type_code = 'LC_TEMPLATE'
4766: and NVL(vpaso.start_date,p_effective_from) <= p_effective_from
4767: and NVL(vpaso.end_date,p_effective_from) >= p_effective_from);