DBA Data[Home] [Help]

APPS.FF_GLOBALS_F_PKG dependencies on FF_USER_ENTITIES

Line 657: ff_user_entities ffue

653: select distinct ffu.formula_id
654: from ff_fdi_usages_f ffu
655: where ffu.item_name in (select fdbi.user_name
656: from ff_database_items fdbi,
657: ff_user_entities ffue
658: where fdbi.user_entity_id = ffue.user_entity_id
659: and ffue.creator_id = r_global_id
660: and ffue.creator_type = 'S');
661:

Line 667: from ff_user_entities

663: cursor csr_user_entity_id(r_base_global_name varchar2,
664: r_legislation_code varchar2,
665: r_global_id number ) is
666: select user_entity_id
667: from ff_user_entities
668: where creator_id = p_global_id
669: and creator_type = 'S'
670: and user_entity_name = r_base_global_name||'_GLOBAL_UE'
671: and legislation_code = r_legislation_code;

Line 693: delete ff_user_entities

689:
690: delete ff_database_items_tl
691: where user_entity_id = i.user_entity_id;
692:
693: delete ff_user_entities
694: where user_entity_id=i.user_entity_id;
695:
696: end loop;
697: