DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_US_ASG_REPORTING

Line 183: In addition, delete from the table pay_us_asg_reporting as

179: it is not a primary assignment then let it get purged.
180: For Bug# 785427,if the federal tax record exists then the
181: state, county and city tax records also exist (due to the
182: defaulting of tax records). So, delete from all 4 table.
183: In addition, delete from the table pay_us_asg_reporting as
184: well.
185: 110.9 24-MAY-1999 HWinsor 896943 Added new columns into do_primary_update.
186: 110.10 02-OCT-2001 vsjain Added new parameters for collective_agreement module
187: Like notice period, notice_period_uom, work_at_home,

Line 3500: from the table pay_us_asg_reporting as well */

3496: hr_utility.set_location('hr_assignment.delete_ass_ref_int',12);
3497: /* If the federal tax record exists then the state, county
3498: and city tax records also exist (due to the defaulting of
3499: tax records). So, delete from all 4 table. In addition, delete
3500: from the table pay_us_asg_reporting as well */
3501:
3502: DELETE FROM PAY_US_ASG_REPORTING
3503: WHERE ASSIGNMENT_ID = p_assignment_id;
3504:

Line 3502: DELETE FROM PAY_US_ASG_REPORTING

3498: and city tax records also exist (due to the defaulting of
3499: tax records). So, delete from all 4 table. In addition, delete
3500: from the table pay_us_asg_reporting as well */
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;