APPS.CZ_IMP_SINGLE dependencies on FND_LANGUAGES

Line 2557: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang

2553: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2554: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID)
2555: SELECT
2556: LOCALIZED_STR, LANG.LANGUAGE_CODE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID
2557: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang
2558: WHERE intl.run_id=p_run_id AND intl.orig_sys_ref=l_localtext_orig_sys_ref_tbl(i) AND installed_flag in( 'B', 'I')
2559: AND LANGUAGE_CODE<>SOURCE_LANG
2560: AND EXISTS
2561: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang

Line 2561: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang

2557: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang
2558: WHERE intl.run_id=p_run_id AND intl.orig_sys_ref=l_localtext_orig_sys_ref_tbl(i) AND installed_flag in( 'B', 'I')
2559: AND LANGUAGE_CODE<>SOURCE_LANG
2560: AND EXISTS
2561: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang
2562: WHERE loc.run_id=p_run_id AND orig_sys_ref = intl.orig_sys_ref
2563: AND lang.language_code <> loc.language
2564: );
2565: COMMIT;