DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on CZ_UI_PAGE_ELEMENTS

Line 2478: 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));

2474: l_qualified VARCHAR2(2000) := ' ';
2475: BEGIN
2476:
2477: IF inParent_id IS NOT NULL THEN
2478: 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));
2479: l_qualified:=l_qualified||'.Pages';
2480: FOR parent_node IN (SELECT distinct(name) , element_id FROM cz_ui_page_elements
2481: WHERE deleted_flag = '0'
2482: START WITH element_id = to_char(inParent_id)

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

2476:
2477: IF inParent_id IS NOT NULL THEN
2478: 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));
2479: l_qualified:=l_qualified||'.Pages';
2480: FOR parent_node IN (SELECT distinct(name) , element_id FROM cz_ui_page_elements
2481: WHERE deleted_flag = '0'
2482: START WITH element_id = to_char(inParent_id)
2483: CONNECT BY PRIOR parent_element_id=element_id
2484: order by element_id ) LOOP