APPS.HR_LEGISLATION dependencies on FF_FDI_USAGES_F

Line 3057: from ff_fdi_usages_f fdi,

3053:
3054: delete ff_compiled_info_f
3055: where formula_id in (
3056: select fdi.formula_id
3057: from ff_fdi_usages_f fdi,
3058: ff_user_entities ue,
3059: pay_defined_balances db,
3060: pay_balance_dimensions bd,
3061: ff_database_items di

Line 3069: delete from ff_fdi_usages_f fdi2

3065: and bd.balance_dimension_id = db.balance_dimension_id
3066: and bd.balance_dimension_id = stu_rec.c_surrogate_key
3067: and di.user_entity_id = ue.user_entity_id);
3068:
3069: delete from ff_fdi_usages_f fdi2
3070: where fdi2.formula_id in
3071: (select fdi.formula_id
3072: from ff_fdi_usages_f fdi,
3073: ff_user_entities ue,

Line 3072: from ff_fdi_usages_f fdi,

3068:
3069: delete from ff_fdi_usages_f fdi2
3070: where fdi2.formula_id in
3071: (select fdi.formula_id
3072: from ff_fdi_usages_f fdi,
3073: ff_user_entities ue,
3074: pay_defined_balances db,
3075: pay_balance_dimensions bd,
3076: ff_database_items di

Line 3356: from ff_fdi_usages_f fdi

3352:
3353: delete ff_compiled_info_f fci
3354: where fci.formula_id in (
3355: select fdi.formula_id
3356: from ff_fdi_usages_f fdi
3357: where FDI.usage = 'D'
3358: and exists (select null from
3359: ff_database_items dbi
3360: where fdi.item_name = dbi.user_name

Line 3367: delete ff_fdi_usages_f fdi

3363: where ent.user_entity_id = dbi.user_entity_id
3364: and ent.creator_type in ('B', 'RB')
3365: and ent.route_id = stu_rec.route_id)));
3366:
3367: delete ff_fdi_usages_f fdi
3368: where FDI.usage = 'D'
3369: and exists (select null from
3370: ff_database_items dbi
3371: where fdi.item_name = dbi.user_name