APPS.HR_ASSIGNMENT dependencies on PAY_COST_ALLOCATIONS_F

Line 2372: PAY_COST_ALLOCATIONS_F

2368: Performs Referential Integrity Checks on the following tables
2369: For 'ZAP'
2370: PER_EVENTS
2371: PER_LETTER_REQUEST_LINES
2372: PAY_COST_ALLOCATIONS_F
2373: PER_ASSIGNMENT_EXTRA_INFO
2374: PAY_PERSONAL_PAYMENT_METHODS_F
2375: HR_ASSIGNMENT_SET_AMENDMENTS
2376: PAY_ASSIGNMENT_ACTIONS

Line 2384: PAY_COST_ALLOCATIONS_F

2380:
2381: For 'END' (date effective delete)
2382: PER_EVENTS
2383: PER_LETTER_REQUEST_LINES
2384: PAY_COST_ALLOCATIONS_F
2385: PAY_PERSONAL_PAYMENT_METHODS_F
2386: PAY_ASSIGNMENT_ACTIONS
2387: PER_COBRA_COV_ENROLLMENTS
2388: PER_COBRA_COVERAGE_BENEFITS_F

Line 2516: from PAY_COST_ALLOCATIONS_F

2512: into p_del_flag
2513: from sys.dual
2514: where exists (
2515: select null
2516: from PAY_COST_ALLOCATIONS_F
2517: where assignment_id = p_assignment_id
2518: and (p_mode = 'ZAP'
2519: or (p_mode = 'END'
2520: and effective_start_date > p_end_date)));

Line 3623: PAY_COST_ALLOCATIONS_F

3619: future records.
3620:
3621: The following tables are affected.
3622:
3623: PAY_COST_ALLOCATIONS_F
3624: PER_SECONDARY_ASS_STATUSES
3625: PAY_PERSONAL_PAYMENT_METHODS_F
3626: PER_ASSIGNMENT_BUDGET_VALUES_F
3627:

Line 3763: from pay_cost_allocations_f

3759: into p_del_flag
3760: from sys.dual
3761: where exists (
3762: select null
3763: from pay_cost_allocations_f
3764: where assignment_id = p_assignment_id
3765: and ((p_mode = 'END'
3766: and p_new_end_date
3767: between effective_start_date and effective_end_date)

Line 3781: update pay_cost_allocations_f

3777: hr_utility.set_location('hr_assignment.tidy_up_ref_int',6);
3778:
3779: if p_mode = 'END' then
3780: hr_utility.set_location('hr_assignment.tidy_up_ref_int',7);
3781: update pay_cost_allocations_f
3782: set effective_end_date = p_new_end_date
3783: , last_updated_by = P_LAST_UPDATED_BY
3784: , last_update_login = P_LAST_UPDATE_LOGIN
3785: , last_update_date = sysdate

Line 3801: from pay_cost_allocations_f

3797: ** message to the user informing them of the situation.
3798: */
3799: select count(*)
3800: into l_exists
3801: from pay_cost_allocations_f
3802: where assignment_id = p_assignment_id
3803: and effective_start_date > p_old_end_date;
3804:
3805: if l_exists = 0 then

Line 3807: update pay_cost_allocations_f

3803: and effective_start_date > p_old_end_date;
3804:
3805: if l_exists = 0 then
3806: hr_utility.set_location('hr_assignment.tidy_up_ref_int',9);
3807: update pay_cost_allocations_f
3808: set effective_end_date = p_new_end_date
3809: , last_updated_by = P_LAST_UPDATED_BY
3810: , last_update_login = P_LAST_UPDATE_LOGIN
3811: , last_update_date = sysdate

Line 4743: from pay_cost_allocations_f

4739: l_proportion number;
4740: --
4741: cursor c_asg_cost_allocations(p_assignment_id number) is
4742: select 'x'
4743: from pay_cost_allocations_f
4744: where assignment_id = p_assignment_id;
4745: --
4746: cursor c_cost_allocation_keyflex(p_cost_allocation_keyflex_id number) is
4747: select *