DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 3551: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F

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;
3553:
3554: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F
3555: WHERE ASSIGNMENT_ID = p_assignment_id;

Line 3613: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F

3609: , LAST_UPDATE_DATE = sysdate
3610: WHERE ASSIGNMENT_ID = p_assignment_id
3611: AND p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
3612:
3613: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F
3614: WHERE ASSIGNMENT_ID = p_assignment_id
3615: AND EFFECTIVE_START_DATE > p_end_date;
3616:
3617: UPDATE PAY_US_EMP_STATE_TAX_RULES_F

Line 3617: UPDATE PAY_US_EMP_STATE_TAX_RULES_F

3613: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F
3614: WHERE ASSIGNMENT_ID = p_assignment_id
3615: AND EFFECTIVE_START_DATE > p_end_date;
3616:
3617: UPDATE PAY_US_EMP_STATE_TAX_RULES_F
3618: SET EFFECTIVE_END_DATE = p_end_date
3619: , LAST_UPDATED_BY = p_last_updated_by
3620: , LAST_UPDATE_LOGIN = p_last_update_login
3621: , LAST_UPDATE_DATE = sysdate