APPS.HR_LEGISLATION dependencies on FF_DATABASE_ITEMS

Line 3307: ff_database_items di

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
3308: where fdi.item_name = di.user_name
3309: and ue.creator_type = 'B'
3310: and ue.creator_id = db.defined_balance_id
3311: and bd.balance_dimension_id = db.balance_dimension_id

Line 3322: ff_database_items di

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
3323: where fdi.item_name = di.user_name
3324: and ue.creator_type = 'B'
3325: and ue.creator_id = db.defined_balance_id
3326: and bd.balance_dimension_id = db.balance_dimension_id

Line 3605: ff_database_items dbi

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
3607: and exists (select null from
3608: ff_user_entities ent
3609: where ent.user_entity_id = dbi.user_entity_id

Line 3616: ff_database_items dbi

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
3618: and exists (select null from
3619: ff_user_entities ent
3620: where ent.user_entity_id = dbi.user_entity_id