DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1553: from per_all_assignments_f paf

1549: Select 'X'
1550: into v_dummy
1551: from sys.dual
1552: where exists (select 'Assignments Exist'
1553: from per_all_assignments_f paf
1554: where paf.supervisor_id = p_person_id
1555: and paf.business_group_id = p_business_group_id
1556: and p_session_date between paf.effective_start_date
1557: and paf.effective_end_date);

Line 1756: from per_all_assignments_f asg

1752: --
1753: cursor csr_get_asgs_to_terminate is
1754: select asg.assignment_id
1755: , asg.object_version_number
1756: from per_all_assignments_f asg
1757: where asg.person_id = l_person_id
1758: and asg.period_of_placement_date_start = l_date_start
1759: and l_actual_termination_date + 1 between asg.effective_start_date
1760: and asg.effective_end_date

Line 1784: ,per_all_assignments_f asg

1780: --
1781: cursor csr_get_max_tpe_end_date is
1782: select max(tpe.end_date)
1783: from per_time_periods tpe
1784: ,per_all_assignments_f asg
1785: where asg.person_id = l_person_id
1786: and asg.period_of_placement_date_start = l_date_start
1787: and l_actual_termination_date between asg.effective_start_date
1788: and asg.effective_end_date

Line 2357: from per_all_assignments_f asg

2353: cursor csr_get_asgs_to_final_proc is
2354: select asg.assignment_id
2355: , asg.object_version_number
2356: , asg.primary_flag
2357: from per_all_assignments_f asg
2358: where asg.person_id = p_person_id
2359: and asg.period_of_placement_date_start = p_date_start
2360: and l_final_process_date between asg.effective_start_date
2361: and asg.effective_end_date

Line 3258: FROM per_all_assignments_f ass

3254: CURSOR c_assignment IS
3255: SELECT assignment_id
3256: , assignment_status_type_id
3257: , business_group_id
3258: FROM per_all_assignments_f ass
3259: WHERE ass.person_id = p_person_id
3260: AND ass.effective_end_date = p_actual_termination_date
3261: FOR UPDATE;
3262: --

Line 3427: per_all_assignments_f asg

3423: WHERE exists
3424: (SELECT null
3425: FROM pay_payroll_actions pac,
3426: pay_assignment_actions act,
3427: per_all_assignments_f asg
3428: WHERE asg.person_id = p_person_id
3429: AND act.assignment_id = asg.assignment_id
3430: AND pac.payroll_action_id = act.payroll_action_id
3431: AND pac.action_type not in ('X','BEE') -- Bug 889806,2711532

Line 3447: per_all_assignments_f asg

3443: WHERE exists
3444: (SELECT null
3445: FROM pay_payroll_actions pac,
3446: pay_assignment_actions act,
3447: per_all_assignments_f asg
3448: WHERE asg.person_id = p_person_id
3449: AND act.assignment_id = asg.assignment_id
3450: AND pac.payroll_action_id = act.payroll_action_id
3451: AND pac.action_status = 'C'

Line 3630: FROM per_all_assignments_f

3626: -- are currently TERM_CWK_ASG back to the appropriate ACTIVE_CWK_ASG status.
3627: --
3628: SELECT assignment_status_type_id
3629: INTO l_asg_status_type_id
3630: FROM per_all_assignments_f
3631: WHERE assignment_id = c_asg_rec.assignment_id
3632: AND effective_end_date = p_actual_termination_date;
3633: --
3634: hr_utility.set_location(l_proc,80);

Line 3638: FROM per_all_assignments_f asg

3634: hr_utility.set_location(l_proc,80);
3635:
3636: SELECT max(asg.effective_end_date)
3637: INTO l_max_end_date
3638: FROM per_all_assignments_f asg
3639: WHERE asg.assignment_id = c_asg_rec.assignment_id;
3640:
3641: --
3642: if l_per_system_status <> 'TERM_CWK_ASG' then

Line 3662: UPDATE per_all_assignments_f ass

3658: --
3659: -- Open out the last dated assignment record to the end of time or
3660: -- max_end_date based on above logic.
3661: --
3662: UPDATE per_all_assignments_f ass
3663: SET ass.effective_end_date = l_effective_end_date
3664: WHERE assignment_id = c_asg_rec.assignment_id
3665: AND effective_end_date = l_max_end_date;
3666: --

Line 3677: UPDATE per_all_assignments_f ass

3673: -- record will exist which runs from ATD+1 to the start date-1
3674: -- of the next date effective record for the person or EOT
3675: -- depending on the data present at time of termination.
3676: --
3677: UPDATE per_all_assignments_f ass
3678: SET ass.assignment_status_type_id = l_asg_status_type_id
3679: WHERE assignment_id = c_asg_rec.assignment_id
3680: AND effective_start_date >= p_actual_termination_date;
3681: --