DBA Data[Home] [Help]

APPS.CZ_MODEL_UTIL_PVT dependencies on CZ_PS_NODES

Line 29: FOR psn_rec IN (SELECT ps_node_id, reference_id FROM cz_ps_nodes

25: )
26: IS
27:
28: BEGIN
29: FOR psn_rec IN (SELECT ps_node_id, reference_id FROM cz_ps_nodes
30: WHERE deleted_flag = '0' AND parent_id = p_parent_id
31: AND ps_node_type IN (PS_NODE_TYPE_REFERENCE,
32: PS_NODE_TYPE_COMPONENT,
33: PS_NODE_TYPE_OPTION_CLASS)

Line 446: cz_ps_nodes rootn

442: rootn.persistent_node_id as leaf_persistent_node_id
443: from
444: cz_ui_defs udf,
445: cz_model_ref_expls xpl,
446: cz_ps_nodes rootn
447: where
448: rootn.deleted_flag = '0' and
449: rootn.ps_node_id = xpl.component_id and
450: xpl.model_id = udf.devl_project_id and

Line 519: cz_ps_nodes comp,

515: enclexpl.model_ref_expl_id as ref_expl_node_id,
516: enclexpl.child_model_expl_id as leaf_expl_node_id,
517: comp.persistent_node_id as leaf_persistent_node_id
518: from
519: cz_ps_nodes comp,
520: cz_model_ref_expls rootxp,
521: cz_model_ref_expls enclexpl,
522: table (cast (listsofar as "SYSTEM".cz_uirefs_inmodel_tbl_type)) extlist
523: where