DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on PV_ENTY_ATTR_VALUES

Line 3152: pv_enty_attr_values peav

3148: as
3149: CURSOR lc_get_pt_type (pc_attribute_id NUMBER,pc_partner_id NUMBER) is
3150: SELECT pac.description
3151: FROM pv_attribute_codes_vl pac,
3152: pv_enty_attr_values peav
3153: WHERE peav.entity_id = pc_partner_id
3154: AND peav.entity(+) = 'PARTNER'
3155: AND peav.attribute_id(+) = pc_attribute_id
3156: AND peav.attribute_id = pac.attribute_id(+)

Line 3444: pv_enty_attr_values peav

3440: as
3441: CURSOR lc_get_pt_type (pc_partner_id NUMBER) is
3442: SELECT pac.description
3443: FROM pv_attribute_codes_vl pac,
3444: pv_enty_attr_values peav
3445: WHERE peav.entity_id = pc_partner_id
3446: AND peav.entity(+) = 'PARTNER'
3447: AND peav.attribute_id(+) = 3
3448: AND peav.attribute_id = pac.attribute_id(+)