eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EMPLOYEE_API dependencies on PER_ASSIGNMENTS_F

Line 18: FROM per_assignments_f asg

14: )
15: IS
16: SELECT asg.assignment_id
17: ,asg.object_version_number
18: FROM per_assignments_f asg
19: WHERE asg.person_id = csr_future_asgs.p_person_id
20: --
21: -- 115.58 (START)
22: --

Line 76: FROM per_assignments_f asg1

72: -- 115.58 (START)
73: --
74: CURSOR csr_back_to_back IS
75: SELECT 'x'
76: FROM per_assignments_f asg1
77: ,per_assignments_f asg2
78: ,per_assignment_status_types pas1
79: ,per_assignment_status_types pas2
80: ,per_periods_of_service pds

Line 77: ,per_assignments_f asg2

73: --
74: CURSOR csr_back_to_back IS
75: SELECT 'x'
76: FROM per_assignments_f asg1
77: ,per_assignments_f asg2
78: ,per_assignment_status_types pas1
79: ,per_assignment_status_types pas2
80: ,per_periods_of_service pds
81: WHERE pds.person_id = p_person_id

Line 310: l_assignment_sequence per_assignments_f.assignment_sequence%type;

306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;
309: l_npw_number per_people_f.npw_number%TYPE;
310: l_assignment_sequence per_assignments_f.assignment_sequence%type;
311: l_assignment_number per_assignments_f.assignment_number%type;
312: l_hire_date date;
313: l_discard_number number;
314: l_discard_date date;

Line 311: l_assignment_number per_assignments_f.assignment_number%type;

307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;
309: l_npw_number per_people_f.npw_number%TYPE;
310: l_assignment_sequence per_assignments_f.assignment_sequence%type;
311: l_assignment_number per_assignments_f.assignment_number%type;
312: l_hire_date date;
313: l_discard_number number;
314: l_discard_date date;
315: l_discard_varchar2 varchar2(30);

Line 2557: -- The l_assignment_id is declared as per_assignments_f.assignment_id%type.

2553: --
2554: -- Added local variables for after hook re_hire_ex_employee_a
2555: --
2556: -- Bug 1828850 starts here.
2557: -- The l_assignment_id is declared as per_assignments_f.assignment_id%type.
2558: --
2559: l_assignment_id per_assignments_f.assignment_id%type;
2560: --
2561: -- Bug 1828850 Ends here.

Line 2559: l_assignment_id per_assignments_f.assignment_id%type;

2555: --
2556: -- Bug 1828850 starts here.
2557: -- The l_assignment_id is declared as per_assignments_f.assignment_id%type.
2558: --
2559: l_assignment_id per_assignments_f.assignment_id%type;
2560: --
2561: -- Bug 1828850 Ends here.
2562: --
2563: l_asg_object_version_number number(9);

Line 3304: l_comment_id per_assignments_f.comment_id%type;

3300: l_legislation_code per_business_groups.legislation_code%type;
3301: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3302: l_person_type_id1 per_people_f.person_type_id%type;
3303: l_application_id per_applications.application_id%type;
3304: l_comment_id per_assignments_f.comment_id%type;
3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3306: l_assignment_id per_assignments_f.assignment_id%type;
3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;

Line 3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;

3301: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3302: l_person_type_id1 per_people_f.person_type_id%type;
3303: l_application_id per_applications.application_id%type;
3304: l_comment_id per_assignments_f.comment_id%type;
3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3306: l_assignment_id per_assignments_f.assignment_id%type;
3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

Line 3306: l_assignment_id per_assignments_f.assignment_id%type;

3302: l_person_type_id1 per_people_f.person_type_id%type;
3303: l_application_id per_applications.application_id%type;
3304: l_comment_id per_assignments_f.comment_id%type;
3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3306: l_assignment_id per_assignments_f.assignment_id%type;
3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;

Line 3307: l_object_version_number per_assignments_f.object_version_number%type;

3303: l_application_id per_applications.application_id%type;
3304: l_comment_id per_assignments_f.comment_id%type;
3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3306: l_assignment_id per_assignments_f.assignment_id%type;
3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;

Line 4545: FROM per_assignments_f

4541: ,assignment_category
4542: ,project_title
4543: ,grade_ladder_pgm_id
4544: ,supervisor_assignment_id
4545: FROM per_assignments_f
4546: WHERE person_id = c_prim_asg.p_person_id
4547: AND primary_flag = 'Y'
4548: AND assignment_type <> 'B' -- 115.59
4549: AND c_prim_asg.p_effective_date BETWEEN effective_start_date

Line 4585: UPDATE per_assignments_f

4581: --
4582: -- Update all assignments records for this assignment with
4583: -- ESD >= rehire date setting primary flag to 'Y'
4584: --
4585: UPDATE per_assignments_f
4586: SET primary_flag = 'Y'
4587: ,object_version_number = object_version_number + 1
4588: WHERE assignment_id = lr_prim_asg.assignment_id
4589: AND assignment_type <> 'B' -- 115.59

Line 4616: UPDATE per_assignments_f

4612: hr_utility.set_location(l_proc, 40);
4613: --
4614: -- Set the primary assignment flag to 'N' for this record.
4615: --
4616: UPDATE per_assignments_f
4617: SET primary_flag = 'N'
4618: ,object_version_number = object_version_number + 1
4619: WHERE assignment_id = lr_prim_asg.assignment_id
4620: AND assignment_type <> 'B' -- 115.59

Line 4629: UPDATE per_assignments_f

4625: hr_utility.set_location(l_proc, 50);
4626: --
4627: -- Update EED to rehire date - 1
4628: --
4629: UPDATE per_assignments_f
4630: SET effective_end_date = (p_rehire_date - 1)
4631: ,object_version_number = object_version_number + 1
4632: WHERE assignment_id = lr_prim_asg.assignment_id
4633: AND assignment_type <> 'B' -- 115.59

Line 4880: UPDATE per_assignments_f

4876: hr_utility.set_location(l_proc, 70);
4877: --
4878: -- Update EED to rehire date - 1
4879: --
4880: UPDATE per_assignments_f
4881: SET effective_end_date = (p_rehire_date - 1)
4882: ,object_version_number = object_version_number + 1
4883: WHERE assignment_id = lr_prim_asg.assignment_id
4884: AND assignment_type <> 'B' -- 115.59

Line 5132: UPDATE per_assignments_f

5128: --
5129: -- Update assignments where ESD > rehire date setting the
5130: -- primary flag to 'N'
5131: --
5132: UPDATE per_assignments_f
5133: SET primary_flag = 'N'
5134: ,object_version_number = object_version_number + 1
5135: WHERE assignment_id = lr_prim_asg.assignment_id
5136: AND effective_start_date > p_rehire_date;

Line 5224: FROM per_assignments_f asg

5220: ) IS
5221: SELECT asg.assignment_id
5222: ,asg.effective_start_date
5223: ,asg.effective_end_date
5224: FROM per_assignments_f asg
5225: WHERE asg.period_of_service_id = csr_prim_asg.p_period_of_service_id
5226: AND asg.person_id = csr_prim_asg.p_person_id
5227: AND csr_prim_asg.p_effective_date BETWEEN asg.effective_start_date
5228: AND asg.effective_end_date