[Home] [Help]
1319: p_sqlstr := 'SELECT distinct ASG.person_id
1320: FROM hr_organization_information HOI,
1321: per_all_assignments_f ASG,
1322: pay_us_asg_reporting puar,
1323: pay_state_rules SR
1324: WHERE SR.state_code = '''||l_state_abbrev||'''
1325: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''
1326: AND substr(puar.jurisdiction_code, 11,2)=nvl('''||l_tax_coll_dist_code||''',substr(puar.jurisdiction_code, 11,2))
1327: AND ASG.assignment_type = ''E''
1347: pay_payroll_actions ppa,
1348: per_all_assignments_f paf,
1349: pay_payroll_actions ppa1,
1350: pay_us_asg_reporting puar,
1351: pay_state_rules SR
1352: WHERE ppa1.payroll_action_id = :payroll_action_id
1353: AND ppa.business_group_id+0 = ppa1.business_group_id
1354: AND ppa1.effective_date = ppa.effective_date
1355: AND ppa.report_type = ''YREND''
1582: and ASG.primary_flag = 'Y'
1583: and ASG.business_group_id = ppa.business_group_id -- 5152728
1584: and exists (select '1'
1585: from pay_us_asg_reporting puar,
1586: pay_state_rules SR
1587: where SR.state_code = l_state_abbrev
1588: and substr(SR.jurisdiction_code ,1,2) =
1589: substr(puar.jurisdiction_code,1,2)
1590: and ASG.assignment_id = puar.assignment_id
1620: and ASG.primary_flag = 'Y'
1621: and ASG.business_group_id = ppa.business_group_id -- 5152728
1622: and exists (select '1'
1623: from pay_us_asg_reporting puar,
1624: pay_state_rules SR
1625: where SR.state_code = l_state_abbrev
1626: and substr(SR.jurisdiction_code ,1,2) =
1627: substr(puar.jurisdiction_code,1,2)
1628: and ASG.assignment_id = puar.assignment_id
2449: ltrim(rtrim(target.org_information2)) value3
2450: into l_value1,
2451: l_value2,
2452: l_value3
2453: from pay_state_rules rules,
2454: pay_us_states pus,
2455: hr_organization_information target
2456: where substr(rules.jurisdiction_code, 1, 2) =l_state_code
2457: and target.organization_id = p_tax_unit_id