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 3427: and exists (select null from per_business_groups b

3423: into l_null_return
3424: from ff_functions a
3425: where a.name = stu_rec.name
3426: and a.business_group_id is not null
3427: and exists (select null from per_business_groups b
3428: where b.business_group_id = a.business_group_id
3429: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
3430:
3431: crt_exc('Row already created in a business group');

Line 4071: and exists (select null from per_business_groups b

4067: into l_null_return
4068: from ff_qp_reports a
4069: where a.qp_report_name = stu_rec.c_true_key
4070: and a.business_group_id is not null
4071: and exists (select null from per_business_groups b
4072: where b.business_group_id = a.business_group_id
4073: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
4074:
4075: crt_exc('Row already created in a business group');

Line 4522: and exists (select null from per_business_groups b

4518: select distinct null
4519: from ff_globals_f a
4520: where a.global_name = r_distinct.c_true_key
4521: and a.business_group_id is not null
4522: and exists (select null from per_business_groups b
4523: where b.business_group_id = a.business_group_id
4524: and b.legislation_code = nvl(r_distinct.legislation_code,b.legislation_code));
4525:
4526: --