APPS.FFDICT dependencies on PER_BUSINESS_GROUPS_PERF

Line 44: , per_business_groups_perf bg

40: , nvl(ue.legislation_code, bg.legislation_code)
41: into l_business_group_id
42: , l_legislation_code
43: from ff_user_entities ue
44: , per_business_groups_perf bg
45: where ue.user_entity_id = p_user_entity_id
46: and bg.business_group_id (+)= ue.business_group_id
47: ;
48: exception

Line 190: from per_business_groups_perf b

186: (a.legislation_code is null and a.business_group_id is null)
187: or
188: p_leg_code =
189: (select b.legislation_code
190: from per_business_groups_perf b
191: where b.business_group_id = a.business_group_id)
192: )
193: )
194: or

Line 249: from per_business_groups_perf c

245: (a.legislation_code is null and a.business_group_id is null)
246: or
247: p_leg_code =
248: (select c.legislation_code
249: from per_business_groups_perf c
250: where c.business_group_id = a.business_group_id
251: )
252: )
253: )

Line 329: from per_business_groups_perf c

325: (a.legislation_code is null and a.business_group_id is null)
326: or
327: tmp_leg_code =
328: (select c.legislation_code
329: from per_business_groups_perf c
330: where c.business_group_id = a.business_group_id
331: )
332: )
333: )

Line 409: from per_business_groups_perf c

405: (a.legislation_code is null and a.business_group_id is null)
406: or
407: p_leg_code =
408: (select c.legislation_code
409: from per_business_groups_perf c
410: where c.business_group_id = a.business_group_id
411: )
412: )
413: )

Line 450: from per_business_groups_perf c

446: (a.legislation_code is null and a.business_group_id is null)
447: or
448: p_leg_code =
449: (select c.legislation_code
450: from per_business_groups_perf c
451: where c.business_group_id = a.business_group_id
452: )
453: )
454: )

Line 589: from per_business_groups_perf c

585: (a.legislation_code is null and a.business_group_id is null)
586: or
587: tmp_leg_code =
588: (select c.legislation_code
589: from per_business_groups_perf c
590: where c.business_group_id = a.business_group_id
591: )
592: )
593: )

Line 682: from per_business_groups_perf c

678: (a.legislation_code is null and a.business_group_id is null)
679: or
680: p_leg_code =
681: (select c.legislation_code
682: from per_business_groups_perf c
683: where c.business_group_id = a.business_group_id
684: )
685: )
686: )

Line 766: from per_business_groups_perf c

762: (b.legislation_code is null and b.business_group_id is null)
763: or
764: p_leg_code =
765: (select c.legislation_code
766: from per_business_groups_perf c
767: where c.business_group_id = b.business_group_id
768: )
769: )
770: )

Line 803: from per_business_groups_perf c

799: (b.legislation_code is null and b.business_group_id is null)
800: or
801: p_leg_code =
802: (select c.legislation_code
803: from per_business_groups_perf c
804: where c.business_group_id = b.business_group_id
805: )
806: )
807: )

Line 897: from per_business_groups_perf c

893: (b.legislation_code is null and b.business_group_id is null)
894: or
895: p_legislation_code =
896: (select c.legislation_code
897: from per_business_groups_perf c
898: where c.business_group_id = b.business_group_id
899: )
900: )
901: )

Line 942: from per_business_groups_perf c

938: (b.legislation_code is null and b.business_group_id is null)
939: or
940: p_legislation_code =
941: (select c.legislation_code
942: from per_business_groups_perf c
943: where c.business_group_id = b.business_group_id
944: )
945: )
946: )

Line 1021: from per_business_groups_perf c

1017: (a.legislation_code is null and a.business_group_id is null)
1018: or
1019: p_leg_code =
1020: (select c.legislation_code
1021: from per_business_groups_perf c
1022: where c.business_group_id = a.business_group_id
1023: )
1024: )
1025: )

Line 1056: from per_business_groups_perf c

1052: (a.legislation_code is null and a.business_group_id is null)
1053: or
1054: p_leg_code =
1055: (select c.legislation_code
1056: from per_business_groups_perf c
1057: where c.business_group_id = a.business_group_id
1058: )
1059: )
1060: )

Line 1129: from per_business_groups_perf c

1125: (a.legislation_code is null and a.business_group_id is null)
1126: or
1127: p_leg_code =
1128: (select c.legislation_code
1129: from per_business_groups_perf c
1130: where c.business_group_id = a.business_group_id
1131: )
1132: )
1133: )

Line 1165: from per_business_groups_perf c

1161: (a.legislation_code is null and a.business_group_id is null)
1162: or
1163: p_leg_code =
1164: (select c.legislation_code
1165: from per_business_groups_perf c
1166: where c.business_group_id = a.business_group_id
1167: )
1168: )
1169: )

Line 1238: from per_business_groups_perf c

1234: (a.legislation_code is null and a.business_group_id is null)
1235: or
1236: p_leg_code =
1237: (select c.legislation_code
1238: from per_business_groups_perf c
1239: where c.business_group_id = a.business_group_id
1240: )
1241: )
1242: )

Line 1314: from per_business_groups_perf c

1310: (a.legislation_code is null and a.business_group_id is null)
1311: or
1312: p_leg_code =
1313: (select c.legislation_code
1314: from per_business_groups_perf c
1315: where c.business_group_id = a.business_group_id
1316: )
1317: )
1318: )

Line 1445: from per_business_groups_perf c

1441: (ff.legislation_code is null and ff.business_group_id is null)
1442: or
1443: p_leg_code =
1444: (select c.legislation_code
1445: from per_business_groups_perf c
1446: where c.business_group_id = ff.business_group_id
1447: )
1448: )
1449: )

Line 1472: from per_business_groups_perf c

1468: (ff.legislation_code is null and ff.business_group_id is null)
1469: or
1470: p_leg_code =
1471: (select c.legislation_code
1472: from per_business_groups_perf c
1473: where c.business_group_id = ff.business_group_id
1474: )
1475: )
1476: )

Line 2223: from per_business_groups_perf d

2219: (legislation_code is null and business_group_id is null)
2220: or
2221: leg_code =
2222: (select d.legislation_code
2223: from per_business_groups_perf d
2224: where d.business_group_id = b.business_group_id
2225: )
2226: )
2227: )