APPS.JG_ZZ_VAT_REGISTERS_PKG dependencies on FND_LANGUAGES

Line 81: from fnd_languages fndlang

77: , x_record.creation_date
78: , x_record.last_updated_by
79: , x_record.last_update_date
80: , x_record.last_update_login
81: from fnd_languages fndlang
82: where fndlang.installed_flag in ('I','B')
83: and not exists (select 1
84: from jg_zz_vat_registers_tl jzvrgtl
85: where jzvrgtl.vat_register_id = x_vat_register_id

Line 103: lv_usr_env_lang fnd_languages.language_code%type;

99: is
100:
101: lr_locked_b_row jg_zz_vat_registers_b%rowtype;
102: lr_locked_tl_row jg_zz_vat_registers_tl%rowtype;
103: lv_usr_env_lang fnd_languages.language_code%type;
104:
105: cursor c_locked_b_row
106: is
107: select *

Line 169: lv_usr_env_lang fnd_languages.language_code%type;

165:
166: procedure update_row (x_record jg_zz_vat_registers_vl%rowtype)
167: is
168:
169: lv_usr_env_lang fnd_languages.language_code%type;
170:
171: begin
172:
173: lv_usr_env_lang := userenv('LANG');

Line 262: from jg_zz_vat_registers_tl b, fnd_languages l

258: B.CREATED_BY,
259: B.LAST_UPDATE_LOGIN,
260: L.LANGUAGE_CODE,
261: B.SOURCE_LANG
262: from jg_zz_vat_registers_tl b, fnd_languages l
263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL