APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 3505: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F

3501:
3502: DELETE FROM PAY_US_ASG_REPORTING
3503: WHERE ASSIGNMENT_ID = p_assignment_id;
3504:
3505: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F
3506: WHERE ASSIGNMENT_ID = p_assignment_id;
3507:
3508: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F
3509: WHERE ASSIGNMENT_ID = p_assignment_id;

Line 3549: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F

3545: -- 03/18/1998 Change Ends
3546: --
3547: ELSIF p_mode = 'END' then
3548:
3549: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F
3550: WHERE ASSIGNMENT_ID = p_assignment_id
3551: AND EFFECTIVE_START_DATE > p_end_date;
3552:
3553: UPDATE PAY_US_EMP_CITY_TAX_RULES_F

Line 3553: UPDATE PAY_US_EMP_CITY_TAX_RULES_F

3549: DELETE FROM PAY_US_EMP_CITY_TAX_RULES_F
3550: WHERE ASSIGNMENT_ID = p_assignment_id
3551: AND EFFECTIVE_START_DATE > p_end_date;
3552:
3553: UPDATE PAY_US_EMP_CITY_TAX_RULES_F
3554: SET EFFECTIVE_END_DATE = p_end_date
3555: , LAST_UPDATED_BY = p_last_updated_by
3556: , LAST_UPDATE_LOGIN = p_last_update_login
3557: , LAST_UPDATE_DATE = sysdate