APPS.PV_PG_INVITE_HEADERS_PKG dependencies on FND_LANGUAGES

Line 122: FROM fnd_languages l

118: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
119: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: USERENV('LANG'),
121: DECODE( p_EMAIL_CONTENT , FND_API.G_MISS_CHAR, NULL, p_EMAIL_CONTENT)
122: FROM fnd_languages l
123: WHERE l.installed_flag IN ('I','B')
124: AND NOT EXISTS(SELECT NULL FROM pv_pg_invite_headers_tl t
125: WHERE t.invite_header_id = DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id)
126: AND t.language = l.language_code);

Line 307: FND_LANGUAGES L

303: b.email_content,
304: l.language_code,
305: b.source_lang
306: FROM pv_pg_invite_headers_tl B ,
307: FND_LANGUAGES L
308: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
309: AND B.LANGUAGE = USERENV ( 'LANG' )
310: ) v, pv_pg_invite_headers_tl t
311: WHERE t.INVITE_HEADER_ID(+) = v.INVITE_HEADER_ID