APPS.PAYUSUNB_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 266: FROM hr_organization_information

262: -- Cursor fetches the futa override rate based on the tax unit id passed.
263: CURSOR c_get_futa_override_rt(
264: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS
265: SELECT NVL(org_information7,0)/100
266: FROM hr_organization_information
267: WHERE organization_id = IN_tax_unit_id
268: AND org_information_context = 'Federal Tax Rules';
269:
270: -- cursor c_get_payroll_stuff made public

Line 1379: FROM hr_organization_information

1375: L_return_val NUMBER;
1376:
1377: CURSOR c_get_futa_credit_rt (IN_organization_id IN per_all_assignments_f.organization_id%TYPE) IS
1378: SELECT org_information1,org_information15
1379: FROM hr_organization_information
1380: WHERE organization_id = IN_organization_id
1381: AND org_information_context = 'State Tax Rules';
1382:
1383: CURSOR c_get_state_code (IN_sui_state_code IN VARCHAR2) Is

Line 1455: FROM hr_organization_information org, pay_us_states pus

1451: L_return_val NUMBER;
1452:
1453: CURSOR c_get_sui_sdi_overide_rt (IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS
1454: SELECT pus.state_code,org_information6/100, org_information7/100 , org_information14/100
1455: FROM hr_organization_information org, pay_us_states pus
1456: WHERE org.org_information1 = pus.state_abbrev
1457: AND pus.state_code between 00 and 99
1458: AND org.organization_id = IN_tax_unit_id
1459: AND org.org_information_context = 'State Tax Rules';