DBA Data[Home] [Help]

APPS.PV_PARTNER_PGM_TYPE_PKG dependencies on FND_LANGUAGES

Line 106: FROM FND_LANGUAGES l

102: ,l.language_code
103: ,USERENV('LANG')
104: ,DECODE( p_program_type_name, NULL, p_program_type_name, FND_API.g_miss_char, NULL, p_program_type_name)
105: ,DECODE( p_program_type_description, NULL, p_program_type_description, FND_API.g_miss_char, NULL, p_program_type_description)
106: FROM FND_LANGUAGES l
107: WHERE l.installed_flag IN ('I','B')
108: AND NOT EXISTS(
109: SELECT NULL
110: FROM PV_PARTNER_PROGRAM_TYPE_TL t

Line 372: FND_LANGUAGES L

368: ,B.PROGRAM_TYPE_NAME
369: ,B.PROGRAM_TYPE_DESCRIPTION
370:
371: FROM PV_PARTNER_PROGRAM_TYPE_TL B ,
372: FND_LANGUAGES L
373: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
374: AND B.LANGUAGE = USERENV ( 'LANG' )
375: ) v, PV_PARTNER_PROGRAM_TYPE_TL t
376: WHERE t.PROGRAM_TYPE_ID(+) = v.PROGRAM_TYPE_ID