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 250: from per_business_groups_perf c

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

Line 330: from per_business_groups_perf c

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

Line 410: from per_business_groups_perf c

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

Line 451: from per_business_groups_perf c

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

Line 590: from per_business_groups_perf c

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

Line 683: from per_business_groups_perf c

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

Line 767: from per_business_groups_perf c

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

Line 804: from per_business_groups_perf c

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

Line 898: from per_business_groups_perf c

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

Line 943: from per_business_groups_perf c

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

Line 1022: from per_business_groups_perf c

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

Line 1057: from per_business_groups_perf c

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

Line 1130: from per_business_groups_perf c

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

Line 1166: from per_business_groups_perf c

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

Line 1239: from per_business_groups_perf c

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

Line 1315: from per_business_groups_perf c

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

Line 1447: from per_business_groups_perf c

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

Line 1474: from per_business_groups_perf c

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

Line 2226: from per_business_groups_perf d

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