DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 3548: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F

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;
3550:
3551: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F
3552: WHERE ASSIGNMENT_ID = p_assignment_id;

Line 3601: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F

3597: , LAST_UPDATE_DATE = sysdate
3598: WHERE ASSIGNMENT_ID = p_assignment_id
3599: AND p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
3600:
3601: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F
3602: WHERE ASSIGNMENT_ID = p_assignment_id
3603: AND EFFECTIVE_START_DATE > p_end_date;
3604:
3605: UPDATE PAY_US_EMP_COUNTY_TAX_RULES_F

Line 3605: UPDATE PAY_US_EMP_COUNTY_TAX_RULES_F

3601: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F
3602: WHERE ASSIGNMENT_ID = p_assignment_id
3603: AND EFFECTIVE_START_DATE > p_end_date;
3604:
3605: UPDATE PAY_US_EMP_COUNTY_TAX_RULES_F
3606: SET EFFECTIVE_END_DATE = p_end_date
3607: , LAST_UPDATED_BY = p_last_updated_by
3608: , LAST_UPDATE_LOGIN = p_last_update_login
3609: , LAST_UPDATE_DATE = sysdate