APPS.PAY_SEED_UTL dependencies on FF_FDI_USAGES_F

Line 806: INDEX(A FF_FDI_USAGES_F_N50) */

802: CURSOR c_formula_id ( p_route_id number) is
803: select /*+ ORDERED
804: INDEX(C FF_USER_ENTITIES_FK1)
805: INDEX(B FF_DATABASE_ITEMS_FK1)
806: INDEX(A FF_FDI_USAGES_F_N50) */
807: distinct a.formula_id
808: from ff_user_entities c,
809: ff_database_items b,
810: ff_fdi_usages_f a

Line 810: ff_fdi_usages_f a

806: INDEX(A FF_FDI_USAGES_F_N50) */
807: distinct a.formula_id
808: from ff_user_entities c,
809: ff_database_items b,
810: ff_fdi_usages_f a
811: where a.item_name = b.user_name
812: and a.usage = 'D'
813: and b.user_entity_id = c.user_entity_id
814: and c.route_id = p_route_id;

Line 823: ff_fdi_usages_f fdi

819: -- dbitem can be global or legislation (not user) so checks are limitted to
820: -- seed database items. However user formulas can see core and owning legislation
821: -- code dbitems.
822: select distinct fdi.formula_id from
823: ff_fdi_usages_f fdi
824: ,ff_database_items dbi
825: ,ff_user_entities ue
826: ,ff_formulas_f f
827: where fdi.ITEM_NAME = p_user_name

Line 841: delete from ff_fdi_usages_f where formula_id = getrec.formula_id;

837:
838: BEGIN
839: IF p_route_id is not null then
840: for getrec in c_formula_id(p_route_id ) loop
841: delete from ff_fdi_usages_f where formula_id = getrec.formula_id;
842: delete from ff_compiled_info_f where formula_id = getrec.formula_id;
843: end loop;
844: END IF;
845:

Line 848: delete from ff_fdi_usages_f where formula_id = getrec.formula_id;

844: END IF;
845:
846: IF p_user_name is not null then
847: for getrec in c_formulas_using_dbi(p_user_name, p_legislation_code ) loop
848: delete from ff_fdi_usages_f where formula_id = getrec.formula_id;
849: delete from ff_compiled_info_f where formula_id = getrec.formula_id;
850: end loop;
851: END IF;
852:

Line 854: delete from ff_fdi_usages_f where formula_id = p_formula_id;

850: end loop;
851: END IF;
852:
853: IF p_formula_id is not null then
854: delete from ff_fdi_usages_f where formula_id = p_formula_id;
855: delete from ff_compiled_info_f where formula_id = p_formula_id;
856: END IF;
857:
858: END UNCOMPILE_FORMULAS;