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.HRHIRAPL dependencies on PER_ALL_ASSIGNMENTS_F

Line 675: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is

671:
672:
673: --added by amigarg for bug 4882512 start
674:
675: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
676: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
677: from per_pay_proposals
678: where assignment_id=ass_id
679: and approved = 'N'

Line 2640: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;

2636: where application_id = 800 -- bug 5469726
2637: and descriptive_flexfield_name = 'PER_ASSIGNMENTS';
2638: --
2639: -- VT 06/14/00
2640: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2641: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2642: --
2643: cursor cur_apl_asg is
2644: select * from per_all_assignments_f paf

Line 2641: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;

2637: and descriptive_flexfield_name = 'PER_ASSIGNMENTS';
2638: --
2639: -- VT 06/14/00
2640: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2641: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2642: --
2643: cursor cur_apl_asg is
2644: select * from per_all_assignments_f paf
2645: where paf.assignment_id = p_new_primary_id

Line 2644: select * from per_all_assignments_f paf

2640: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2641: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2642: --
2643: cursor cur_apl_asg is
2644: select * from per_all_assignments_f paf
2645: where paf.assignment_id = p_new_primary_id
2646: and paf.business_group_id +0 = p_business_group_id
2647: and p_start_date between paf.effective_start_date
2648: and paf.effective_end_date;

Line 2651: select * from per_all_assignments_f paf

2647: and p_start_date between paf.effective_start_date
2648: and paf.effective_end_date;
2649: --
2650: cursor cur_emp_asg is
2651: select * from per_all_assignments_f paf
2652: where paf.person_id = p_person_id
2653: and paf.business_group_id +0 = p_business_group_id
2654: -- #1981550
2655: and paf.primary_flag = 'Y'

Line 2672: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is

2668:
2669:
2670: -- Added for the bug 6512520 starts here
2671:
2672: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
2673: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2674: from per_pay_proposals
2675: where assignment_id=ass_id
2676: and approved = 'N'

Line 2679: cursor get_pay_proposal_emp(ass_id per_all_assignments_f.assignment_id%type) is

2675: where assignment_id=ass_id
2676: and approved = 'N'
2677: order by change_date desc;
2678:
2679: cursor get_pay_proposal_emp(ass_id per_all_assignments_f.assignment_id%type) is
2680: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2681: from per_pay_proposals
2682: where assignment_id=ass_id
2683: and approved = 'N'

Line 2826: update per_all_assignments_f pa

2822: --
2823: -- Changed the value for set_of_books_if from p_set_of_books_id to
2824: -- emp_asg_rec.set_of_books_id bug #2398327
2825:
2826: update per_all_assignments_f pa
2827: set pa.primary_flag = 'Y'
2828: , pa.effective_start_date = p_start_date
2829: , pa.effective_end_date = p_end_of_time
2830: , pa.set_of_books_id = emp_asg_rec.set_of_books_id

Line 2892: l_prev_location_id per_all_assignments_f.location_id%type;

2888: and pa.effective_end_date
2889: for update of pa.organization_id;
2890:
2891: -- variables l_prev_location_id, p_old_assignment_id, l_assignment_type added by sneelapa for bug 6409982
2892: l_prev_location_id per_all_assignments_f.location_id%type;
2893: p_old_assignment_id per_all_assignments_f.assignment_id%type;
2894: l_assignment_type per_all_assignments_f.assignment_type%type;
2895:
2896: -- cursor cur_asg_type is declared by sneelapa for bug 6409982

Line 2893: p_old_assignment_id per_all_assignments_f.assignment_id%type;

2889: for update of pa.organization_id;
2890:
2891: -- variables l_prev_location_id, p_old_assignment_id, l_assignment_type added by sneelapa for bug 6409982
2892: l_prev_location_id per_all_assignments_f.location_id%type;
2893: p_old_assignment_id per_all_assignments_f.assignment_id%type;
2894: l_assignment_type per_all_assignments_f.assignment_type%type;
2895:
2896: -- cursor cur_asg_type is declared by sneelapa for bug 6409982
2897: cursor cur_asg_type is

Line 2894: l_assignment_type per_all_assignments_f.assignment_type%type;

2890:
2891: -- variables l_prev_location_id, p_old_assignment_id, l_assignment_type added by sneelapa for bug 6409982
2892: l_prev_location_id per_all_assignments_f.location_id%type;
2893: p_old_assignment_id per_all_assignments_f.assignment_id%type;
2894: l_assignment_type per_all_assignments_f.assignment_type%type;
2895:
2896: -- cursor cur_asg_type is declared by sneelapa for bug 6409982
2897: cursor cur_asg_type is
2898: select assignment_type

Line 2899: from per_all_assignments_f paf

2895:
2896: -- cursor cur_asg_type is declared by sneelapa for bug 6409982
2897: cursor cur_asg_type is
2898: select assignment_type
2899: from per_all_assignments_f paf
2900: where paf.assignment_id = p_old_assignment_id;
2901:
2902: --
2903: -- #1769702

Line 4113: l_asg_rec per_all_assignments_f%rowtype;

4109: --
4110: --start WWBUG 2130950 hrwf synchronization --tpapired
4111: --
4112: declare
4113: l_asg_rec per_all_assignments_f%rowtype;
4114: cursor asg_cur is select *
4115: from per_all_assignments_f
4116: where primary_flag ='Y'
4117: and assignment_type = 'E'

Line 4115: from per_all_assignments_f

4111: --
4112: declare
4113: l_asg_rec per_all_assignments_f%rowtype;
4114: cursor asg_cur is select *
4115: from per_all_assignments_f
4116: where primary_flag ='Y'
4117: and assignment_type = 'E'
4118: and person_id = p_person_id
4119: and business_group_id + 0 = p_business_group_id

Line 4141: l_asg_probation_det per_all_assignments_f%rowtype;

4137: -- approval
4138:
4139: declare
4140:
4141: l_asg_probation_det per_all_assignments_f%rowtype;
4142: cursor asg_cur is select *
4143: from per_all_assignments_f
4144: where
4145: assignment_type = 'E'

Line 4143: from per_all_assignments_f

4139: declare
4140:
4141: l_asg_probation_det per_all_assignments_f%rowtype;
4142: cursor asg_cur is select *
4143: from per_all_assignments_f
4144: where
4145: assignment_type = 'E'
4146: and person_id = p_person_id
4147: and business_group_id + 0 = p_business_group_id

Line 4196: update per_all_assignments_f

4192: );
4193: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);
4194:
4195:
4196: update per_all_assignments_f
4197: set date_probation_end =l_date_probation_end
4198: where
4199: assignment_type = 'E'
4200: and person_id = p_person_id

Line 4255: from per_all_assignments_f pa

4251: --
4252: cursor ass_cur is
4253: select pa.assignment_id
4254: , pa.effective_start_date
4255: from per_all_assignments_f pa
4256: , per_assignment_status_types past
4257: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
4258: and pa.person_id = p_person_id
4259: and pa.business_group_id + 0 = p_business_group_id