APPS.HR_LEGISLATION dependencies on FF_DATABASE_ITEMS

Line 3061: ff_database_items di

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
3062: where fdi.item_name = di.user_name
3063: and ue.creator_type = 'B'
3064: and ue.creator_id = db.defined_balance_id
3065: and bd.balance_dimension_id = db.balance_dimension_id

Line 3076: ff_database_items di

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
3077: where fdi.item_name = di.user_name
3078: and ue.creator_type = 'B'
3079: and ue.creator_id = db.defined_balance_id
3080: and bd.balance_dimension_id = db.balance_dimension_id

Line 3359: ff_database_items dbi

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
3361: and exists (select null from
3362: ff_user_entities ent
3363: where ent.user_entity_id = dbi.user_entity_id

Line 3370: ff_database_items dbi

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
3372: and exists (select null from
3373: ff_user_entities ent
3374: where ent.user_entity_id = dbi.user_entity_id