APPS.PAY_US_W2_INFO_PKG dependencies on PAY_US_LOCALITY_W2_V

Line 453: from pay_us_locality_w2_v

449: SELECT 'BOONOCC' w2_other_code,
450: w2_local_income_tax -
451: decode(sign(w2_local_wages - 16666), -1,
452: w2_local_wages * 0.0015, 25) w2_other_value
453: from pay_us_locality_w2_v
454: where state_abbrev = 'KY'
455: and tax_type = 'COUNTY'
456: and substr(jurisdiction,1,6) = '18-015'
457: and assignment_action_id = p_asg_action_id

Line 465: from pay_us_locality_w2_v

461: CURSOR c_get_box14_boonmh (p_asg_action_id NUMBER) IS
462: SELECT 'BOONMH' w2_other_code,
463: decode(sign(w2_local_wages - 16666), -1,
464: w2_local_wages * 0.0015, 25) w2_other_value
465: from pay_us_locality_w2_v
466: where state_abbrev = 'KY'
467: and tax_type = 'COUNTY'
468: and substr(jurisdiction,1,6) = '18-015'
469: and assignment_action_id = p_asg_action_id

Line 479: FROM pay_us_locality_w2_v

475: w2_local_income_tax locality_tax,
476: jurisdiction jurisdiction,
477: state_abbrev state_code,
478: tax_type
479: FROM pay_us_locality_w2_v
480: WHERE assignment_action_id = p_asg_action_id
481: /*commented for 4102684
482: and W2_LOCAL_INCOME_TAX > 0*/
483: -- and (jurisdiction <> '18-015-0000')