DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_PSNODE_PROPVAL_V

Line 6713: FROM CZ_PSNODE_PROPVAL_V

6709:
6710: BEGIN
6711: SELECT 1
6712: INTO l_prop_count
6713: FROM CZ_PSNODE_PROPVAL_V
6714: WHERE ps_node_id IN (select ps_node_id
6715: from cz_ps_nodes
6716: where cz_ps_nodes.deleted_flag = '0')
6717: AND property_id = p_property_id

Line 10905: FROM cz_psnode_propval_v

10901: IF(v_tExprId(ii) = v_tExprParentId(i))THEN
10902:
10903: BEGIN
10904: SELECT NVL(property_value, property_num_value) INTO v_property_value
10905: FROM cz_psnode_propval_v
10906: WHERE ps_node_id = v_tExprPsNodeId(ii)
10907: AND property_id = v_tPropertyId(i);
10908: EXCEPTION
10909: WHEN NO_DATA_FOUND THEN