APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_VP_ASSOCIATIONS

Line 4654: AND exists( select 1 from okl_vp_associations vpaso

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

Line 4687: AND exists( select 1 from okl_vp_associations vpaso

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

Line 4741: from okl_vp_associations vpaso

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

Line 9022: FROM okl_vp_associations vpaso

9018: WHERE chr.id = p_orig_system_id1
9019: AND chr.template_type_code = 'PROGRAM'
9020: AND NVL(chr.template_yn,'N') = 'Y'
9021: AND EXISTS(SELECT 1
9022: FROM okl_vp_associations vpaso
9023: WHERE vpaso.chr_id = p_khr_khr_id
9024: AND vpaso.assoc_object_id = p_orig_system_id1
9025: AND vpaso.assoc_object_type_code = 'LC_TEMPLATE');
9026: