APPS.CZ_LOGIC_GEN dependencies on CZ_ITEM_MASTERS

Line 779: p_item_id IN cz_item_masters.item_id%TYPE,

775: sUnsatisfiedId VARCHAR2(4000);
776: ---------------------------------------------------------------------------------------
777: FUNCTION GET_PROPERTY_VALUE(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
778: p_property_id IN cz_properties.property_id%TYPE,
779: p_item_id IN cz_item_masters.item_id%TYPE,
780: x_data_type IN OUT NOCOPY cz_properties.data_type%TYPE)
781: RETURN VARCHAR2 IS
782: l_def_value cz_properties.def_value%TYPE;
783: l_tab tStringArray;

Line 808: FROM cz_item_type_properties t, cz_item_masters m

804:
805: IF(l_tab.COUNT = 0)THEN
806:
807: SELECT NULL BULK COLLECT INTO l_tab
808: FROM cz_item_type_properties t, cz_item_masters m
809: WHERE m.item_id = p_item_id
810: AND m.deleted_flag = FLAG_NOT_DELETED
811: AND t.deleted_flag = FLAG_NOT_DELETED
812: AND t.property_id = p_property_id