APPS.HR_ASSIGNMENT dependencies on PAY_COST_ALLOCATIONS_F

Line 2409: PAY_COST_ALLOCATIONS_F

2405: Performs Referential Integrity Checks on the following tables
2406: For 'ZAP'
2407: PER_EVENTS
2408: PER_LETTER_REQUEST_LINES
2409: PAY_COST_ALLOCATIONS_F
2410: PER_ASSIGNMENT_EXTRA_INFO
2411: PAY_PERSONAL_PAYMENT_METHODS_F
2412: HR_ASSIGNMENT_SET_AMENDMENTS
2413: PAY_ASSIGNMENT_ACTIONS

Line 2421: PAY_COST_ALLOCATIONS_F

2417:
2418: For 'END' (date effective delete)
2419: PER_EVENTS
2420: PER_LETTER_REQUEST_LINES
2421: PAY_COST_ALLOCATIONS_F
2422: PAY_PERSONAL_PAYMENT_METHODS_F
2423: PAY_ASSIGNMENT_ACTIONS
2424: PER_COBRA_COV_ENROLLMENTS
2425: PER_COBRA_COVERAGE_BENEFITS_F

Line 2553: from PAY_COST_ALLOCATIONS_F

2549: into p_del_flag
2550: from sys.dual
2551: where exists (
2552: select null
2553: from PAY_COST_ALLOCATIONS_F
2554: where assignment_id = p_assignment_id
2555: and (p_mode = 'ZAP'
2556: or (p_mode = 'END'
2557: and effective_start_date > p_end_date)));

Line 3663: PAY_COST_ALLOCATIONS_F

3659: future records.
3660:
3661: The following tables are affected.
3662:
3663: PAY_COST_ALLOCATIONS_F
3664: PER_SECONDARY_ASS_STATUSES
3665: PAY_PERSONAL_PAYMENT_METHODS_F
3666: PER_ASSIGNMENT_BUDGET_VALUES_F
3667:

Line 3803: from pay_cost_allocations_f

3799: into p_del_flag
3800: from sys.dual
3801: where exists (
3802: select null
3803: from pay_cost_allocations_f
3804: where assignment_id = p_assignment_id
3805: and ((p_mode = 'END'
3806: and p_new_end_date
3807: between effective_start_date and effective_end_date)

Line 3821: update pay_cost_allocations_f

3817: hr_utility.set_location('hr_assignment.tidy_up_ref_int',6);
3818:
3819: if p_mode = 'END' then
3820: hr_utility.set_location('hr_assignment.tidy_up_ref_int',7);
3821: update pay_cost_allocations_f
3822: set effective_end_date = p_new_end_date
3823: , last_updated_by = P_LAST_UPDATED_BY
3824: , last_update_login = P_LAST_UPDATE_LOGIN
3825: , last_update_date = sysdate

Line 3841: from pay_cost_allocations_f

3837: ** message to the user informing them of the situation.
3838: */
3839: select count(*)
3840: into l_exists
3841: from pay_cost_allocations_f
3842: where assignment_id = p_assignment_id
3843: and effective_start_date > p_old_end_date;
3844:
3845: if l_exists = 0 then

Line 3847: update pay_cost_allocations_f

3843: and effective_start_date > p_old_end_date;
3844:
3845: if l_exists = 0 then
3846: hr_utility.set_location('hr_assignment.tidy_up_ref_int',9);
3847: update pay_cost_allocations_f
3848: set effective_end_date = p_new_end_date
3849: , last_updated_by = P_LAST_UPDATED_BY
3850: , last_update_login = P_LAST_UPDATE_LOGIN
3851: , last_update_date = sysdate

Line 4783: from pay_cost_allocations_f

4779: l_proportion number;
4780: --
4781: cursor c_asg_cost_allocations(p_assignment_id number) is
4782: select 'x'
4783: from pay_cost_allocations_f
4784: where assignment_id = p_assignment_id;
4785: --
4786: cursor c_cost_allocation_keyflex(p_cost_allocation_keyflex_id number) is
4787: select *