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.GHR_MSL_PKG dependencies on PER_ASSIGNMENTS_F

Line 25: -- Main Cursor which fetches from per_assignments_f and per_people_f

21: p_mass_salary varchar2(32);
22:
23: --
24: --
25: -- Main Cursor which fetches from per_assignments_f and per_people_f
26: --
27: /***** Splitting the cursor into two for better performance
28: ***** 1. First eliminate the check of assignment_status_type_id in the cursor and have outside.
29: ***** 2. One cursor as organization as not null

Line 48: from per_assignments_f paf,

44: paf.job_id JOB_ID,
45: paf.location_id LOCATION_ID,
46: paf.organization_id ORGANIZATION_ID,
47: paf.business_group_id BUSINESS_GROUP_ID
48: from per_assignments_f paf,
49: per_people_f ppf,
50: per_person_types ppt,
51: per_assignment_status_types pas_t
52: where ppf.person_id = paf.person_id

Line 98: FROM per_assignments_f paf,

94: paf.location_id LOCATION_ID,
95: paf.organization_id ORGANIZATION_ID,
96: paf.business_group_id BUSINESS_GROUP_ID,
97: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
98: FROM per_assignments_f paf,
99: per_people_f ppf,
100: per_person_types ppt
101: WHERE ppf.person_id = paf.person_id
102: AND effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 138: FROM per_assignments_f paf,

134: paf.location_id LOCATION_ID,
135: paf.organization_id ORGANIZATION_ID,
136: paf.business_group_id BUSINESS_GROUP_ID,
137: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
138: FROM per_assignments_f paf,
139: per_people_f ppf,
140: per_person_types ppt,
141: hr_organization_units hou
142: WHERE ppf.person_id = paf.person_id

Line 197: l_assignment_id per_assignments_f.assignment_id%type;

193: where code = '894')
194: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
195: ------------- ) and update_hr_flag = 'Y';
196:
197: l_assignment_id per_assignments_f.assignment_id%type;
198: l_position_id per_assignments_f.position_id%type;
199: l_grade_id per_assignments_f.grade_id%type;
200: l_business_group_id per_assignments_f.business_group_id%type;
201:

Line 198: l_position_id per_assignments_f.position_id%type;

194: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
195: ------------- ) and update_hr_flag = 'Y';
196:
197: l_assignment_id per_assignments_f.assignment_id%type;
198: l_position_id per_assignments_f.position_id%type;
199: l_grade_id per_assignments_f.grade_id%type;
200: l_business_group_id per_assignments_f.business_group_id%type;
201:
202: l_position_title varchar2(300);

Line 199: l_grade_id per_assignments_f.grade_id%type;

195: ------------- ) and update_hr_flag = 'Y';
196:
197: l_assignment_id per_assignments_f.assignment_id%type;
198: l_position_id per_assignments_f.position_id%type;
199: l_grade_id per_assignments_f.grade_id%type;
200: l_business_group_id per_assignments_f.business_group_id%type;
201:
202: l_position_title varchar2(300);
203: l_position_number varchar2(20);

Line 200: l_business_group_id per_assignments_f.business_group_id%type;

196:
197: l_assignment_id per_assignments_f.assignment_id%type;
198: l_position_id per_assignments_f.position_id%type;
199: l_grade_id per_assignments_f.grade_id%type;
200: l_business_group_id per_assignments_f.business_group_id%type;
201:
202: l_position_title varchar2(300);
203: l_position_number varchar2(20);
204: l_position_seq_no varchar2(20);

Line 376: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE

372:
373: --
374: --
375:
376: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
377: ,p_person_id per_assignments_f.person_id%TYPE
378: ,p_position_id per_assignments_f.position_id%TYPE
379: ,p_grade_id per_assignments_f.grade_id%TYPE
380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 377: ,p_person_id per_assignments_f.person_id%TYPE

373: --
374: --
375:
376: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
377: ,p_person_id per_assignments_f.person_id%TYPE
378: ,p_position_id per_assignments_f.position_id%TYPE
379: ,p_grade_id per_assignments_f.grade_id%TYPE
380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
381: ,p_location_id per_assignments_f.location_id%TYPE

Line 378: ,p_position_id per_assignments_f.position_id%TYPE

374: --
375:
376: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
377: ,p_person_id per_assignments_f.person_id%TYPE
378: ,p_position_id per_assignments_f.position_id%TYPE
379: ,p_grade_id per_assignments_f.grade_id%TYPE
380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
381: ,p_location_id per_assignments_f.location_id%TYPE
382: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 379: ,p_grade_id per_assignments_f.grade_id%TYPE

375:
376: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
377: ,p_person_id per_assignments_f.person_id%TYPE
378: ,p_position_id per_assignments_f.position_id%TYPE
379: ,p_grade_id per_assignments_f.grade_id%TYPE
380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
381: ,p_location_id per_assignments_f.location_id%TYPE
382: ,p_organization_id per_assignments_f.organization_id%TYPE
383: ,p_date_of_birth date

Line 380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

376: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
377: ,p_person_id per_assignments_f.person_id%TYPE
378: ,p_position_id per_assignments_f.position_id%TYPE
379: ,p_grade_id per_assignments_f.grade_id%TYPE
380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
381: ,p_location_id per_assignments_f.location_id%TYPE
382: ,p_organization_id per_assignments_f.organization_id%TYPE
383: ,p_date_of_birth date
384: ,p_first_name per_people_f.first_name%TYPE

Line 381: ,p_location_id per_assignments_f.location_id%TYPE

377: ,p_person_id per_assignments_f.person_id%TYPE
378: ,p_position_id per_assignments_f.position_id%TYPE
379: ,p_grade_id per_assignments_f.grade_id%TYPE
380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
381: ,p_location_id per_assignments_f.location_id%TYPE
382: ,p_organization_id per_assignments_f.organization_id%TYPE
383: ,p_date_of_birth date
384: ,p_first_name per_people_f.first_name%TYPE
385: ,p_last_name per_people_f.last_name%TYPE

Line 382: ,p_organization_id per_assignments_f.organization_id%TYPE

378: ,p_position_id per_assignments_f.position_id%TYPE
379: ,p_grade_id per_assignments_f.grade_id%TYPE
380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
381: ,p_location_id per_assignments_f.location_id%TYPE
382: ,p_organization_id per_assignments_f.organization_id%TYPE
383: ,p_date_of_birth date
384: ,p_first_name per_people_f.first_name%TYPE
385: ,p_last_name per_people_f.last_name%TYPE
386: ,p_full_name per_people_f.full_name%TYPE

Line 403: ,p_to_grade_id IN per_assignments_f.grade_id%type

399: ,p_annuitant_indicator IN VARCHAR2
400: ,p_pay_rate_determinant IN VARCHAR2
401: ,p_work_schedule IN VARCHAR2
402: ,p_part_time_hour IN VARCHAR2
403: ,p_to_grade_id IN per_assignments_f.grade_id%type
404: ,p_pay_plan IN VARCHAR2
405: ,p_to_pay_plan IN VARCHAR2
406: ,p_pay_table_id IN NUMBER
407: ,p_grade_or_level IN VARCHAR2

Line 2151: p_position_id in per_assignments_f.position_id%type,

2147: --
2148:
2149: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2150: p_person_id in number,
2151: p_position_id in per_assignments_f.position_id%type,
2152: p_effective_date in date,
2153: p_grade_id in per_assignments_f.grade_id%type,
2154: p_assignment_id in per_assignments_f.assignment_id%type,
2155: p_action in varchar2,

Line 2153: p_grade_id in per_assignments_f.grade_id%type,

2149: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2150: p_person_id in number,
2151: p_position_id in per_assignments_f.position_id%type,
2152: p_effective_date in date,
2153: p_grade_id in per_assignments_f.grade_id%type,
2154: p_assignment_id in per_assignments_f.assignment_id%type,
2155: p_action in varchar2,
2156: p_pay_plan out nocopy varchar2,
2157: p_pay_table_id out nocopy number,

Line 2154: p_assignment_id in per_assignments_f.assignment_id%type,

2150: p_person_id in number,
2151: p_position_id in per_assignments_f.position_id%type,
2152: p_effective_date in date,
2153: p_grade_id in per_assignments_f.grade_id%type,
2154: p_assignment_id in per_assignments_f.assignment_id%type,
2155: p_action in varchar2,
2156: p_pay_plan out nocopy varchar2,
2157: p_pay_table_id out nocopy number,
2158: p_grade_or_level out nocopy varchar2,

Line 2326: p_position_id in per_assignments_f.position_id%type,

2322:
2323: -- Bug#5089732 Added p_to_grade_id,p_to_pay_plan, p_to_grade_or_level parameters.
2324: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2325: p_person_id in number,
2326: p_position_id in per_assignments_f.position_id%type,
2327: p_effective_date in date,
2328: p_grade_id in per_assignments_f.grade_id%type,
2329: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2330: p_assignment_id in per_assignments_f.assignment_id%type,

Line 2328: p_grade_id in per_assignments_f.grade_id%type,

2324: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2325: p_person_id in number,
2326: p_position_id in per_assignments_f.position_id%type,
2327: p_effective_date in date,
2328: p_grade_id in per_assignments_f.grade_id%type,
2329: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2330: p_assignment_id in per_assignments_f.assignment_id%type,
2331: p_action in varchar2,
2332: p_pay_plan out nocopy varchar2,

Line 2329: p_to_grade_id out nocopy per_assignments_f.grade_id%type,

2325: p_person_id in number,
2326: p_position_id in per_assignments_f.position_id%type,
2327: p_effective_date in date,
2328: p_grade_id in per_assignments_f.grade_id%type,
2329: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2330: p_assignment_id in per_assignments_f.assignment_id%type,
2331: p_action in varchar2,
2332: p_pay_plan out nocopy varchar2,
2333: p_to_pay_plan out nocopy varchar2,

Line 2330: p_assignment_id in per_assignments_f.assignment_id%type,

2326: p_position_id in per_assignments_f.position_id%type,
2327: p_effective_date in date,
2328: p_grade_id in per_assignments_f.grade_id%type,
2329: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2330: p_assignment_id in per_assignments_f.assignment_id%type,
2331: p_action in varchar2,
2332: p_pay_plan out nocopy varchar2,
2333: p_to_pay_plan out nocopy varchar2,
2334: p_pay_table_id out nocopy number,

Line 2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

2816: ,p_full_name IN per_people_f.full_name%TYPE
2817: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2818: --Bug # 9329643
2819: ,p_employee_number IN per_people_f.employee_number%TYPE
2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_person_id IN per_assignments_f.person_id%TYPE
2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 2821: ,p_person_id IN per_assignments_f.person_id%TYPE

2817: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2818: --Bug # 9329643
2819: ,p_employee_number IN per_people_f.employee_number%TYPE
2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_person_id IN per_assignments_f.person_id%TYPE
2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 2822: ,p_position_id IN per_assignments_f.position_id%TYPE

2818: --Bug # 9329643
2819: ,p_employee_number IN per_people_f.employee_number%TYPE
2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_person_id IN per_assignments_f.person_id%TYPE
2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE
2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE

2819: ,p_employee_number IN per_people_f.employee_number%TYPE
2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_person_id IN per_assignments_f.person_id%TYPE
2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE
2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2827: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_person_id IN per_assignments_f.person_id%TYPE
2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE
2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2827: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2828: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 2825: ,p_location_id IN per_assignments_f.location_id%TYPE

2821: ,p_person_id IN per_assignments_f.person_id%TYPE
2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE
2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2827: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2828: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2829: ,p_msl_personnel_office_id IN VARCHAR2

Line 2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE

2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE
2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2827: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2828: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2829: ,p_msl_personnel_office_id IN VARCHAR2
2830: ,p_msl_agency_code_subelement IN VARCHAR2

Line 2827: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE
2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2827: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2828: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2829: ,p_msl_personnel_office_id IN VARCHAR2
2830: ,p_msl_agency_code_subelement IN VARCHAR2
2831: ,p_msl_user_table_id IN NUMBER

Line 2845: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type

2841: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
2842: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
2843: ,p_work_schedule OUT NOCOPY VARCHAR2
2844: ,p_part_time_hour OUT NOCOPY VARCHAR2
2845: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
2846: ,p_pay_plan OUT NOCOPY VARCHAR2
2847: ,p_to_pay_plan OUT NOCOPY VARCHAR2
2848: ,p_pay_table_id OUT NOCOPY NUMBER
2849: ,p_grade_or_level OUT NOCOPY VARCHAR2

Line 2867: l_assignment_id per_assignments_f.assignment_id%TYPE;

2863: AND pay_rate_determinant = cur_prd;
2864:
2865: l_row_cnt NUMBER := 0;
2866: l_pos_grp1_rec per_position_extra_info%rowtype;
2867: l_assignment_id per_assignments_f.assignment_id%TYPE;
2868: l_person_id per_assignments_f.person_id%TYPE;
2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;
2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;

Line 2868: l_person_id per_assignments_f.person_id%TYPE;

2864:
2865: l_row_cnt NUMBER := 0;
2866: l_pos_grp1_rec per_position_extra_info%rowtype;
2867: l_assignment_id per_assignments_f.assignment_id%TYPE;
2868: l_person_id per_assignments_f.person_id%TYPE;
2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;
2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2872: l_location_id per_assignments_f.location_id%TYPE;

Line 2869: l_position_id per_assignments_f.position_id%TYPE;

2865: l_row_cnt NUMBER := 0;
2866: l_pos_grp1_rec per_position_extra_info%rowtype;
2867: l_assignment_id per_assignments_f.assignment_id%TYPE;
2868: l_person_id per_assignments_f.person_id%TYPE;
2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;
2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2872: l_location_id per_assignments_f.location_id%TYPE;
2873: l_organization_id per_assignments_f.organization_id%TYPE;

Line 2870: l_grade_id per_assignments_f.grade_id%TYPE;

2866: l_pos_grp1_rec per_position_extra_info%rowtype;
2867: l_assignment_id per_assignments_f.assignment_id%TYPE;
2868: l_person_id per_assignments_f.person_id%TYPE;
2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;
2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2872: l_location_id per_assignments_f.location_id%TYPE;
2873: l_organization_id per_assignments_f.organization_id%TYPE;
2874: l_tenure VARCHAR2(35);

Line 2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;

2867: l_assignment_id per_assignments_f.assignment_id%TYPE;
2868: l_person_id per_assignments_f.person_id%TYPE;
2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;
2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2872: l_location_id per_assignments_f.location_id%TYPE;
2873: l_organization_id per_assignments_f.organization_id%TYPE;
2874: l_tenure VARCHAR2(35);
2875: l_annuitant_indicator VARCHAR2(35);

Line 2872: l_location_id per_assignments_f.location_id%TYPE;

2868: l_person_id per_assignments_f.person_id%TYPE;
2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;
2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2872: l_location_id per_assignments_f.location_id%TYPE;
2873: l_organization_id per_assignments_f.organization_id%TYPE;
2874: l_tenure VARCHAR2(35);
2875: l_annuitant_indicator VARCHAR2(35);
2876: l_pay_rate_determinant VARCHAR2(35);

Line 2873: l_organization_id per_assignments_f.organization_id%TYPE;

2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;
2871: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2872: l_location_id per_assignments_f.location_id%TYPE;
2873: l_organization_id per_assignments_f.organization_id%TYPE;
2874: l_tenure VARCHAR2(35);
2875: l_annuitant_indicator VARCHAR2(35);
2876: l_pay_rate_determinant VARCHAR2(35);
2877: l_work_schedule VARCHAR2(35);

Line 3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

3185: ,p_full_name IN per_people_f.full_name%TYPE
3186: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3187: --Bug # 9329643
3188: ,p_employee_number IN per_people_f.employee_number%TYPE
3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3190: ,p_person_id IN per_assignments_f.person_id%TYPE
3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 3190: ,p_person_id IN per_assignments_f.person_id%TYPE

3186: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3187: --Bug # 9329643
3188: ,p_employee_number IN per_people_f.employee_number%TYPE
3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3190: ,p_person_id IN per_assignments_f.person_id%TYPE
3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 3191: ,p_position_id IN per_assignments_f.position_id%TYPE

3187: --Bug # 9329643
3188: ,p_employee_number IN per_people_f.employee_number%TYPE
3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3190: ,p_person_id IN per_assignments_f.person_id%TYPE
3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE
3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE

3188: ,p_employee_number IN per_people_f.employee_number%TYPE
3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3190: ,p_person_id IN per_assignments_f.person_id%TYPE
3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE
3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3196: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3190: ,p_person_id IN per_assignments_f.person_id%TYPE
3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE
3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3196: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3197: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 3194: ,p_location_id IN per_assignments_f.location_id%TYPE

3190: ,p_person_id IN per_assignments_f.person_id%TYPE
3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE
3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3196: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3197: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3198: ,p_msl_personnel_office_id IN VARCHAR2

Line 3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE

3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE
3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3196: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3197: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3198: ,p_msl_personnel_office_id IN VARCHAR2
3199: ,p_msl_agency_code_subelement IN VARCHAR2

Line 3196: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE
3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3196: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3197: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3198: ,p_msl_personnel_office_id IN VARCHAR2
3199: ,p_msl_agency_code_subelement IN VARCHAR2
3200: ,p_msl_user_table_id IN NUMBER

Line 3232: l_assignment_id per_assignments_f.assignment_id%TYPE;

3228: AND pay_rate_determinant = cur_prd;
3229:
3230: l_row_cnt NUMBER := 0;
3231: l_pos_grp1_rec per_position_extra_info%rowtype;
3232: l_assignment_id per_assignments_f.assignment_id%TYPE;
3233: l_person_id per_assignments_f.person_id%TYPE;
3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;

Line 3233: l_person_id per_assignments_f.person_id%TYPE;

3229:
3230: l_row_cnt NUMBER := 0;
3231: l_pos_grp1_rec per_position_extra_info%rowtype;
3232: l_assignment_id per_assignments_f.assignment_id%TYPE;
3233: l_person_id per_assignments_f.person_id%TYPE;
3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3237: l_location_id per_assignments_f.location_id%TYPE;

Line 3234: l_position_id per_assignments_f.position_id%TYPE;

3230: l_row_cnt NUMBER := 0;
3231: l_pos_grp1_rec per_position_extra_info%rowtype;
3232: l_assignment_id per_assignments_f.assignment_id%TYPE;
3233: l_person_id per_assignments_f.person_id%TYPE;
3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3237: l_location_id per_assignments_f.location_id%TYPE;
3238: l_organization_id per_assignments_f.organization_id%TYPE;

Line 3235: l_grade_id per_assignments_f.grade_id%TYPE;

3231: l_pos_grp1_rec per_position_extra_info%rowtype;
3232: l_assignment_id per_assignments_f.assignment_id%TYPE;
3233: l_person_id per_assignments_f.person_id%TYPE;
3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3237: l_location_id per_assignments_f.location_id%TYPE;
3238: l_organization_id per_assignments_f.organization_id%TYPE;
3239: l_increase_percent ghr_mass_actions_preview.increase_percent%type;

Line 3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;

3232: l_assignment_id per_assignments_f.assignment_id%TYPE;
3233: l_person_id per_assignments_f.person_id%TYPE;
3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3237: l_location_id per_assignments_f.location_id%TYPE;
3238: l_organization_id per_assignments_f.organization_id%TYPE;
3239: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
3240: l_tenure VARCHAR2(35);

Line 3237: l_location_id per_assignments_f.location_id%TYPE;

3233: l_person_id per_assignments_f.person_id%TYPE;
3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3237: l_location_id per_assignments_f.location_id%TYPE;
3238: l_organization_id per_assignments_f.organization_id%TYPE;
3239: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
3240: l_tenure VARCHAR2(35);
3241: l_annuitant_indicator VARCHAR2(35);

Line 3238: l_organization_id per_assignments_f.organization_id%TYPE;

3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3237: l_location_id per_assignments_f.location_id%TYPE;
3238: l_organization_id per_assignments_f.organization_id%TYPE;
3239: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
3240: l_tenure VARCHAR2(35);
3241: l_annuitant_indicator VARCHAR2(35);
3242: l_pay_rate_determinant VARCHAR2(35);

Line 3943: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,

3939: --
3940: --
3941: --
3942:
3943: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3944: p_effective_date in date,
3945: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3946: IS
3947:

Line 4259: (p_position_id in per_assignments_f.position_id%type,

4255: --
4256: --
4257:
4258: procedure get_sub_element_code_pos_title
4259: (p_position_id in per_assignments_f.position_id%type,
4260: p_person_id in number,
4261: p_business_group_id in per_assignments_f.business_group_id%type,
4262: p_assignment_id in per_assignments_f.assignment_id%type,
4263: p_effective_date in date,

Line 4261: p_business_group_id in per_assignments_f.business_group_id%type,

4257:
4258: procedure get_sub_element_code_pos_title
4259: (p_position_id in per_assignments_f.position_id%type,
4260: p_person_id in number,
4261: p_business_group_id in per_assignments_f.business_group_id%type,
4262: p_assignment_id in per_assignments_f.assignment_id%type,
4263: p_effective_date in date,
4264: p_sub_element_code out nocopy varchar2,
4265: p_position_title out nocopy varchar2,

Line 4262: p_assignment_id in per_assignments_f.assignment_id%type,

4258: procedure get_sub_element_code_pos_title
4259: (p_position_id in per_assignments_f.position_id%type,
4260: p_person_id in number,
4261: p_business_group_id in per_assignments_f.business_group_id%type,
4262: p_assignment_id in per_assignments_f.assignment_id%type,
4263: p_effective_date in date,
4264: p_sub_element_code out nocopy varchar2,
4265: p_position_title out nocopy varchar2,
4266: p_position_number out nocopy varchar2,

Line 4374: p_position_id in per_assignments_f.position_id%type,

4370: p_tot_old_sal in number,
4371: p_tot_new_sal in number,
4372: p_old_auo_pay in number,
4373: p_new_auo_pay in number,
4374: p_position_id in per_assignments_f.position_id%type,
4375: p_position_title in varchar2,
4376: -- FWFA Changes Bug#4444609
4377: p_position_number in varchar2,
4378: p_position_seq_no in varchar2,

Line 4979: -- Main Cursor which fetches from per_assignments_f and per_people_f

4975: p_mass_salary varchar2(32);
4976:
4977: --
4978: --
4979: -- Main Cursor which fetches from per_assignments_f and per_people_f
4980: --
4981: --
4982: --1. Cursor with organization.
4983: ---

Line 5004: from per_assignments_f paf,

5000: paf.location_id LOCATION_ID,
5001: paf.organization_id ORGANIZATION_ID,
5002: paf.business_group_id BUSINESS_GROUP_ID,
5003: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
5004: from per_assignments_f paf,
5005: per_people_f ppf,
5006: per_person_types ppt
5007: where ppf.person_id = paf.person_id
5008: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 5043: from per_assignments_f paf,

5039: paf.location_id LOCATION_ID,
5040: paf.organization_id ORGANIZATION_ID,
5041: paf.business_group_id BUSINESS_GROUP_ID,
5042: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
5043: from per_assignments_f paf,
5044: per_people_f ppf,
5045: per_person_types ppt,
5046: hr_organization_units hou
5047: where ppf.person_id = paf.person_id

Line 5101: l_assignment_id per_assignments_f.assignment_id%type;

5097: where code = '894')
5098: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99 */
5099: ------------- ) and update_hr_flag = 'Y';
5100:
5101: l_assignment_id per_assignments_f.assignment_id%type;
5102: l_position_id per_assignments_f.position_id%type;
5103: l_grade_id per_assignments_f.grade_id%type;
5104: l_business_group_id per_assignments_f.business_group_id%type;
5105:

Line 5102: l_position_id per_assignments_f.position_id%type;

5098: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99 */
5099: ------------- ) and update_hr_flag = 'Y';
5100:
5101: l_assignment_id per_assignments_f.assignment_id%type;
5102: l_position_id per_assignments_f.position_id%type;
5103: l_grade_id per_assignments_f.grade_id%type;
5104: l_business_group_id per_assignments_f.business_group_id%type;
5105:
5106: l_position_title varchar2(300);

Line 5103: l_grade_id per_assignments_f.grade_id%type;

5099: ------------- ) and update_hr_flag = 'Y';
5100:
5101: l_assignment_id per_assignments_f.assignment_id%type;
5102: l_position_id per_assignments_f.position_id%type;
5103: l_grade_id per_assignments_f.grade_id%type;
5104: l_business_group_id per_assignments_f.business_group_id%type;
5105:
5106: l_position_title varchar2(300);
5107: l_position_number varchar2(20);

Line 5104: l_business_group_id per_assignments_f.business_group_id%type;

5100:
5101: l_assignment_id per_assignments_f.assignment_id%type;
5102: l_position_id per_assignments_f.position_id%type;
5103: l_grade_id per_assignments_f.grade_id%type;
5104: l_business_group_id per_assignments_f.business_group_id%type;
5105:
5106: l_position_title varchar2(300);
5107: l_position_number varchar2(20);
5108: l_position_seq_no varchar2(20);

Line 5279: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE

5275: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5276:
5277: --
5278: --
5279: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5280: ,p_person_id per_assignments_f.person_id%TYPE
5281: ,p_position_id per_assignments_f.position_id%TYPE
5282: ,p_grade_id per_assignments_f.grade_id%TYPE
5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 5280: ,p_person_id per_assignments_f.person_id%TYPE

5276:
5277: --
5278: --
5279: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5280: ,p_person_id per_assignments_f.person_id%TYPE
5281: ,p_position_id per_assignments_f.position_id%TYPE
5282: ,p_grade_id per_assignments_f.grade_id%TYPE
5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5284: ,p_location_id per_assignments_f.location_id%TYPE

Line 5281: ,p_position_id per_assignments_f.position_id%TYPE

5277: --
5278: --
5279: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5280: ,p_person_id per_assignments_f.person_id%TYPE
5281: ,p_position_id per_assignments_f.position_id%TYPE
5282: ,p_grade_id per_assignments_f.grade_id%TYPE
5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5284: ,p_location_id per_assignments_f.location_id%TYPE
5285: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 5282: ,p_grade_id per_assignments_f.grade_id%TYPE

5278: --
5279: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5280: ,p_person_id per_assignments_f.person_id%TYPE
5281: ,p_position_id per_assignments_f.position_id%TYPE
5282: ,p_grade_id per_assignments_f.grade_id%TYPE
5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5284: ,p_location_id per_assignments_f.location_id%TYPE
5285: ,p_organization_id per_assignments_f.organization_id%TYPE
5286: ,p_date_of_birth date

Line 5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

5279: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5280: ,p_person_id per_assignments_f.person_id%TYPE
5281: ,p_position_id per_assignments_f.position_id%TYPE
5282: ,p_grade_id per_assignments_f.grade_id%TYPE
5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5284: ,p_location_id per_assignments_f.location_id%TYPE
5285: ,p_organization_id per_assignments_f.organization_id%TYPE
5286: ,p_date_of_birth date
5287: ,p_first_name per_people_f.first_name%TYPE

Line 5284: ,p_location_id per_assignments_f.location_id%TYPE

5280: ,p_person_id per_assignments_f.person_id%TYPE
5281: ,p_position_id per_assignments_f.position_id%TYPE
5282: ,p_grade_id per_assignments_f.grade_id%TYPE
5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5284: ,p_location_id per_assignments_f.location_id%TYPE
5285: ,p_organization_id per_assignments_f.organization_id%TYPE
5286: ,p_date_of_birth date
5287: ,p_first_name per_people_f.first_name%TYPE
5288: ,p_last_name per_people_f.last_name%TYPE

Line 5285: ,p_organization_id per_assignments_f.organization_id%TYPE

5281: ,p_position_id per_assignments_f.position_id%TYPE
5282: ,p_grade_id per_assignments_f.grade_id%TYPE
5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5284: ,p_location_id per_assignments_f.location_id%TYPE
5285: ,p_organization_id per_assignments_f.organization_id%TYPE
5286: ,p_date_of_birth date
5287: ,p_first_name per_people_f.first_name%TYPE
5288: ,p_last_name per_people_f.last_name%TYPE
5289: ,p_full_name per_people_f.full_name%TYPE

Line 6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

6713: ,p_mass_salary_name IN VARCHAR2
6714: ,p_full_name IN per_people_f.full_name%TYPE
6715: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6716: ,p_employee_number IN per_people_f.employee_number%TYPE
6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 6718: ,p_person_id IN per_assignments_f.person_id%TYPE

6714: ,p_full_name IN per_people_f.full_name%TYPE
6715: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6716: ,p_employee_number IN per_people_f.employee_number%TYPE
6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 6719: ,p_position_id IN per_assignments_f.position_id%TYPE

6715: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6716: ,p_employee_number IN per_people_f.employee_number%TYPE
6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE
6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE

6716: ,p_employee_number IN per_people_f.employee_number%TYPE
6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE
6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6724: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE
6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6724: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6725: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 6722: ,p_location_id IN per_assignments_f.location_id%TYPE

6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE
6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6724: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6725: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6726: ,p_msl_personnel_office_id IN VARCHAR2

Line 6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE

6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE
6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6724: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6725: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6726: ,p_msl_personnel_office_id IN VARCHAR2
6727: ,p_msl_agency_code_subelement IN VARCHAR2

Line 6724: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE
6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6724: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6725: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6726: ,p_msl_personnel_office_id IN VARCHAR2
6727: ,p_msl_agency_code_subelement IN VARCHAR2
6728: ,p_msl_user_table_id IN NUMBER

Line 6742: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type

6738: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
6739: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
6740: ,p_work_schedule OUT NOCOPY VARCHAR2
6741: ,p_part_time_hour OUT NOCOPY VARCHAR2
6742: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
6743: ,p_pay_plan OUT NOCOPY VARCHAR2
6744: ,p_to_pay_plan OUT NOCOPY VARCHAR2
6745: ,p_pay_table_id OUT NOCOPY NUMBER
6746: ,p_grade_or_level OUT NOCOPY VARCHAR2

Line 6764: l_assignment_id per_assignments_f.assignment_id%TYPE;

6760: AND pay_rate_determinant = cur_prd;
6761:
6762: l_row_cnt NUMBER := 0;
6763: l_pos_grp1_rec per_position_extra_info%rowtype;
6764: l_assignment_id per_assignments_f.assignment_id%TYPE;
6765: l_person_id per_assignments_f.person_id%TYPE;
6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;
6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;

Line 6765: l_person_id per_assignments_f.person_id%TYPE;

6761:
6762: l_row_cnt NUMBER := 0;
6763: l_pos_grp1_rec per_position_extra_info%rowtype;
6764: l_assignment_id per_assignments_f.assignment_id%TYPE;
6765: l_person_id per_assignments_f.person_id%TYPE;
6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;
6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6769: l_location_id per_assignments_f.location_id%TYPE;

Line 6766: l_position_id per_assignments_f.position_id%TYPE;

6762: l_row_cnt NUMBER := 0;
6763: l_pos_grp1_rec per_position_extra_info%rowtype;
6764: l_assignment_id per_assignments_f.assignment_id%TYPE;
6765: l_person_id per_assignments_f.person_id%TYPE;
6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;
6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6769: l_location_id per_assignments_f.location_id%TYPE;
6770: l_organization_id per_assignments_f.organization_id%TYPE;

Line 6767: l_grade_id per_assignments_f.grade_id%TYPE;

6763: l_pos_grp1_rec per_position_extra_info%rowtype;
6764: l_assignment_id per_assignments_f.assignment_id%TYPE;
6765: l_person_id per_assignments_f.person_id%TYPE;
6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;
6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6769: l_location_id per_assignments_f.location_id%TYPE;
6770: l_organization_id per_assignments_f.organization_id%TYPE;
6771: l_tenure VARCHAR2(35);

Line 6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;

6764: l_assignment_id per_assignments_f.assignment_id%TYPE;
6765: l_person_id per_assignments_f.person_id%TYPE;
6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;
6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6769: l_location_id per_assignments_f.location_id%TYPE;
6770: l_organization_id per_assignments_f.organization_id%TYPE;
6771: l_tenure VARCHAR2(35);
6772: l_annuitant_indicator VARCHAR2(35);

Line 6769: l_location_id per_assignments_f.location_id%TYPE;

6765: l_person_id per_assignments_f.person_id%TYPE;
6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;
6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6769: l_location_id per_assignments_f.location_id%TYPE;
6770: l_organization_id per_assignments_f.organization_id%TYPE;
6771: l_tenure VARCHAR2(35);
6772: l_annuitant_indicator VARCHAR2(35);
6773: l_pay_rate_determinant VARCHAR2(35);

Line 6770: l_organization_id per_assignments_f.organization_id%TYPE;

6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;
6768: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6769: l_location_id per_assignments_f.location_id%TYPE;
6770: l_organization_id per_assignments_f.organization_id%TYPE;
6771: l_tenure VARCHAR2(35);
6772: l_annuitant_indicator VARCHAR2(35);
6773: l_pay_rate_determinant VARCHAR2(35);
6774: l_work_schedule VARCHAR2(35);

Line 7118: -- Main Cursor which fetches from per_assignments_f and per_people_f

7114: p_mass_salary varchar2(32);
7115:
7116: --
7117: --
7118: -- Main Cursor which fetches from per_assignments_f and per_people_f
7119: --
7120: --
7121: --1. Cursor with organization.
7122: ---

Line 7141: from per_assignments_f paf,

7137: paf.location_id LOCATION_ID,
7138: paf.organization_id ORGANIZATION_ID,
7139: paf.business_group_id BUSINESS_GROUP_ID,
7140: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
7141: from per_assignments_f paf,
7142: per_people_f ppf,
7143: per_person_types ppt
7144: where ppf.person_id = paf.person_id
7145: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 7177: from per_assignments_f paf,

7173: paf.location_id LOCATION_ID,
7174: paf.organization_id ORGANIZATION_ID,
7175: paf.business_group_id BUSINESS_GROUP_ID,
7176: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
7177: from per_assignments_f paf,
7178: per_people_f ppf,
7179: per_person_types ppt,
7180: hr_organization_units hou
7181: where ppf.person_id = paf.person_id

Line 7237: l_assignment_id per_assignments_f.assignment_id%type;

7233: where code = '890')
7234: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
7235: ------------- ) and update_hr_flag = 'Y';
7236:
7237: l_assignment_id per_assignments_f.assignment_id%type;
7238: l_position_id per_assignments_f.position_id%type;
7239: l_grade_id per_assignments_f.grade_id%type;
7240: l_business_group_id per_assignments_f.business_group_id%type;
7241:

Line 7238: l_position_id per_assignments_f.position_id%type;

7234: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
7235: ------------- ) and update_hr_flag = 'Y';
7236:
7237: l_assignment_id per_assignments_f.assignment_id%type;
7238: l_position_id per_assignments_f.position_id%type;
7239: l_grade_id per_assignments_f.grade_id%type;
7240: l_business_group_id per_assignments_f.business_group_id%type;
7241:
7242: l_position_title varchar2(300);

Line 7239: l_grade_id per_assignments_f.grade_id%type;

7235: ------------- ) and update_hr_flag = 'Y';
7236:
7237: l_assignment_id per_assignments_f.assignment_id%type;
7238: l_position_id per_assignments_f.position_id%type;
7239: l_grade_id per_assignments_f.grade_id%type;
7240: l_business_group_id per_assignments_f.business_group_id%type;
7241:
7242: l_position_title varchar2(300);
7243: l_position_number varchar2(20);

Line 7240: l_business_group_id per_assignments_f.business_group_id%type;

7236:
7237: l_assignment_id per_assignments_f.assignment_id%type;
7238: l_position_id per_assignments_f.position_id%type;
7239: l_grade_id per_assignments_f.grade_id%type;
7240: l_business_group_id per_assignments_f.business_group_id%type;
7241:
7242: l_position_title varchar2(300);
7243: l_position_number varchar2(20);
7244: l_position_seq_no varchar2(20);

Line 7367: l_to_grade_id per_assignments_f.grade_id%type;

7363: l_comment_range VARCHAR2(150);
7364: l_comments VARCHAR2(150);
7365:
7366: -- Bug#5089732 Added current pay plan, grade_or_level
7367: l_to_grade_id per_assignments_f.grade_id%type;
7368: l_to_pay_plan varchar2(30);
7369: l_to_grade_or_level varchar2(30);
7370: -- Bug#5089732
7371:

Line 7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE

7407: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
7408: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
7409:
7410:
7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7412: ,p_person_id per_assignments_f.person_id%TYPE
7413: ,p_position_id per_assignments_f.position_id%TYPE
7414: ,p_grade_id per_assignments_f.grade_id%TYPE
7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 7412: ,p_person_id per_assignments_f.person_id%TYPE

7408: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
7409:
7410:
7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7412: ,p_person_id per_assignments_f.person_id%TYPE
7413: ,p_position_id per_assignments_f.position_id%TYPE
7414: ,p_grade_id per_assignments_f.grade_id%TYPE
7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7416: ,p_location_id per_assignments_f.location_id%TYPE

Line 7413: ,p_position_id per_assignments_f.position_id%TYPE

7409:
7410:
7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7412: ,p_person_id per_assignments_f.person_id%TYPE
7413: ,p_position_id per_assignments_f.position_id%TYPE
7414: ,p_grade_id per_assignments_f.grade_id%TYPE
7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7416: ,p_location_id per_assignments_f.location_id%TYPE
7417: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 7414: ,p_grade_id per_assignments_f.grade_id%TYPE

7410:
7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7412: ,p_person_id per_assignments_f.person_id%TYPE
7413: ,p_position_id per_assignments_f.position_id%TYPE
7414: ,p_grade_id per_assignments_f.grade_id%TYPE
7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7416: ,p_location_id per_assignments_f.location_id%TYPE
7417: ,p_organization_id per_assignments_f.organization_id%TYPE
7418: ,p_date_of_birth date

Line 7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7412: ,p_person_id per_assignments_f.person_id%TYPE
7413: ,p_position_id per_assignments_f.position_id%TYPE
7414: ,p_grade_id per_assignments_f.grade_id%TYPE
7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7416: ,p_location_id per_assignments_f.location_id%TYPE
7417: ,p_organization_id per_assignments_f.organization_id%TYPE
7418: ,p_date_of_birth date
7419: ,p_first_name per_people_f.first_name%TYPE

Line 7416: ,p_location_id per_assignments_f.location_id%TYPE

7412: ,p_person_id per_assignments_f.person_id%TYPE
7413: ,p_position_id per_assignments_f.position_id%TYPE
7414: ,p_grade_id per_assignments_f.grade_id%TYPE
7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7416: ,p_location_id per_assignments_f.location_id%TYPE
7417: ,p_organization_id per_assignments_f.organization_id%TYPE
7418: ,p_date_of_birth date
7419: ,p_first_name per_people_f.first_name%TYPE
7420: ,p_last_name per_people_f.last_name%TYPE

Line 7417: ,p_organization_id per_assignments_f.organization_id%TYPE

7413: ,p_position_id per_assignments_f.position_id%TYPE
7414: ,p_grade_id per_assignments_f.grade_id%TYPE
7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7416: ,p_location_id per_assignments_f.location_id%TYPE
7417: ,p_organization_id per_assignments_f.organization_id%TYPE
7418: ,p_date_of_birth date
7419: ,p_first_name per_people_f.first_name%TYPE
7420: ,p_last_name per_people_f.last_name%TYPE
7421: ,p_full_name per_people_f.full_name%TYPE

Line 7438: ,p_to_grade_id IN per_assignments_f.grade_id%type

7434: ,p_annuitant_indicator IN VARCHAR2
7435: ,p_pay_rate_determinant IN VARCHAR2
7436: ,p_work_schedule IN VARCHAR2
7437: ,p_part_time_hour IN VARCHAR2
7438: ,p_to_grade_id IN per_assignments_f.grade_id%type
7439: ,p_pay_plan IN VARCHAR2
7440: ,p_to_pay_plan IN VARCHAR2
7441: ,p_pay_table_id IN NUMBER
7442: ,p_grade_or_level IN VARCHAR2