DBA Data[Home] [Help]

APPS.FF_DATA_DICT dependencies on PER_BUSINESS_GROUPS

Line 1483: and exists (select null from per_business_groups b

1479: from ff_formulas_f a
1480: where a.formula_name = r_distinct.c_true_key
1481: and a.formula_type_id = r_distinct.formula_type_id
1482: and a.business_group_id is not null
1483: and exists (select null from per_business_groups b
1484: where b.business_group_id = a.business_group_id
1485: and b.legislation_code = nvl(r_distinct.legislation_code,b.legislation_code));
1486:
1487:

Line 3478: and exists (select null from per_business_groups b

3474: into l_null_return
3475: from ff_functions a
3476: where a.name = stu_rec.name
3477: and a.business_group_id is not null
3478: and exists (select null from per_business_groups b
3479: where b.business_group_id = a.business_group_id
3480: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
3481:
3482: crt_exc('Row already created in a business group');

Line 4122: and exists (select null from per_business_groups b

4118: into l_null_return
4119: from ff_qp_reports a
4120: where a.qp_report_name = stu_rec.c_true_key
4121: and a.business_group_id is not null
4122: and exists (select null from per_business_groups b
4123: where b.business_group_id = a.business_group_id
4124: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
4125:
4126: crt_exc('Row already created in a business group');

Line 4573: and exists (select null from per_business_groups b

4569: select distinct null
4570: from ff_globals_f a
4571: where a.global_name = r_distinct.c_true_key
4572: and a.business_group_id is not null
4573: and exists (select null from per_business_groups b
4574: where b.business_group_id = a.business_group_id
4575: and b.legislation_code = nvl(r_distinct.legislation_code,b.legislation_code));
4576:
4577: --