DBA Data[Home] [Help]

APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_PARTY_PREFERENCES

Line 724: from pon_party_preferences ppp

720: -- Not to be Done for Header Section.
721: IF ( not p_attr_type_header ) THEN
722: update pon_auc_attributes_interface paai
723: set paai.GROUP_CODE = (select nvl(ppp.preference_value,'GENERAL')
724: from pon_party_preferences ppp
725: where ppp.app_short_name = 'PON'
726: and ppp.preference_name = l_group_pref_name
727: and ppp.party_id = p_party_id)
728: where paai.batch_id = p_batch_id

Line 1515: from pon_party_preferences ppp

1511: where auction_header_id = p_auction_header_id;
1512:
1513: select nvl(ppp.preference_value,'GENERAL')
1514: into l_default_attr_group
1515: from pon_party_preferences ppp
1516: where ppp.app_short_name = 'PON' and
1517: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
1518: ppp.party_id = l_tp_id;
1519:

Line 2069: from pon_party_preferences ppp

2065: -- Not to be Done for Header Section.
2066: IF ( not p_attr_type_header ) THEN
2067: update pon_auc_attributes_interface paai
2068: set paai.GROUP_CODE = (select nvl(ppp.preference_value,'GENERAL')
2069: from pon_party_preferences ppp
2070: where ppp.app_short_name = 'PON'
2071: and ppp.preference_name = l_group_pref_name
2072: and ppp.party_id = p_party_id)
2073: where paai.batch_id = p_batch_id