APPS.CZ_IMP_SINGLE dependencies on FND_LANGUAGES

Line 2627: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang

2623: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2624: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID)
2625: SELECT
2626: LOCALIZED_STR, LANG.LANGUAGE_CODE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID
2627: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang
2628: 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')
2629: AND LANGUAGE_CODE<>SOURCE_LANG
2630: AND EXISTS
2631: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang

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

2627: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang
2628: 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')
2629: AND LANGUAGE_CODE<>SOURCE_LANG
2630: AND EXISTS
2631: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang
2632: WHERE loc.run_id=p_run_id AND orig_sys_ref = intl.orig_sys_ref
2633: AND lang.language_code <> loc.language
2634: );
2635: COMMIT;