DBA Data[Home] [Help]

APPS.AHL_RA_SETUPS_PVT dependencies on FND_LOOKUPS

Line 145: FROM FND_LOOKUPS

141: ELSIF l_setup_data_rec.SETUP_CODE = 'REMOVAL_CODE' THEN
142: BEGIN
143: SELECT MEANING
144: INTO l_code
145: FROM FND_LOOKUPS
146: WHERE LOOKUP_TYPE = 'AHL_REMOVAL_CODE'
147: AND LOOKUP_CODE = l_setup_data_rec.REMOVAL_CODE;
148:
149: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_REMOVAL_CODE');

Line 208: FROM FND_LOOKUPS

204: SELECT 'X'
205: INTO l_dummy
206: FROM DUAL
207: WHERE EXISTS (SELECT 1
208: FROM FND_LOOKUPS
209: WHERE LOOKUP_TYPE = 'AHL_REMOVAL_CODE'
210: AND LOOKUP_CODE = l_setup_data_rec.REMOVAL_CODE);
211:
212: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN