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(+)
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(+)