DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_EMP_STATE_TAX_RULES

Line 2067: FROM PAY_US_EMP_STATE_TAX_RULES st,

2063: -- cursors to compare the location provided with the location of
2064: -- the employee's assignment
2065: CURSOR csr_chk_state IS
2066: SELECT 'PASS'
2067: FROM PAY_US_EMP_STATE_TAX_RULES st,
2068: PAY_US_STATES pus
2069: WHERE st.assignment_id = p_assignment_id
2070: and st.state_code = pus.state_code
2071: and pus.state_abbrev = p_state_abbrev

Line 2695: FROM pay_us_emp_state_tax_rules_f sta,

2691: SELECT sta.sit_exempt,
2692: sta.sdi_exempt,
2693: NVL(sta.STA_INFORMATION5,'N'),
2694: sta.sui_exempt
2695: FROM pay_us_emp_state_tax_rules_f sta,
2696: PER_ASSIGNMENTS_F a,
2697: PER_BUSINESS_GROUPS bg,
2698: pay_us_states pus
2699: WHERE sta.assignment_id = a.assignment_id