149: l_legislation_code varchar2(150);
150:
151: cursor ac1 is
152: select legislation_code
153: from per_business_groups
154: where business_group_id = P_BUSINESS_GROUP_ID;
155: -- Bug 1319140 fix end: Added US legislation code check.
156:
157:
1234: select pav.organization_id,
1235: pbg.legislation_code,
1236: pav.location_id
1237: from per_assignments_f pav,
1238: per_business_groups pbg
1239: where c_row_id = pav.rowid
1240: and pav.business_group_id = pbg.business_group_id;
1241: --
1242: