APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on FND_LOOKUPS

Line 3773: from fnd_lookups

3769: p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE <> FND_API.G_MISS_CHAR ) THEN
3770: BEGIN
3771: SELECT 'X' INTO l_Temp
3772: FROM ( select DISTINCT lookup_code LOOKUP_CODE
3773: from fnd_lookups
3774: where lookup_type IN ( select rsc_access_lkup
3775: from jtf_sources_all)
3776: )
3777: WHERE LOOKUP_CODE = p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE;

Line 3782: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_LOOKUPS');

3778: EXCEPTION
3779: WHEN NO_DATA_FOUND THEN
3780: -- Invalid TRANS_ACCESS_CODE specified
3781: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3782: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_LOOKUPS');
3783: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TRANS_ACCESS_CODE');
3784: FND_MSG_PUB.ADD;
3785: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3786: END;