APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_PARTY_PREFERENCES

Line 1209: FROM pon_party_preferences

1205: v_debug_status := 'UOM_SELECT';
1206: BEGIN
1207: SELECT preference_value
1208: INTO v_uom_code
1209: FROM pon_party_preferences
1210: WHERE preference_name = 'AMOUNT_BASED_UOM'
1211: AND app_short_name = 'PON'
1212: AND party_id = v_site_id;
1213: EXCEPTION

Line 3085: from pon_party_preferences ppp,

3081: select nvl(ppp.preference_value,'GENERAL'),
3082: flv.meaning
3083: into v_default_attr_group,
3084: v_attr_group_name
3085: from pon_party_preferences ppp,
3086: fnd_lookup_values flv
3087: where ppp.app_short_name = 'PON' and
3088: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
3089: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and