APPS.FFDICT dependencies on FF_DATABASE_ITEMS_TL

Line 787: INDEX(a FF_DATABASE_ITEMS_TL_N1)

783: exception
784: when no_data_found then
785: select null into dummy from dual where exists
786: (select /*+ ORDERED
787: INDEX(a FF_DATABASE_ITEMS_TL_N1)
788: INDEX(b FF_USER_ENTITIES_PK) */ null
789: from ff_database_items_tl a,
790: ff_user_entities b
791: where a.user_entity_id = b.user_entity_id

Line 789: from ff_database_items_tl a,

785: select null into dummy from dual where exists
786: (select /*+ ORDERED
787: INDEX(a FF_DATABASE_ITEMS_TL_N1)
788: INDEX(b FF_USER_ENTITIES_PK) */ null
789: from ff_database_items_tl a,
790: ff_user_entities b
791: where a.user_entity_id = b.user_entity_id
792: and a.translated_user_name = p_item_name
793: and

Line 921: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.

917: hr_utility.set_location('ffdict.tl_dbi_will_clash',3);
918: end if;
919:
920: --
921: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.
922: --
923: select null into dummy from dual where exists
924: (select /*+ ORDERED
925: INDEX(a FF_DATABASE_ITEMS_TL_N1)

Line 925: INDEX(a FF_DATABASE_ITEMS_TL_N1)

921: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.
922: --
923: select null into dummy from dual where exists
924: (select /*+ ORDERED
925: INDEX(a FF_DATABASE_ITEMS_TL_N1)
926: INDEX(b FF_USER_ENTITIES_PK) */ null
927: from ff_database_items_tl a,
928: ff_user_entities b
929: where a.translated_user_name = p_tl_user_name

Line 927: from ff_database_items_tl a,

923: select null into dummy from dual where exists
924: (select /*+ ORDERED
925: INDEX(a FF_DATABASE_ITEMS_TL_N1)
926: INDEX(b FF_USER_ENTITIES_PK) */ null
927: from ff_database_items_tl a,
928: ff_user_entities b
929: where a.translated_user_name = p_tl_user_name
930: and (a.user_name <> p_user_name or a.user_entity_id <> p_user_entity_id)
931: and a.user_entity_id = b.user_entity_id