DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on CZ_UI_PAGE_ELEMENTS

Line 2457: select name INTO l_qualified from cz_ui_defs where ui_def_id = (select max(ui_def_id) from cz_ui_page_elements where element_id = to_char(inParent_id));

2453: l_qualified VARCHAR2(2000) := ' ';
2454: BEGIN
2455:
2456: IF inParent_id IS NOT NULL THEN
2457: select name INTO l_qualified from cz_ui_defs where ui_def_id = (select max(ui_def_id) from cz_ui_page_elements where element_id = to_char(inParent_id));
2458: l_qualified:=l_qualified||'.Pages';
2459: FOR parent_node IN (SELECT distinct(name) , element_id FROM cz_ui_page_elements
2460: WHERE deleted_flag = '0'
2461: START WITH element_id = to_char(inParent_id)

Line 2459: FOR parent_node IN (SELECT distinct(name) , element_id FROM cz_ui_page_elements

2455:
2456: IF inParent_id IS NOT NULL THEN
2457: select name INTO l_qualified from cz_ui_defs where ui_def_id = (select max(ui_def_id) from cz_ui_page_elements where element_id = to_char(inParent_id));
2458: l_qualified:=l_qualified||'.Pages';
2459: FOR parent_node IN (SELECT distinct(name) , element_id FROM cz_ui_page_elements
2460: WHERE deleted_flag = '0'
2461: START WITH element_id = to_char(inParent_id)
2462: CONNECT BY PRIOR parent_element_id=element_id
2463: order by element_id ) LOOP