DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on ICX_CAT_AGREEMENT_ATTRS_V

Line 4436: from icx_cat_agreement_attrs_v

4432: WHERE paa.auction_header_id = p_auction_header_id and
4433: paa.attr_level = 'LINE' and
4434: paa.ip_category_id is not null and
4435: not exists (select null
4436: from icx_cat_agreement_attrs_v
4437: where rt_category_id = paa.ip_category_id and
4438: attribute_id = paa.ip_descriptor_id and
4439: language = userenv('LANG'));
4440:

Line 4444: from icx_cat_agreement_attrs_v

4440:
4441:
4442: UPDATE pon_auction_attributes paa
4443: SET attribute_name = (select attribute_name
4444: from icx_cat_agreement_attrs_v
4445: where rt_category_id = paa.ip_category_id and
4446: attribute_id = paa.ip_descriptor_id and
4447: language = userenv('LANG'))
4448: WHERE paa.auction_header_id = p_auction_header_id and