APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 3545: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F

3541:
3542: DELETE FROM PAY_US_ASG_REPORTING
3543: WHERE ASSIGNMENT_ID = p_assignment_id;
3544:
3545: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F
3546: WHERE ASSIGNMENT_ID = p_assignment_id;
3547:
3548: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F
3549: WHERE ASSIGNMENT_ID = p_assignment_id;

Line 3589: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F

3585: -- 03/18/1998 Change Ends
3586: --
3587: ELSIF p_mode = 'END' then
3588:
3589: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F
3590: WHERE ASSIGNMENT_ID = p_assignment_id
3591: AND EFFECTIVE_START_DATE > p_end_date;
3592:
3593: UPDATE PAY_US_EMP_CITY_TAX_RULES_F

Line 3593: UPDATE PAY_US_EMP_CITY_TAX_RULES_F

3589: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F
3590: WHERE ASSIGNMENT_ID = p_assignment_id
3591: AND EFFECTIVE_START_DATE > p_end_date;
3592:
3593: UPDATE PAY_US_EMP_CITY_TAX_RULES_F
3594: SET EFFECTIVE_END_DATE = p_end_date
3595: , LAST_UPDATED_BY = p_last_updated_by
3596: , LAST_UPDATE_LOGIN = p_last_update_login
3597: , LAST_UPDATE_DATE = sysdate