APPS.HR_DELETE dependencies on FF_FORMULAS_F

Line 382: FROM ff_formulas_f ff

378: --
379: hr_utility.set_location('hr_delete.delete_mag_structure',1);
380: DELETE FROM pay_magnetic_records mr
381: WHERE EXISTS ( SELECT ''
382: FROM ff_formulas_f ff
383: WHERE ff.formula_id = mr.formula_id
384: AND ff.business_group_id = p_business_group_id);
385: --
386: --

Line 451: (c_business_group_id ff_formulas_f.business_group_id%TYPE)

447: --
448: l_proc varchar2(80) := g_package||'delete_formula_direct';
449: --
450: cursor csr_get_bg_formulas
451: (c_business_group_id ff_formulas_f.business_group_id%TYPE)
452: is
453: SELECT distinct formula_id
454: FROM ff_formulas_f
455: WHERE business_group_id = c_business_group_id;

Line 454: FROM ff_formulas_f

450: cursor csr_get_bg_formulas
451: (c_business_group_id ff_formulas_f.business_group_id%TYPE)
452: is
453: SELECT distinct formula_id
454: FROM ff_formulas_f
455: WHERE business_group_id = c_business_group_id;
456: --
457: begin
458: hr_utility.set_location('Entering: '||l_proc,10);

Line 472: DELETE FROM ff_formulas_f ff

468: DELETE FROM ff_fdi_usages_f fdi
469: WHERE fdi.formula_id = form.formula_id;
470: hr_utility.set_location(l_proc,30);
471: --
472: DELETE FROM ff_formulas_f ff
473: WHERE ff.formula_id = form.formula_id;
474: hr_utility.set_location(l_proc,40);
475: --
476: end loop;

Line 1578: (c_business_group_id ff_formulas_f.business_group_id%TYPE)

1574: --
1575: l_exists varchar2(1);
1576: --
1577: cursor csr_get_spec_inf_type
1578: (c_business_group_id ff_formulas_f.business_group_id%TYPE)
1579: is
1580: SELECT null
1581: FROM per_special_info_types sit
1582: WHERE business_group_id = c_business_group_id;