APPS.PAYUSUNB_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 205: FROM hr_organization_information

201: -- Cursor fetches the futa override rate based on the tax unit id passed.
202: CURSOR c_get_futa_override_rt(
203: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS
204: SELECT NVL(org_information7,0)/100
205: FROM hr_organization_information
206: WHERE organization_id = IN_tax_unit_id
207: AND org_information_context = 'Federal Tax Rules';
208:
209: -- cursor c_get_payroll_stuff made public

Line 894: FROM hr_organization_information

890: L_return_val NUMBER;
891:
892: CURSOR c_get_futa_credit_rt (IN_organization_id IN per_all_assignments_f.organization_id%TYPE) IS
893: SELECT org_information1,org_information15
894: FROM hr_organization_information
895: WHERE organization_id = IN_organization_id
896: AND org_information_context = 'State Tax Rules';
897:
898: CURSOR c_get_state_code (IN_sui_state_code IN VARCHAR2) Is

Line 970: FROM hr_organization_information org, pay_us_states pus

966: L_return_val NUMBER;
967:
968: CURSOR c_get_sui_sdi_overide_rt (IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS
969: SELECT pus.state_code,org_information6/100, org_information7/100 , org_information14/100
970: FROM hr_organization_information org, pay_us_states pus
971: WHERE org.org_information1 = pus.state_abbrev
972: AND pus.state_code between 00 and 99
973: AND org.organization_id = IN_tax_unit_id
974: AND org.org_information_context = 'State Tax Rules';