APPS.PAY_NEGBAL_PKG dependencies on PAY_US_ASG_REPORTING

Line 157: pay_us_asg_reporting puar,

153: hr_organization_units HOU,
154: pay_payrolls_f PPY,
155: pay_state_rules SR,
156: hr_organization_information HOI,
157: pay_us_asg_reporting puar,
158: pay_payroll_actions PPA
159: WHERE PPA.payroll_action_id = :payroll_action_id
160: AND SR.state_code = '''||l_state||'''
161: AND substr(SR.jurisdiction_code,1,2) = substr(puar.jurisdiction_code,1,2)

Line 264: AND EXISTS (select '' from pay_us_asg_reporting puar

260: AND SR.state_code = l_state
261: AND hoi.organization_id = paa.tax_unit_id
262: AND hoi.org_information_context = 'State Tax Rules'
263: AND hoi.org_information1 = l_state
264: AND EXISTS (select '' from pay_us_asg_reporting puar
265: where asg.assignment_id = puar.assignment_id
266: and paa.tax_unit_id = puar.tax_unit_id
267: and substr(SR.jurisdiction_code ,1,2) =
268: substr(puar.jurisdiction_code,1,2));