APPS.PON_AUCTION_INTERFACE_PKG dependencies on PON_PARTY_PREFERENCES

Line 860: FROM pon_party_preferences

856: v_debug_status := 'UOM_SELECT';
857: BEGIN
858: SELECT preference_value
859: INTO v_uom_code
860: FROM pon_party_preferences
861: WHERE preference_name = 'AMOUNT_BASED_UOM'
862: AND app_short_name = 'PON'
863: AND party_id = v_site_id;
864: EXCEPTION

Line 1184: from pon_party_preferences ppp,

1180: select nvl(ppp.preference_value,'GENERAL'),
1181: flv.meaning
1182: into v_default_attr_group,
1183: v_attr_group_name
1184: from pon_party_preferences ppp,
1185: fnd_lookup_values flv
1186: where ppp.app_short_name = 'PON' and
1187: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
1188: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and