DBA Data[Home] [Help]

APPS.CZ_MODEL_UTIL_PVT dependencies on CZ_EXPLMODEL_NODES_V

Line 164: foundnodes CZ_EXPLMODEL_NODES_V%rowtype;

160: root_closest_path_index number; -- 20040730:3b
161: root_closest_path_marker number;
162:
163: pathiter integer;
164: foundnodes CZ_EXPLMODEL_NODES_V%rowtype;
165: foundcount integer := 0;
166:
167: BEGIN
168: -- Parameter check: namepath

Line 234: FROM CZ_EXPLMODEL_NODES_V XPLNODE

230: -- is the root expl, this is a direct child of root
231: 99),
232: 999
233: ) as NEAR_ROOT_MARKER
234: FROM CZ_EXPLMODEL_NODES_V XPLNODE
235: , CZ_MODEL_REF_EXPLS ROOTEXPL
236: WHERE XPLNODE.model_id = p_model_to_search
237: AND ROOTEXPL.MODEL_ID = P_MODEL_TO_SEARCH
238: AND ROOTEXPL.parent_expl_node_id IS NULL

Line 318: CZ_EXPLMODEL_NODES_V XPLNODE,

314: ) as WHOLE_PATH_EFFECTIVE_UNTIL,
315: --
316: PARNODE.NEAR_ROOT_MARKER -- ADW20040730:3a
317: FROM
318: CZ_EXPLMODEL_NODES_V XPLNODE,
319: -- table (cast (LASTMARKS AS cz_model_node_tbl_type)) PARMARK, -- ADW20040730:3a
320: table (cast (LASTFOUND as "SYSTEM".cz_model_node_tbl_type)) PARNODE
321: WHERE
322: XPLNODE.model_id = p_model_to_search