APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on FND_LOOKUP_VALUES

Line 738: from fnd_lookup_values attrGrpFlv

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

Line 758: from fnd_lookup_values attrGrpFlv

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

Line 2083: from fnd_lookup_values attrGrpFlv

2079:
2080: update pon_auc_attributes_interface paai
2081: set paai.GROUP_CODE = (
2082: select lookup_code
2083: from fnd_lookup_values attrGrpFlv
2084: where lookup_type = l_group_lookup_type
2085: --where lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'
2086: and meaning = paai.GROUP_NAME
2087: and attrGrpFlv.LANGUAGE = userenv('LANG')

Line 2103: from fnd_lookup_values attrGrpFlv

2099: -- For Header Case, if the Group Name is null, default General.
2100: update pon_auc_attributes_interface paai
2101: set paai.GROUP_NAME = (
2102: select meaning
2103: from fnd_lookup_values attrGrpFlv
2104: where attrGrpFlv.lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'
2105: and attrGrpFlv.lookup_code = 'GENERAL'
2106: and attrGrpFlv.LANGUAGE = userenv('LANG')
2107: and attrGrpFlv.view_application_id = 0