APPS.CZ_LOGIC_GEN dependencies on CZ_ITEM_MASTERS

Line 790: p_item_id IN cz_item_masters.item_id%TYPE,

786: sUnsatisfiedId VARCHAR2(4000);
787: ---------------------------------------------------------------------------------------
788: FUNCTION GET_PROPERTY_VALUE(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
789: p_property_id IN cz_properties.property_id%TYPE,
790: p_item_id IN cz_item_masters.item_id%TYPE,
791: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
792: RETURN VARCHAR2 IS
793: l_def_value cz_properties.def_value%TYPE;
794: l_tab tStringArray;

Line 819: FROM cz_item_type_properties t, cz_item_masters m

815:
816: IF(l_tab.COUNT = 0)THEN
817:
818: SELECT NULL BULK COLLECT INTO l_tab
819: FROM cz_item_type_properties t, cz_item_masters m
820: WHERE m.item_id = p_item_id
821: AND m.deleted_flag = FLAG_NOT_DELETED
822: AND t.deleted_flag = FLAG_NOT_DELETED
823: AND t.property_id = p_property_id