APPS.PV_MATCH_V3_PUB dependencies on PV_ATTRIBUTE_CODES_VL

Line 2157: pv_attribute_codes_vl pvac, hz_relationships hzr ,

2153: then 'A'
2154: else 'I'
2155: end ) active_flag
2156: from hz_parties hzp , pv_partner_profiles pvpp ,
2157: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2158: hz_organization_profiles HZOP,
2159: (SELECT rownum idx, column_value
2160: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2161: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))

Line 2184: pv_attribute_codes_vl pvac,

2180: pvac.description,
2181: pvpp.status active_flag
2182: from hz_parties hzp,
2183: pv_partner_profiles pvpp,
2184: pv_attribute_codes_vl pvac,
2185: (SELECT rownum idx, column_value
2186: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2187: where pvpp.partner_id = x_partner.column_value
2188: and pvpp.partner_party_id = hzp.party_id

Line 3151: FROM pv_attribute_codes_vl pac,

3147: RETURN VARCHAR2
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

Line 3443: FROM pv_attribute_codes_vl pac,

3439: RETURN VARCHAR2
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