APPS.CZ_UI_GENERATOR dependencies on CZ_ITEM_MASTERS

Line 7521: p_item_id IN cz_item_masters.item_id%TYPE)

7517: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
7518:
7519: FUNCTION get_Property_Value(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
7520: p_property_id IN cz_properties.property_id%TYPE,
7521: p_item_id IN cz_item_masters.item_id%TYPE)
7522: RETURN VARCHAR2 IS
7523: TYPE tStringArray IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
7524: v_def_value cz_properties.def_value%TYPE;
7525: v_tab tStringArray;

Line 7549: FROM cz_item_type_properties t, cz_item_masters m

7545:
7546: IF(v_tab.COUNT = 0)THEN
7547:
7548: SELECT NULL BULK COLLECT INTO v_tab
7549: FROM cz_item_type_properties t, cz_item_masters m
7550: WHERE m.item_id = p_item_id
7551: AND m.deleted_flag = '0'
7552: AND t.deleted_flag = '0'
7553: AND t.property_id = p_property_id