APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_PARTY_PREFERENCES

Line 960: FROM pon_party_preferences

956: v_debug_status := 'UOM_SELECT';
957: BEGIN
958: SELECT preference_value
959: INTO v_uom_code
960: FROM pon_party_preferences
961: WHERE preference_name = 'AMOUNT_BASED_UOM'
962: AND app_short_name = 'PON'
963: AND party_id = v_site_id;
964: EXCEPTION

Line 2586: from pon_party_preferences ppp,

2582: select nvl(ppp.preference_value,'GENERAL'),
2583: flv.meaning
2584: into v_default_attr_group,
2585: v_attr_group_name
2586: from pon_party_preferences ppp,
2587: fnd_lookup_values flv
2588: where ppp.app_short_name = 'PON' and
2589: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
2590: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and