APPS.EGO_RULE_SETS_PKG dependencies on FND_LANGUAGES

Line 464: from FND_LANGUAGES L

460: X_CREATED_BY,
461: X_LAST_UPDATE_LOGIN,
462: L.LANGUAGE_CODE,
463: userenv('LANG')
464: from FND_LANGUAGES L
465: where L.INSTALLED_FLAG in ('I', 'B')
466: and not exists
467: (select NULL
468: from EGO_RULE_SETS_TL T

Line 597: from FND_LANGUAGES L

593: X_CREATED_BY,
594: X_LAST_UPDATE_LOGIN,
595: L.LANGUAGE_CODE,
596: userenv('LANG')
597: from FND_LANGUAGES L
598: where L.INSTALLED_FLAG in ('I', 'B')
599: and not exists
600: (select NULL
601: from EGO_RULE_SETS_TL T

Line 811: from EGO_RULE_SETS_TL B, FND_LANGUAGES L

807: B.CREATED_BY,
808: B.LAST_UPDATE_LOGIN,
809: L.LANGUAGE_CODE,
810: B.SOURCE_LANG
811: from EGO_RULE_SETS_TL B, FND_LANGUAGES L
812: where L.INSTALLED_FLAG in ('I', 'B')
813: and B.LANGUAGE = userenv('LANG')
814: and not exists
815: (select NULL

Line 962: FROM ego_mtl_sy_items_ext_b ext, FND_LANGUAGES L

958: INSERT INTO ego_mtl_sy_items_ext_tl(extension_id, organization_id, inventory_item_id, item_catalog_group_id, attr_group_id, data_level_id, source_lang, language, created_by, creation_date,
959: last_updated_by, last_update_date, revision_id, pk1_value, pk2_value)
960: SELECT EXT.EXTENSION_ID, EXT.ORGANIZATION_ID, EXT.INVENTORY_ITEM_ID, EXT.ITEM_CATALOG_GROUP_ID, EXT.ATTR_GROUP_ID, ext.data_level_id, USERENV('LANG'), L.LANGUAGE_CODE, ext.created_by,
961: ext.creation_date, ext.last_updated_by, ext.last_update_date, ext.revision_id, ext.pk1_value, ext.pk2_value
962: FROM ego_mtl_sy_items_ext_b ext, FND_LANGUAGES L
963: WHERE ext.EXTENSION_ID = l_ext_id AND l.INSTALLED_FLAG IN ('I', 'B');
964: commit;
965: END IF;
966: END loop;