DBA Data[Home] [Help]

APPS.CS_CIC_ATTRIBUTE_PUB dependencies on FND_LOOKUP_VALUES

Line 329: FROM Fnd_Lookup_values

325: l_values_exist CHAR(1) :='N';
326: BEGIN
327: SELECT Description
328: INTO l_new_constant
329: FROM Fnd_Lookup_values
330: WHERE Lookup_Code = 'CUG_SR_AUTONOTE_NEW'
331: AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
332: AND language = userenv('LANG');
333: l_create_attribute_note := l_new_constant || fnd_global.newline();

Line 541: FROM Fnd_Lookup_values

537: IF l_values_exist ='Y' THEN
538: -- End fix for 12.2.2 CIC changes
539: SELECT Description
540: INTO l_old_values
541: FROM Fnd_Lookup_values
542: WHERE Lookup_Code = 'CUG_SR_AUTONOTE_OLD'
543: AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
544: AND language = userenv('LANG');
545:

Line 548: FROM Fnd_Lookup_values

544: AND language = userenv('LANG');
545:
546: SELECT Description
547: INTO l_new_values
548: FROM Fnd_Lookup_values
549: WHERE Lookup_Code = 'CUG_SR_AUTONOTE_NEW'
550: AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
551: AND language = userenv('LANG');
552: