APPS.OKL_MLA_CREATE_UPDATE_PUB dependencies on AK_ATTRIBUTES_VL

Line 28: from ak_region_items ri, ak_regions r, ak_attributes_vl a

24: RETURN VARCHAR2 IS
25:
26: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
27: select a.attribute_label_long
28: from ak_region_items ri, ak_regions r, ak_attributes_vl a
29: where ri.region_code = r.region_code
30: and ri.region_application_id = r.region_application_id
31: and ri.attribute_code = a.attribute_code
32: and ri.attribute_application_id = a.attribute_application_id

Line 37: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

33: and ri.region_code = p_ak_region
34: and ri.attribute_code = p_ak_attribute
35: ;
36:
37: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
38: BEGIN
39: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
40: FETCH ak_prompt_csr INTO l_ak_prompt;
41: CLOSE ak_prompt_csr;

Line 726: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

722: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
723: l_object_code VARCHAR2(30) DEFAULT NULL;
724: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
725:
726: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
727:
728: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
729: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
730: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;