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 2868: -- The l_assignment_id is declared as per_assignments_f.assignment_id%type.

2864: --
2865: -- Added local variables for after hook re_hire_ex_employee_a
2866: --
2867: -- Bug 1828850 starts here.
2868: -- The l_assignment_id is declared as per_assignments_f.assignment_id%type.
2869: --
2870: l_assignment_id per_assignments_f.assignment_id%type;
2871: --
2872: -- Bug 1828850 Ends here.

Line 2870: l_assignment_id per_assignments_f.assignment_id%type;

2866: --
2867: -- Bug 1828850 starts here.
2868: -- The l_assignment_id is declared as per_assignments_f.assignment_id%type.
2869: --
2870: l_assignment_id per_assignments_f.assignment_id%type;
2871: --
2872: -- Bug 1828850 Ends here.
2873: --
2874: l_asg_object_version_number number(9);

Line 3616: l_comment_id per_assignments_f.comment_id%type;

3612: l_legislation_code per_business_groups.legislation_code%type;
3613: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3614: l_person_type_id1 per_people_f.person_type_id%type;
3615: l_application_id per_applications.application_id%type;
3616: l_comment_id per_assignments_f.comment_id%type;
3617: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3618: l_assignment_id per_assignments_f.assignment_id%type;
3619: l_object_version_number per_assignments_f.object_version_number%type;
3620: l_current_applicant_flag per_people_f.current_applicant_flag%type;

Line 3617: l_assignment_sequence per_assignments_f.assignment_sequence%type;

3613: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3614: l_person_type_id1 per_people_f.person_type_id%type;
3615: l_application_id per_applications.application_id%type;
3616: l_comment_id per_assignments_f.comment_id%type;
3617: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3618: l_assignment_id per_assignments_f.assignment_id%type;
3619: l_object_version_number per_assignments_f.object_version_number%type;
3620: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3621: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

Line 3618: l_assignment_id per_assignments_f.assignment_id%type;

3614: l_person_type_id1 per_people_f.person_type_id%type;
3615: l_application_id per_applications.application_id%type;
3616: l_comment_id per_assignments_f.comment_id%type;
3617: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3618: l_assignment_id per_assignments_f.assignment_id%type;
3619: l_object_version_number per_assignments_f.object_version_number%type;
3620: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3621: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3622: l_current_employee_flag per_people_f.current_employee_flag%type;

Line 3619: l_object_version_number per_assignments_f.object_version_number%type;

3615: l_application_id per_applications.application_id%type;
3616: l_comment_id per_assignments_f.comment_id%type;
3617: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3618: l_assignment_id per_assignments_f.assignment_id%type;
3619: l_object_version_number per_assignments_f.object_version_number%type;
3620: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3621: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3622: l_current_employee_flag per_people_f.current_employee_flag%type;
3623: l_employee_number per_people_f.employee_number%type;

Line 4891: FROM per_assignments_f

4887: ,assignment_category
4888: ,project_title
4889: ,grade_ladder_pgm_id
4890: ,supervisor_assignment_id
4891: FROM per_assignments_f
4892: WHERE person_id = c_prim_asg.p_person_id
4893: AND primary_flag = 'Y'
4894: AND assignment_type <> 'B' -- 115.59
4895: AND c_prim_asg.p_effective_date BETWEEN effective_start_date

Line 4931: UPDATE per_assignments_f

4927: --
4928: -- Update all assignments records for this assignment with
4929: -- ESD >= rehire date setting primary flag to 'Y'
4930: --
4931: UPDATE per_assignments_f
4932: SET primary_flag = 'Y'
4933: ,object_version_number = object_version_number + 1
4934: WHERE assignment_id = lr_prim_asg.assignment_id
4935: AND assignment_type <> 'B' -- 115.59

Line 4962: UPDATE per_assignments_f

4958: hr_utility.set_location(l_proc, 40);
4959: --
4960: -- Set the primary assignment flag to 'N' for this record.
4961: --
4962: UPDATE per_assignments_f
4963: SET primary_flag = 'N'
4964: ,object_version_number = object_version_number + 1
4965: WHERE assignment_id = lr_prim_asg.assignment_id
4966: AND assignment_type <> 'B' -- 115.59

Line 4975: UPDATE per_assignments_f

4971: hr_utility.set_location(l_proc, 50);
4972: --
4973: -- Update EED to rehire date - 1
4974: --
4975: UPDATE per_assignments_f
4976: SET effective_end_date = (p_rehire_date - 1)
4977: ,object_version_number = object_version_number + 1
4978: WHERE assignment_id = lr_prim_asg.assignment_id
4979: AND assignment_type <> 'B' -- 115.59

Line 5226: UPDATE per_assignments_f

5222: hr_utility.set_location(l_proc, 70);
5223: --
5224: -- Update EED to rehire date - 1
5225: --
5226: UPDATE per_assignments_f
5227: SET effective_end_date = (p_rehire_date - 1)
5228: ,object_version_number = object_version_number + 1
5229: WHERE assignment_id = lr_prim_asg.assignment_id
5230: AND assignment_type <> 'B' -- 115.59

Line 5478: UPDATE per_assignments_f

5474: --
5475: -- Update assignments where ESD > rehire date setting the
5476: -- primary flag to 'N'
5477: --
5478: UPDATE per_assignments_f
5479: SET primary_flag = 'N'
5480: ,object_version_number = object_version_number + 1
5481: WHERE assignment_id = lr_prim_asg.assignment_id
5482: AND effective_start_date > p_rehire_date;

Line 5570: FROM per_assignments_f asg

5566: ) IS
5567: SELECT asg.assignment_id
5568: ,asg.effective_start_date
5569: ,asg.effective_end_date
5570: FROM per_assignments_f asg
5571: WHERE asg.period_of_service_id = csr_prim_asg.p_period_of_service_id
5572: AND asg.person_id = csr_prim_asg.p_person_id
5573: AND csr_prim_asg.p_effective_date BETWEEN asg.effective_start_date
5574: AND asg.effective_end_date