DBA Data[Home] [Help]

APPS.JTF_CAL_ITEMS_PVT dependencies on FND_LANGUAGES

Line 188: FROM FND_LANGUAGES l

184: , p_itm_rec.LAST_UPDATED_BY
185: , p_itm_rec.LAST_UPDATE_DATE
186: , p_itm_rec.LAST_UPDATE_LOGIN
187: , p_itm_rec.APPLICATION_ID
188: FROM FND_LANGUAGES l
189: WHERE l.INSTALLED_FLAG IN ('I','B')
190: AND NOT EXISTS ( SELECT NULL
191: FROM JTF_CAL_ITEMS_TL t
192: WHERE t.CAL_ITEM_ID = l_cal_item_id

Line 882: , FND_LANGUAGES L

878: , L.LANGUAGE_CODE
879: , B.SOURCE_LANG
880: , B.APPLICATION_ID
881: FROM JTF_CAL_ITEMS_TL B
882: , FND_LANGUAGES L
883: WHERE L.INSTALLED_FLAG IN ('I', 'B')
884: AND B.LANGUAGE = USERENV('LANG')
885: AND NOT EXISTS (SELECT NULL
886: FROM JTF_CAL_ITEMS_TL T

Line 1064: FROM FND_LANGUAGES l

1060: , p_itm_rec.item_description
1061: , l.LANGUAGE_CODE
1062: , userenv('LANG')
1063: , p_itm_rec.application_id
1064: FROM FND_LANGUAGES l
1065: WHERE l.INSTALLED_FLAG IN ('I', 'B')
1066: AND NOT EXISTS( SELECT NULL
1067: FROM JTF_CAL_ITEMS_TL t
1068: WHERE t.CAL_ITEM_ID = p_cal_item_id