DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 928: from hr_organization_units

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

Line 1350: from hr_organization_units

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