DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 3508: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F

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;
3510:
3511: DELETE FROM PAY_US_EMP_STATE_TAX_RULES_F
3512: WHERE ASSIGNMENT_ID = p_assignment_id;

Line 3561: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F

3557: , LAST_UPDATE_DATE = sysdate
3558: WHERE ASSIGNMENT_ID = p_assignment_id
3559: AND p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
3560:
3561: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F
3562: WHERE ASSIGNMENT_ID = p_assignment_id
3563: AND EFFECTIVE_START_DATE > p_end_date;
3564:
3565: UPDATE PAY_US_EMP_COUNTY_TAX_RULES_F

Line 3565: UPDATE PAY_US_EMP_COUNTY_TAX_RULES_F

3561: DELETE FROM PAY_US_EMP_COUNTY_TAX_RULES_F
3562: WHERE ASSIGNMENT_ID = p_assignment_id
3563: AND EFFECTIVE_START_DATE > p_end_date;
3564:
3565: UPDATE PAY_US_EMP_COUNTY_TAX_RULES_F
3566: SET EFFECTIVE_END_DATE = p_end_date
3567: , LAST_UPDATED_BY = p_last_updated_by
3568: , LAST_UPDATE_LOGIN = p_last_update_login
3569: , LAST_UPDATE_DATE = sysdate