DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_PSNODE_PROPVAL_V

Line 6684: FROM CZ_PSNODE_PROPVAL_V

6680:
6681: BEGIN
6682: SELECT 1
6683: INTO l_prop_count
6684: FROM CZ_PSNODE_PROPVAL_V
6685: WHERE ps_node_id IN (select ps_node_id
6686: from cz_ps_nodes
6687: where cz_ps_nodes.deleted_flag = '0')
6688: AND property_id = p_property_id

Line 10853: FROM cz_psnode_propval_v

10849: IF(v_tExprId(ii) = v_tExprParentId(i))THEN
10850:
10851: BEGIN
10852: SELECT NVL(property_value, property_num_value) INTO v_property_value
10853: FROM cz_psnode_propval_v
10854: WHERE ps_node_id = v_tExprPsNodeId(ii)
10855: AND property_id = v_tPropertyId(i);
10856: EXCEPTION
10857: WHEN NO_DATA_FOUND THEN