DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on ICX_CAT_AGREEMENT_ATTRS_V

Line 5483: from icx_cat_agreement_attrs_v

5479: WHERE paa.auction_header_id = p_auction_header_id and
5480: paa.attr_level = 'LINE' and
5481: paa.ip_category_id is not null and
5482: not exists (select null
5483: from icx_cat_agreement_attrs_v
5484: where rt_category_id = paa.ip_category_id and
5485: attribute_id = paa.ip_descriptor_id and
5486: language = userenv('LANG'));
5487:

Line 5491: from icx_cat_agreement_attrs_v

5487:
5488:
5489: UPDATE pon_auction_attributes paa
5490: SET attribute_name = (select attribute_name
5491: from icx_cat_agreement_attrs_v
5492: where rt_category_id = paa.ip_category_id and
5493: attribute_id = paa.ip_descriptor_id and
5494: language = userenv('LANG'))
5495: WHERE paa.auction_header_id = p_auction_header_id and