APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 2817: from PAY_US_EMP_FED_TAX_RULES_F pef,

2813: into p_del_flag
2814: from sys.dual
2815: where exists (
2816: select null
2817: from PAY_US_EMP_FED_TAX_RULES_F pef,
2818: per_assignments_f paf
2819: where pef.assignment_id = p_assignment_id
2820: and paf.assignment_id = pef.assignment_id
2821: and paf.primary_flag = 'Y'

Line 3527: from PAY_US_EMP_FED_TAX_RULES_F pef

3523: into p_del_flag
3524: from sys.dual
3525: where exists (
3526: select null
3527: from PAY_US_EMP_FED_TAX_RULES_F pef
3528: where pef.assignment_id = p_assignment_id);
3529:
3530: EXCEPTION
3531: WHEN NO_DATA_FOUND THEN NULL;

Line 3554: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F

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;
3556:
3557: END IF;
3558: --

Line 3625: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F

3621: , LAST_UPDATE_DATE = sysdate
3622: WHERE ASSIGNMENT_ID = p_assignment_id
3623: AND p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
3624:
3625: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F
3626: WHERE ASSIGNMENT_ID = p_assignment_id
3627: AND EFFECTIVE_START_DATE > p_end_date;
3628:
3629: UPDATE PAY_US_EMP_FED_TAX_RULES_F

Line 3629: UPDATE PAY_US_EMP_FED_TAX_RULES_F

3625: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F
3626: WHERE ASSIGNMENT_ID = p_assignment_id
3627: AND EFFECTIVE_START_DATE > p_end_date;
3628:
3629: UPDATE PAY_US_EMP_FED_TAX_RULES_F
3630: SET EFFECTIVE_END_DATE = p_end_date
3631: , LAST_UPDATED_BY = p_last_updated_by
3632: , LAST_UPDATE_LOGIN = p_last_update_login
3633: , LAST_UPDATE_DATE = sysdate

Line 3957: from pay_us_emp_fed_tax_rules_f

3953: hr_utility.trace(' **** old end date = '||to_char(p_old_end_date,'dd-mon-yyyy'));
3954: declare
3955: cursor csr_asg is
3956: select max(effective_end_date)
3957: from pay_us_emp_fed_tax_rules_f
3958: where assignment_id = p_assignment_id;
3959: l_end_date date;
3960: begin
3961: open csr_asg;