APPS.PV_CHECK_MATCH_PUB dependencies on PV_ATTRIBUTES_VL

Line 611: pv_attributes_vl q2

607: -- -----------------------------------------------------------------
608: CURSOR lc_sql_cursor IS
609: SELECT q1.sql_text, q2.return_type, q2.attribute_type
610: FROM pv_entity_attrs q1,
611: pv_attributes_vl q2
612: WHERE q1.sql_text IS NOT NULL AND
613: q1.entity = UPPER(p_entity) AND
614: q1.attribute_id = q2.attribute_id AND
615: q1.enabled_flag = 'Y' AND

Line 640: -- the return_type from pv_attributes_vl.

636: -------------------------- Source code --------------------
637:
638: -- --------------------------------------------------------------------------
639: -- If the attribute entry exists, but the return_type is NULL, retrieve
640: -- the return_type from pv_attributes_vl.
641: -- --------------------------------------------------------------------------
642: IF (x_entity_attr_value.EXISTS(p_attribute_id)) THEN
643: IF (x_entity_attr_value(p_attribute_id).return_type IS NULL) THEN
644: SELECT return_type

Line 646: FROM pv_attributes_vl

642: IF (x_entity_attr_value.EXISTS(p_attribute_id)) THEN
643: IF (x_entity_attr_value(p_attribute_id).return_type IS NULL) THEN
644: SELECT return_type
645: INTO x_entity_attr_value(p_attribute_id).return_type
646: FROM pv_attributes_vl
647: WHERE attribute_id = p_attribute_id;
648: END IF;
649:
650: -- --------------------------------------------------------------------------