[Home] [Help]
329: p_jurisdiction varchar2 ) IS
330: SELECT /*+ use_nl (hoi1, hoi2)*/
331: hoi1.org_information2,
332: hoi2.org_information1
333: FROM pay_state_rules SR,
334: hr_organization_information hoi1,
335: hr_organization_information hoi2
336: WHERE hoi1.organization_id = p_tax_unit_id
337: AND hoi1.org_information_context = 'State Tax Rules'
650: SELECT psr.jurisdiction_code
651: INTO l_sqwl_jurisdiction_code
652: FROM pay_assignment_actions paa,
653: pay_payroll_actions ppa,
654: pay_state_rules psr
655: WHERE paa.assignment_action_id = l_sqwl_assact
656: AND ppa.payroll_action_id = paa.payroll_action_id
657: AND psr.state_code = ppa.report_qualifier;
658:
688: -- verses the sui id of the assignment location state.
689:
690: SELECT hoi1.org_information2
691: INTO l_sui_id
692: FROM pay_state_rules SR,
693: hr_organization_information hoi1
694: WHERE hoi1.organization_id = l_tax_unit_id
695: AND hoi1.org_information_context = 'State Tax Rules'
696: AND hoi1.org_information1 = SR.state_code
743: SELECT psr.jurisdiction_code
744: INTO l_sqwl_jurisdiction_code
745: FROM pay_assignment_actions paa,
746: pay_payroll_actions ppa,
747: pay_state_rules psr
748: WHERE paa.assignment_action_id = l_sqwl_assact
749: AND ppa.payroll_action_id = paa.payroll_action_id
750: AND psr.state_code = ppa.report_qualifier;
751:
750: AND psr.state_code = ppa.report_qualifier;
751:
752: SELECT hoi1.org_information2
753: INTO l_sui_id
754: FROM pay_state_rules SR,
755: hr_organization_information hoi1
756: WHERE hoi1.organization_id = l_tax_unit_id
757: AND hoi1.org_information_context = 'State Tax Rules'
758: AND hoi1.org_information1 = SR.state_code
987: BEGIN
988: -- get the state code.
989: SELECT state_code
990: INTO l_state_code
991: FROM pay_state_rules
992: where fips_code = to_number(p_fips_code);
993:
994: -- sum the counts from pay_us_rpt_totals
995: SELECT nvl(sum(prt.value1),0),