APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_VP_ASSOCIATIONS

Line 4657: AND exists( select 1 from okl_vp_associations vpaso

4653: AND prl.object1_id1 = p_object1_id1
4654: AND prl.object1_id2 = p_object1_id2
4655: AND prl.jtot_object1_code = p_customer_code
4656: AND CHR.contract_number = p_source_contract_number
4657: AND exists( select 1 from okl_vp_associations vpaso
4658: where vpaso.chr_id = l_prog_id);
4659:
4660: -- cursor when only customer and program is selected
4661: CURSOR l_leaseAppTmpl2_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS

Line 4690: AND exists( select 1 from okl_vp_associations vpaso

4686: AND CHR.scs_code = p_scs_code
4687: AND CHR.chr_type = 'CYA'
4688: AND NVL(CHR.template_yn,'N') = p_temp_yn
4689: AND CHR.contract_number = p_source_contract_number
4690: AND exists( select 1 from okl_vp_associations vpaso
4691: where vpaso.chr_id = l_prog_id);
4692:
4693: -- cursor when only program is selected
4694: CURSOR l_leaseAppTmpl3_crs(l_prog_id NUMBER) IS

Line 4744: from okl_vp_associations vpaso

4740: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM
4741: AND CHR.contract_number = p_source_contract_number;
4742: /*
4743: AND exists( select 1
4744: from okl_vp_associations vpaso
4745: where vpaso.chr_id = p_prog_id
4746: and vpaso.assoc_object_type_code = 'LC_TEMPLATE'
4747: and NVL(vpaso.start_date,p_effective_from) <= p_effective_from
4748: and NVL(vpaso.end_date,p_effective_from) >= p_effective_from);

Line 9117: FROM okl_vp_associations vpaso

9113: WHERE chr.id = p_orig_system_id1
9114: AND chr.template_type_code = 'PROGRAM'
9115: AND NVL(chr.template_yn,'N') = 'Y'
9116: AND EXISTS(SELECT 1
9117: FROM okl_vp_associations vpaso
9118: WHERE vpaso.chr_id = p_khr_khr_id
9119: AND vpaso.assoc_object_id = p_orig_system_id1
9120: AND vpaso.assoc_object_type_code = 'LC_TEMPLATE');
9121: