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 124: l_primary_asg per_all_assignments_f.assignment_id%type;

120: --fix for bug 7119614 ends here.
121: --
122: -- Bug 14596826
123:
124: l_primary_asg per_all_assignments_f.assignment_id%type;
125:
126: cursor prim_asg is
127: select assignment_id
128: from per_all_assignments_f

Line 128: from per_all_assignments_f

124: l_primary_asg per_all_assignments_f.assignment_id%type;
125:
126: cursor prim_asg is
127: select assignment_id
128: from per_all_assignments_f
129: where person_id = p_person_id
130: and business_group_id = p_business_group_id
131: and primary_flag = 'Y'
132: and p_start_date between effective_start_date and effective_end_date;

Line 137: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is

133:
134: l_proposal_id per_pay_proposals.pay_proposal_id%type;
135: l_proposal_exists varchar2(1);
136:
137: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
138: select pay_proposal_id
139: from per_pay_proposals
140: where assignment_id=ass_id
141: and APPROVED='Y';

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

694:
695:
696: --added by amigarg for bug 4882512 start
697:
698: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
699: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
700: from per_pay_proposals
701: where assignment_id=ass_id
702: and approved = 'N'

Line 2744: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;

2740: where application_id = 800 -- bug 5469726
2741: and descriptive_flexfield_name = 'PER_ASSIGNMENTS';
2742: --
2743: -- VT 06/14/00
2744: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2745: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2746: --
2747: cursor cur_apl_asg is
2748: select * from per_all_assignments_f paf

Line 2745: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;

2741: and descriptive_flexfield_name = 'PER_ASSIGNMENTS';
2742: --
2743: -- VT 06/14/00
2744: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2745: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2746: --
2747: cursor cur_apl_asg is
2748: select * from per_all_assignments_f paf
2749: where paf.assignment_id = p_new_primary_id

Line 2748: select * from per_all_assignments_f paf

2744: apl_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2745: emp_asg_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
2746: --
2747: cursor cur_apl_asg is
2748: select * from per_all_assignments_f paf
2749: where paf.assignment_id = p_new_primary_id
2750: and paf.business_group_id +0 = p_business_group_id
2751: and p_start_date between paf.effective_start_date
2752: and paf.effective_end_date;

Line 2755: select * from per_all_assignments_f paf

2751: and p_start_date between paf.effective_start_date
2752: and paf.effective_end_date;
2753: --
2754: cursor cur_emp_asg is
2755: select * from per_all_assignments_f paf
2756: where paf.person_id = p_person_id
2757: and paf.business_group_id +0 = p_business_group_id
2758: -- #1981550
2759: and paf.primary_flag = 'Y'

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

2772:
2773:
2774: -- Added for the bug 6512520 starts here
2775:
2776: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
2777: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2778: from per_pay_proposals
2779: where assignment_id=ass_id
2780: and approved = 'N'

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

2779: where assignment_id=ass_id
2780: and approved = 'N'
2781: order by change_date desc;
2782:
2783: cursor get_pay_proposal_emp(ass_id per_all_assignments_f.assignment_id%type) is
2784: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2785: from per_pay_proposals
2786: where assignment_id=ass_id
2787: and approved = 'N'

Line 2831: from per_all_assignments_f

2827: OR p_start_date < pac.effective_date));
2828:
2829: Cursor cur_pri_asg_info(lp_assignment_id number) is
2830: select object_version_number
2831: from per_all_assignments_f
2832: where person_id = p_person_id
2833: and assignment_id = lp_assignment_id
2834: and p_start_date between effective_start_date and effective_end_date;
2835:

Line 2838: from per_all_assignments_f paaf

2834: and p_start_date between effective_start_date and effective_end_date;
2835:
2836: Cursor cur_get_future_asgs(lp_assignment_id number) is
2837: select paaf.effective_start_date
2838: from per_all_assignments_f paaf
2839: where paaf.business_group_id = p_business_group_id
2840: and paaf.person_id = p_person_id
2841: and paaf.primary_flag = 'Y'
2842: and paaf.assignment_type = 'E'

Line 2849: from per_all_assignments_f paaf

2845: order by paaf.effective_start_date;
2846:
2847: Cursor cur_get_asg_num(lp_assignment_id number) is
2848: select paaf.assignment_number
2849: from per_all_assignments_f paaf
2850: where paaf.business_group_id = p_business_group_id
2851: and paaf.person_id = p_person_id
2852: and paaf.primary_flag = 'Y'
2853: and paaf.assignment_type = 'E'

Line 2857: l_effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;

2853: and paaf.assignment_type = 'E'
2854: and paaf.assignment_id = lp_assignment_id
2855: order by paaf.effective_start_date;
2856:
2857: l_effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;
2858: l_effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%type;
2859: l_object_version_number PER_ALL_ASSIGNMENTS_F.object_version_number%type;
2860: l_dummy VARCHAR2(1);
2861: l_asg_num PER_ALL_ASSIGNMENTS_F.assignment_number%type;

Line 2858: l_effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%type;

2854: and paaf.assignment_id = lp_assignment_id
2855: order by paaf.effective_start_date;
2856:
2857: l_effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;
2858: l_effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%type;
2859: l_object_version_number PER_ALL_ASSIGNMENTS_F.object_version_number%type;
2860: l_dummy VARCHAR2(1);
2861: l_asg_num PER_ALL_ASSIGNMENTS_F.assignment_number%type;
2862: l_chg_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;

Line 2859: l_object_version_number PER_ALL_ASSIGNMENTS_F.object_version_number%type;

2855: order by paaf.effective_start_date;
2856:
2857: l_effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;
2858: l_effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%type;
2859: l_object_version_number PER_ALL_ASSIGNMENTS_F.object_version_number%type;
2860: l_dummy VARCHAR2(1);
2861: l_asg_num PER_ALL_ASSIGNMENTS_F.assignment_number%type;
2862: l_chg_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;
2863: -- End changes for bug 9644377

Line 2861: l_asg_num PER_ALL_ASSIGNMENTS_F.assignment_number%type;

2857: l_effective_start_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;
2858: l_effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%type;
2859: l_object_version_number PER_ALL_ASSIGNMENTS_F.object_version_number%type;
2860: l_dummy VARCHAR2(1);
2861: l_asg_num PER_ALL_ASSIGNMENTS_F.assignment_number%type;
2862: l_chg_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;
2863: -- End changes for bug 9644377
2864:
2865: -- Bug 14551643

Line 2862: l_chg_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;

2858: l_effective_end_date PER_ALL_ASSIGNMENTS_F.effective_end_date%type;
2859: l_object_version_number PER_ALL_ASSIGNMENTS_F.object_version_number%type;
2860: l_dummy VARCHAR2(1);
2861: l_asg_num PER_ALL_ASSIGNMENTS_F.assignment_number%type;
2862: l_chg_date PER_ALL_ASSIGNMENTS_F.effective_start_date%type;
2863: -- End changes for bug 9644377
2864:
2865: -- Bug 14551643
2866: l_rowid rowid;

Line 2869: FROM per_all_assignments_f

2865: -- Bug 14551643
2866: l_rowid rowid;
2867: CURSOR emp_asg IS
2868: SELECT rowid
2869: FROM per_all_assignments_f
2870: WHERE person_id = p_person_id
2871: AND effective_start_date = p_start_date
2872: AND business_group_id = p_business_group_id
2873: AND primary_flag = 'Y'

Line 2880: FROM per_all_assignments_f

2876:
2877:
2878: CURSOR apl_asg IS
2879: SELECT *
2880: FROM per_all_assignments_f
2881: WHERE assignment_type = 'A'
2882: AND person_id = p_person_id
2883: AND business_group_id = p_business_group_id
2884: AND effective_start_date < p_start_date

Line 3052: /* update per_all_assignments_f pa

3048: --
3049: -- Changed the value for set_of_books_if from p_set_of_books_id to
3050: -- emp_asg_rec.set_of_books_id bug #2398327
3051:
3052: /* update per_all_assignments_f pa
3053: set pa.primary_flag = 'Y'
3054: , pa.effective_start_date = p_start_date
3055: , pa.effective_end_date = p_end_of_time
3056: , pa.set_of_books_id = emp_asg_rec.set_of_books_id

Line 3074: update per_all_assignments_f pa

3070:
3071: -- Start changes for bug 9644377
3072: if p_update_primary_flag = 'C' and p_emp_apl = 'Y' then
3073:
3074: update per_all_assignments_f pa
3075: set pa.effective_start_date = p_start_date
3076: , pa.effective_end_date = p_end_of_time
3077: , pa.set_of_books_id = emp_asg_rec.set_of_books_id
3078: , pa.change_reason = null

Line 3105: update per_all_assignments_f pa

3101: );
3102:
3103: else
3104:
3105: update per_all_assignments_f pa
3106: set pa.primary_flag = 'Y'
3107: , pa.effective_start_date = p_start_date
3108: , pa.effective_end_date = p_end_of_time
3109: , pa.set_of_books_id = emp_asg_rec.set_of_books_id

Line 3240: l_prev_location_id per_all_assignments_f.location_id%type;

3236: and pa.effective_end_date
3237: for update of pa.organization_id;
3238:
3239: -- variables l_prev_location_id, p_old_assignment_id, l_assignment_type added by sneelapa for bug 6409982
3240: l_prev_location_id per_all_assignments_f.location_id%type;
3241: p_old_assignment_id per_all_assignments_f.assignment_id%type;
3242: l_assignment_type per_all_assignments_f.assignment_type%type;
3243:
3244: -- cursor cur_asg_type is declared by sneelapa for bug 6409982

Line 3241: p_old_assignment_id per_all_assignments_f.assignment_id%type;

3237: for update of pa.organization_id;
3238:
3239: -- variables l_prev_location_id, p_old_assignment_id, l_assignment_type added by sneelapa for bug 6409982
3240: l_prev_location_id per_all_assignments_f.location_id%type;
3241: p_old_assignment_id per_all_assignments_f.assignment_id%type;
3242: l_assignment_type per_all_assignments_f.assignment_type%type;
3243:
3244: -- cursor cur_asg_type is declared by sneelapa for bug 6409982
3245: cursor cur_asg_type is

Line 3242: l_assignment_type per_all_assignments_f.assignment_type%type;

3238:
3239: -- variables l_prev_location_id, p_old_assignment_id, l_assignment_type added by sneelapa for bug 6409982
3240: l_prev_location_id per_all_assignments_f.location_id%type;
3241: p_old_assignment_id per_all_assignments_f.assignment_id%type;
3242: l_assignment_type per_all_assignments_f.assignment_type%type;
3243:
3244: -- cursor cur_asg_type is declared by sneelapa for bug 6409982
3245: cursor cur_asg_type is
3246: select assignment_type

Line 3247: from per_all_assignments_f paf

3243:
3244: -- cursor cur_asg_type is declared by sneelapa for bug 6409982
3245: cursor cur_asg_type is
3246: select assignment_type
3247: from per_all_assignments_f paf
3248: where paf.assignment_id = p_old_assignment_id;
3249:
3250: --
3251: -- #1769702

Line 4718: l_asg_rec per_all_assignments_f%rowtype;

4714: --
4715: --start WWBUG 2130950 hrwf synchronization --tpapired
4716: --
4717: declare
4718: l_asg_rec per_all_assignments_f%rowtype;
4719: cursor asg_cur is select *
4720: from per_all_assignments_f
4721: where primary_flag ='Y'
4722: and assignment_type = 'E'

Line 4720: from per_all_assignments_f

4716: --
4717: declare
4718: l_asg_rec per_all_assignments_f%rowtype;
4719: cursor asg_cur is select *
4720: from per_all_assignments_f
4721: where primary_flag ='Y'
4722: and assignment_type = 'E'
4723: and person_id = p_person_id
4724: and business_group_id + 0 = p_business_group_id

Line 4746: l_asg_probation_det per_all_assignments_f%rowtype;

4742: -- approval
4743:
4744: declare
4745:
4746: l_asg_probation_det per_all_assignments_f%rowtype;
4747: cursor asg_cur is select *
4748: from per_all_assignments_f
4749: where
4750: assignment_type = 'E'

Line 4748: from per_all_assignments_f

4744: declare
4745:
4746: l_asg_probation_det per_all_assignments_f%rowtype;
4747: cursor asg_cur is select *
4748: from per_all_assignments_f
4749: where
4750: assignment_type = 'E'
4751: and person_id = p_person_id
4752: and business_group_id + 0 = p_business_group_id

Line 4801: update per_all_assignments_f

4797: );
4798: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);
4799:
4800:
4801: update per_all_assignments_f
4802: set date_probation_end =l_date_probation_end
4803: where
4804: assignment_type = 'E'
4805: and person_id = p_person_id

Line 4860: from per_all_assignments_f pa

4856: --
4857: cursor ass_cur is
4858: select pa.assignment_id
4859: , pa.effective_start_date
4860: from per_all_assignments_f pa
4861: , per_assignment_status_types past
4862: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
4863: and pa.person_id = p_person_id
4864: and pa.business_group_id + 0 = p_business_group_id