DBA Data[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on FND_LOOKUP_VALUES

Line 2565: v_attr_group_name fnd_lookup_values.meaning%TYPE;

2561: p_to_line_number IN NUMBER) IS
2562: v_ip_attr_default_option VARCHAR2(10);
2563: v_default_attr_group pon_auction_attributes.attr_group%TYPE;
2564: v_max_seq_number NUMBER;
2565: v_attr_group_name fnd_lookup_values.meaning%TYPE;
2566:
2567: CURSOR lines IS
2568: SELECT interface_line_number
2569: FROM pon_auc_items_interface

Line 2587: fnd_lookup_values flv

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
2591: flv.lookup_type = 'PON_LINE_ATTRIBUTE_GROUPS' and