APPS.HRDYNDBI dependencies on FF_FORMULAS_F

Line 2794: from ff_formulas_f f

2790: for form in get_formula_ids loop
2791:
2792: select count(*)
2793: into num
2794: from ff_formulas_f f
2795: where form.formula_id = f.formula_id
2796: and form.effective_start_date = f.effective_start_date
2797: and (nvl (f.legislation_code, ' ') = nvl (p_leg_code, nvl (f.legislation_code, ' '))
2798: or exists (select null from per_business_groups_perf b

Line 2852: from ff_formulas_f f

2848:
2849: delete ff_fdi_usages_f fdi
2850: where FDI.usage = 'D'
2851: and exists (select null
2852: from ff_formulas_f f
2853: where fdi.formula_id = f.formula_id
2854: and (nvl (f.legislation_code, ' ') = nvl (p_leg_code, nvl (f.legislation_code, ' '))
2855: or exists (select null from per_business_groups_perf b
2856: where f.business_group_id = b.business_group_id