924: and ppa.business_group_id +0 = ppf.business_group_id;
925:
926: CURSOR c_get_bg_id is
927: select business_group_id
928: from hr_organization_units
929: where organization_id = p_gre_id_context;
930:
931: CURSOR get_year (p_assign_action_id NUMBER) IS
932: SELECT TO_CHAR(effective_date,'YYYY')
1346: pay_balance_pkg.set_context('BALANCE_DATE',
1347: fnd_date.date_to_canonical(l_virtual_date));
1348: select business_group_id
1349: into l_bg_id
1350: from hr_organization_units
1351: where organization_id = p_gre_id_context;
1352: --
1353: -- Look to see if theres an assignment in the cache for
1354: -- this business group