DBA Data[Home] [Help]

APPS.JTF_BRMRULE_PVT dependencies on FND_LANGUAGES

Line 196: FROM FND_LANGUAGES l

192: , p_br_rec.LAST_UPDATE_LOGIN
193: , l.LANGUAGE_CODE
194: , userenv('LANG')
195: , p_br_rec.APPLICATION_ID
196: FROM FND_LANGUAGES l
197: WHERE l.INSTALLED_FLAG IN ('I','B')
198: AND NOT EXISTS ( SELECT NULL
199: FROM JTF_BRM_RULES_TL t
200: WHERE t.RULE_ID = l_rule_id

Line 679: FROM JTF_BRM_RULES_TL B, FND_LANGUAGES L

675: , B.RULE_DESCRIPTION
676: , L.LANGUAGE_CODE
677: , B.SOURCE_LANG
678: , B.APPLICATION_ID
679: FROM JTF_BRM_RULES_TL B, FND_LANGUAGES L
680: WHERE L.INSTALLED_FLAG IN ('I', 'B')
681: AND B.LANGUAGE = USERENV('LANG')
682: AND NOT EXISTS (SELECT NULL
683: FROM JTF_BRM_RULES_TL T

Line 909: FROM FND_LANGUAGES l

905: , p_br_rec.rule_description
906: , l.LANGUAGE_CODE
907: , userenv('LANG')
908: , p_br_rec.application_id
909: FROM FND_LANGUAGES l
910: WHERE l.INSTALLED_FLAG IN ('I', 'B')
911: AND NOT EXISTS( SELECT NULL
912: FROM JTF_BRM_RULES_TL t
913: WHERE t.RULE_ID = p_rule_id