APPS.HR_LEGISLATION dependencies on FF_FDI_USAGES_F

Line 3303: from ff_fdi_usages_f fdi,

3299:
3300: delete ff_compiled_info_f
3301: where formula_id in (
3302: select fdi.formula_id
3303: from ff_fdi_usages_f fdi,
3304: ff_user_entities ue,
3305: pay_defined_balances db,
3306: pay_balance_dimensions bd,
3307: ff_database_items di

Line 3315: delete from ff_fdi_usages_f fdi2

3311: and bd.balance_dimension_id = db.balance_dimension_id
3312: and bd.balance_dimension_id = stu_rec.c_surrogate_key
3313: and di.user_entity_id = ue.user_entity_id);
3314:
3315: delete from ff_fdi_usages_f fdi2
3316: where fdi2.formula_id in
3317: (select fdi.formula_id
3318: from ff_fdi_usages_f fdi,
3319: ff_user_entities ue,

Line 3318: from ff_fdi_usages_f fdi,

3314:
3315: delete from ff_fdi_usages_f fdi2
3316: where fdi2.formula_id in
3317: (select fdi.formula_id
3318: from ff_fdi_usages_f fdi,
3319: ff_user_entities ue,
3320: pay_defined_balances db,
3321: pay_balance_dimensions bd,
3322: ff_database_items di

Line 3602: from ff_fdi_usages_f fdi

3598:
3599: delete ff_compiled_info_f fci
3600: where fci.formula_id in (
3601: select fdi.formula_id
3602: from ff_fdi_usages_f fdi
3603: where FDI.usage = 'D'
3604: and exists (select null from
3605: ff_database_items dbi
3606: where fdi.item_name = dbi.user_name

Line 3613: delete ff_fdi_usages_f fdi

3609: where ent.user_entity_id = dbi.user_entity_id
3610: and ent.creator_type in ('B', 'RB')
3611: and ent.route_id = stu_rec.route_id)));
3612:
3613: delete ff_fdi_usages_f fdi
3614: where FDI.usage = 'D'
3615: and exists (select null from
3616: ff_database_items dbi
3617: where fdi.item_name = dbi.user_name