DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PKG dependencies on FND_LANGUAGES

Line 262: FROM FND_LANGUAGES l

258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)
259: ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)
260: ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)
261: ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)
262: FROM FND_LANGUAGES l
263: WHERE l.installed_flag in ('I', 'B')
264: AND NOT EXISTS(
265: SELECT NULL
266: FROM PV_PARTNER_PROGRAM_TL t

Line 814: FROM PV_PARTNER_PROGRAM_TL B , FND_LANGUAGES L

810: ,L.LANGUAGE_CODE
811: ,B.SOURCE_LANG
812: ,B.PROGRAM_NAME
813: ,B.PROGRAM_DESCRIPTION
814: FROM PV_PARTNER_PROGRAM_TL B , FND_LANGUAGES L
815: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
816: ) v
817: , PV_PARTNER_PROGRAM_TL t
818: WHERE t.PROGRAM_ID(+) = v.PROGRAM_ID