DBA Data[Home] [Help]

APPS.HRDYNDBI dependencies on FF_FORMULAS_F

Line 2791: from ff_formulas_f f

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

Line 2849: from ff_formulas_f f

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