APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_VP_ASSOCIATIONS

Line 4673: AND exists( select 1 from okl_vp_associations vpaso

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

Line 4706: AND exists( select 1 from okl_vp_associations vpaso

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

Line 4760: from okl_vp_associations vpaso

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