[Home] [Help]
347: p_jurisdiction varchar2 ) IS
348: SELECT /*+ use_nl (hoi1, hoi2)*/
349: hoi1.org_information2,
350: hoi2.org_information1
351: FROM pay_state_rules SR,
352: hr_organization_information hoi1,
353: hr_organization_information hoi2
354: WHERE hoi1.organization_id = p_tax_unit_id
355: AND hoi1.org_information_context = 'State Tax Rules'
797: SELECT psr.jurisdiction_code
798: INTO l_sqwl_jurisdiction_code
799: FROM pay_assignment_actions paa,
800: pay_payroll_actions ppa,
801: pay_state_rules psr
802: WHERE paa.assignment_action_id = l_sqwl_assact
803: AND ppa.payroll_action_id = paa.payroll_action_id
804: AND psr.state_code = ppa.report_qualifier;
805:
860: -- verses the sui id of the assignment location state.
861:
862: SELECT hoi1.org_information2
863: INTO l_sui_id
864: FROM pay_state_rules SR,
865: hr_organization_information hoi1
866: WHERE hoi1.organization_id = l_tax_unit_id
867: AND hoi1.org_information_context = 'State Tax Rules'
868: AND hoi1.org_information1 = SR.state_code
977: SELECT psr.jurisdiction_code
978: INTO l_sqwl_jurisdiction_code
979: FROM pay_assignment_actions paa,
980: pay_payroll_actions ppa,
981: pay_state_rules psr
982: WHERE paa.assignment_action_id = l_sqwl_assact
983: AND ppa.payroll_action_id = paa.payroll_action_id
984: AND psr.state_code = ppa.report_qualifier;
985:
984: AND psr.state_code = ppa.report_qualifier;
985:
986: SELECT hoi1.org_information2
987: INTO l_sui_id
988: FROM pay_state_rules SR,
989: hr_organization_information hoi1
990: WHERE hoi1.organization_id = l_tax_unit_id
991: AND hoi1.org_information_context = 'State Tax Rules'
992: AND hoi1.org_information1 = SR.state_code
1275: BEGIN
1276: -- get the state code.
1277: SELECT state_code
1278: INTO l_state_code
1279: FROM pay_state_rules
1280: where fips_code = to_number(p_fips_code);
1281:
1282: -- sum the counts from pay_us_rpt_totals
1283: SELECT nvl(sum(prt.value1),0),