APPS.HR_LEGISLATION dependencies on FF_USER_ENTITIES

Line 627: elsif l_table_name = 'FF_USER_ENTITIES' then

623: and p_effective_date between piv.effective_start_date and piv.effective_end_date
624: and replace(ltrim(rtrim(upper(piv.name))), ' ', '_') = replace(ltrim(rtrim(upper(P_SURROGATE_KEY_NAME))), ' ', '_')
625: and replace(ltrim(rtrim(upper(bt.BALANCE_NAME))), ' ', '_') = replace(ltrim(rtrim(upper(P_ADDL_SURROGATE_KEY_NAME1))), ' ', '_'));
626:
627: elsif l_table_name = 'FF_USER_ENTITIES' then
628:
629: Select 'Y' into v_exists from dual where exists(
630: select null
631: from FF_USER_ENTITIES fue

Line 631: from FF_USER_ENTITIES fue

627: elsif l_table_name = 'FF_USER_ENTITIES' then
628:
629: Select 'Y' into v_exists from dual where exists(
630: select null
631: from FF_USER_ENTITIES fue
632: where fue.business_group_id is null
633: and fue.legislation_code = p_legislation_code
634: and fue.created_by > 2
635: and fue.last_updated_by > 2

Line 3304: ff_user_entities ue,

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
3308: where fdi.item_name = di.user_name

Line 3319: ff_user_entities ue,

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
3323: where fdi.item_name = di.user_name

Line 3330: delete from ff_user_entities

3326: and bd.balance_dimension_id = db.balance_dimension_id
3327: and bd.balance_dimension_id = stu_rec.c_surrogate_key
3328: and di.user_entity_id = ue.user_entity_id);
3329:
3330: delete from ff_user_entities
3331: where creator_type = 'B'
3332: and creator_id in
3333: (select defined_balance_id
3334: from pay_defined_balances pdb

Line 3608: ff_user_entities ent

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
3610: and ent.creator_type in ('B', 'RB')
3611: and ent.route_id = stu_rec.route_id)));
3612:

Line 3619: ff_user_entities ent

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
3621: and ent.creator_type in ('B', 'RB')
3622: and ent.route_id = stu_rec.route_id));
3623:

Line 3624: delete from ff_user_entities ue

3620: where ent.user_entity_id = dbi.user_entity_id
3621: and ent.creator_type in ('B', 'RB')
3622: and ent.route_id = stu_rec.route_id));
3623:
3624: delete from ff_user_entities ue
3625: where creator_type in ('B', 'RB')
3626: and route_id = stu_rec.ROUTE_ID;
3627: end if;
3628: