DBA Data[Home] [Help]

APPS.ICX_ON_UTILITIES dependencies on AK_FLOW_PAGES_VL

Line 33: from AK_FLOW_PAGES_VL

29: if p_page_code is not null
30: then
31: select NAME,PRIMARY_REGION_APPL_ID,PRIMARY_REGION_CODE
32: into l_page_title,l_region_appl_id,l_region_code
33: from AK_FLOW_PAGES_VL
34: where PAGE_CODE = p_page_code
35: and PAGE_APPLICATION_ID = p_page_appl_id
36: and FLOW_CODE = p_flow_code
37: and FLOW_APPLICATION_ID = p_flow_appl_id;

Line 617: from AK_FLOW_PAGES_VL

613: if p_page_code is not null
614: then
615: select NAME,DESCRIPTION
616: into l_page_title,l_page_description
617: from AK_FLOW_PAGES_VL
618: where PAGE_CODE = p_page_code
619: and PAGE_APPLICATION_ID = p_page_appl_id
620: and FLOW_CODE = p_flow_code
621: and FLOW_APPLICATION_ID = p_flow_appl_id;

Line 1241: from AK_FLOW_PAGES_VL

1237: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
1238:
1239: select NAME,DESCRIPTION
1240: into l_page_title,l_page_description
1241: from AK_FLOW_PAGES_VL
1242: where PAGE_CODE = l_page_code
1243: and PAGE_APPLICATION_ID = l_page_appl_id
1244: and FLOW_CODE = l_flow_code
1245: and FLOW_APPLICATION_ID = l_flow_appl_id;