APPS.HR_ASSIGNMENT dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 2780: from PAY_US_EMP_FED_TAX_RULES_F pef,

2776: into p_del_flag
2777: from sys.dual
2778: where exists (
2779: select null
2780: from PAY_US_EMP_FED_TAX_RULES_F pef,
2781: per_assignments_f paf
2782: where pef.assignment_id = p_assignment_id
2783: and paf.assignment_id = pef.assignment_id
2784: and paf.primary_flag = 'Y'

Line 3487: from PAY_US_EMP_FED_TAX_RULES_F pef

3483: into p_del_flag
3484: from sys.dual
3485: where exists (
3486: select null
3487: from PAY_US_EMP_FED_TAX_RULES_F pef
3488: where pef.assignment_id = p_assignment_id);
3489:
3490: EXCEPTION
3491: WHEN NO_DATA_FOUND THEN NULL;

Line 3514: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F

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;
3516:
3517: END IF;
3518: --

Line 3585: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F

3581: , LAST_UPDATE_DATE = sysdate
3582: WHERE ASSIGNMENT_ID = p_assignment_id
3583: AND p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
3584:
3585: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F
3586: WHERE ASSIGNMENT_ID = p_assignment_id
3587: AND EFFECTIVE_START_DATE > p_end_date;
3588:
3589: UPDATE PAY_US_EMP_FED_TAX_RULES_F

Line 3589: UPDATE PAY_US_EMP_FED_TAX_RULES_F

3585: DELETE FROM PAY_US_EMP_FED_TAX_RULES_F
3586: WHERE ASSIGNMENT_ID = p_assignment_id
3587: AND EFFECTIVE_START_DATE > p_end_date;
3588:
3589: UPDATE PAY_US_EMP_FED_TAX_RULES_F
3590: SET EFFECTIVE_END_DATE = p_end_date
3591: , LAST_UPDATED_BY = p_last_updated_by
3592: , LAST_UPDATE_LOGIN = p_last_update_login
3593: , LAST_UPDATE_DATE = sysdate

Line 3917: from pay_us_emp_fed_tax_rules_f

3913: hr_utility.trace(' **** old end date = '||to_char(p_old_end_date,'dd-mon-yyyy'));
3914: declare
3915: cursor csr_asg is
3916: select max(effective_end_date)
3917: from pay_us_emp_fed_tax_rules_f
3918: where assignment_id = p_assignment_id;
3919: l_end_date date;
3920: begin
3921: open csr_asg;