APPS.CZ_POPULATORS_PKG dependencies on CZ_MODEL_REF_EXPLS

Line 1118: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'

1114: -- delete an associated non-virtual components --
1115: --
1116: IF t_ps_node_id.Count>0 THEN
1117: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1118: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1119: WHERE model_id=t_devl_project(i) AND
1120: model_ref_expl_id
1121: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1122: WHERE deleted_flag='0'

Line 1121: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1117: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1118: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1119: WHERE model_id=t_devl_project(i) AND
1120: model_ref_expl_id
1121: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1122: WHERE deleted_flag='0'
1123: START WITH component_id=t_ps_node_id(i)
1124: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1125:

Line 1179: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'

1175: -- delete an associated non-virtual components --
1176: --
1177: IF t_ps_node_id.Count>0 THEN
1178: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1179: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1180: WHERE model_id=t_devl_project(i) AND
1181: model_ref_expl_id
1182: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1183: WHERE deleted_flag='0'

Line 1182: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1178: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1179: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1180: WHERE model_id=t_devl_project(i) AND
1181: model_ref_expl_id
1182: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1183: WHERE deleted_flag='0'
1184: START WITH component_id=t_ps_node_id(i)
1185: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1186: