DBA Data[Home] [Help]

APPS.CZ_SECURITY_PVT dependencies on CZ_UI_NODES

Line 782: FROM cz_ui_nodes

778: SELECT ui_def_ref_id
779: BULK
780: COLLECT
781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION

Line 783: WHERE cz_ui_nodes.deleted_flag = '0'

779: BULK
780: COLLECT
781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN

Line 784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL

780: COLLECT
781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: NULL;

Line 785: AND cz_ui_nodes.ui_def_id = p_entity_id;

781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: NULL;
789: END;

Line 901: FROM cz_ui_nodes

897: SELECT ui_def_ref_id
898: BULK
899: COLLECT
900: INTO l_locked_entities
901: FROM cz_ui_nodes
902: WHERE deleted_flag = '0'
903: AND ui_def_ref_id IS NOT NULL
904: AND ui_def_id = p_entity_id;
905: