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:
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');
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');
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: --