DBA Data[Home] [Help]

APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on FND_LOOKUP_VALUES

Line 737: from fnd_lookup_values attrGrpFlv

733:
734: update pon_auc_attributes_interface paai
735: set paai.GROUP_CODE = (
736: select lookup_code
737: from fnd_lookup_values attrGrpFlv
738: where lookup_type = l_group_lookup_type
739: --where lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'
740: and meaning = paai.GROUP_NAME
741: and attrGrpFlv.LANGUAGE = userenv('LANG')

Line 756: from fnd_lookup_values attrGrpFlv

752: -- For Header Case, if the Group Name is null, default General.
753: update pon_auc_attributes_interface paai
754: set paai.GROUP_NAME = (
755: select meaning
756: from fnd_lookup_values attrGrpFlv
757: where attrGrpFlv.lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'
758: and attrGrpFlv.lookup_code = 'GENERAL'
759: and attrGrpFlv.LANGUAGE = userenv('LANG')
760: and attrGrpFlv.view_application_id = 0