DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 3511: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F

3507:
3508: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F
3509: WHERE ASSIGNMENT_ID = p_assignment_id;
3510:
3511: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F
3512: WHERE ASSIGNMENT_ID = p_assignment_id;
3513:
3514: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F
3515: WHERE ASSIGNMENT_ID = p_assignment_id;

Line 3573: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F

3569: , LAST_UPDATE_DATE = sysdate
3570: WHERE ASSIGNMENT_ID = p_assignment_id
3571: AND p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
3572:
3573: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F
3574: WHERE ASSIGNMENT_ID = p_assignment_id
3575: AND EFFECTIVE_START_DATE > p_end_date;
3576:
3577: UPDATE PAY_US_EMP_STATE_TAX_RULES_F

Line 3577: UPDATE PAY_US_EMP_STATE_TAX_RULES_F

3573: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F
3574: WHERE ASSIGNMENT_ID = p_assignment_id
3575: AND EFFECTIVE_START_DATE > p_end_date;
3576:
3577: UPDATE PAY_US_EMP_STATE_TAX_RULES_F
3578: SET EFFECTIVE_END_DATE = p_end_date
3579: , LAST_UPDATED_BY = p_last_updated_by
3580: , LAST_UPDATE_LOGIN = p_last_update_login
3581: , LAST_UPDATE_DATE = sysdate