DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 1992: FROM pay_us_emp_state_tax_rules_f pes,

1988: SELECT DISTINCT
1989: pes.jurisdiction_code,
1990: pes.state_code,
1991: pus.state_abbrev
1992: FROM pay_us_emp_state_tax_rules_f pes,
1993: per_assignments_f paf,
1994: pay_us_states pus
1995: WHERE pes.assignment_id = paf.assignment_id
1996: AND pes.state_code = pus.state_code

Line 3124: FROM pay_us_emp_state_tax_rules_f

3120: /*Changes for Bug#13394260*/
3121:
3122: CURSOR get_use_default_sdi_ee_rate IS
3123: SELECT NVL(sta_information9,'N')
3124: FROM pay_us_emp_state_tax_rules_f
3125: WHERE assignment_id = IN_prc_assignment_id
3126: AND state_code = curr_state_code
3127: AND L_as_of_date BETWEEN effective_start_date
3128: AND effective_end_date