APPS.FFDICT dependencies on FF_DATABASE_ITEMS_TL

Line 786: INDEX(a FF_DATABASE_ITEMS_TL_N1)

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

Line 788: from ff_database_items_tl a,

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

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

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

Line 924: INDEX(a FF_DATABASE_ITEMS_TL_N1)

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

Line 926: from ff_database_items_tl a,

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