APPS.PA_CREATE_RESOURCE dependencies on FND_LANGUAGES

Line 831: from FND_LANGUAGES L

827: p_resource_list_name,
828: NVL(p_description,p_resource_list_name),
829: L.LANGUAGE_CODE,
830: userenv('LANG')
831: from FND_LANGUAGES L
832: where L.INSTALLED_FLAG in ('I', 'B')
833: and not exists
834: (select NULL
835: from pa_resource_lists_tl T

Line 3442: FROM FND_LANGUAGES L

3438: eachRL.name,
3439: NVL(eachRL.description,eachRL.name),
3440: L.LANGUAGE_CODE,
3441: userenv('LANG')
3442: FROM FND_LANGUAGES L
3443: WHERE L.INSTALLED_FLAG in ('I', 'B')
3444: and not exists
3445: (select NULL
3446: from pa_resource_lists_tl T

Line 3714: from pa_resource_lists_tl B, FND_LANGUAGES L

3710: B.NAME,
3711: B.DESCRIPTION,
3712: L.LANGUAGE_CODE,
3713: B.SOURCE_LANG
3714: from pa_resource_lists_tl B, FND_LANGUAGES L
3715: where L.INSTALLED_FLAG in ('I', 'B')
3716: and B.LANGUAGE = userenv('LANG')
3717: and not exists
3718: (select NULL

Line 4281: FROM FND_LANGUAGES L

4277: p_name,
4278: NVL(p_description,p_name),
4279: L.LANGUAGE_CODE,
4280: userenv('LANG')
4281: FROM FND_LANGUAGES L
4282: WHERE L.INSTALLED_FLAG in ('I', 'B')
4283: and not exists
4284: (select NULL
4285: from pa_resource_lists_tl T

Line 5063: from FND_LANGUAGES L

5059: P_NAME,
5060: NVL(P_DESCRIPTION,P_NAME),
5061: L.LANGUAGE_CODE,
5062: userenv('LANG')
5063: from FND_LANGUAGES L
5064: where L.INSTALLED_FLAG in ('I', 'B')
5065: and not exists
5066: (select NULL
5067: from pa_resource_lists_tl T