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 96: FROM per_assignments_f paf,

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

Line 134: FROM per_assignments_f paf,

130: paf.location_id LOCATION_ID,
131: paf.organization_id ORGANIZATION_ID,
132: paf.business_group_id BUSINESS_GROUP_ID,
133: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
134: FROM per_assignments_f paf,
135: per_people_f ppf,
136: per_person_types ppt,
137: hr_organization_units hou
138: WHERE ppf.person_id = paf.person_id

Line 193: l_assignment_id per_assignments_f.assignment_id%type;

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

Line 194: l_position_id per_assignments_f.position_id%type;

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

Line 195: l_grade_id per_assignments_f.grade_id%type;

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

Line 196: l_business_group_id per_assignments_f.business_group_id%type;

192:
193: l_assignment_id per_assignments_f.assignment_id%type;
194: l_position_id per_assignments_f.position_id%type;
195: l_grade_id per_assignments_f.grade_id%type;
196: l_business_group_id per_assignments_f.business_group_id%type;
197:
198: l_position_title varchar2(300);
199: l_position_number varchar2(20);
200: l_position_seq_no varchar2(20);

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

368:
369: --
370: --
371:
372: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
373: ,p_person_id per_assignments_f.person_id%TYPE
374: ,p_position_id per_assignments_f.position_id%TYPE
375: ,p_grade_id per_assignments_f.grade_id%TYPE
376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 373: ,p_person_id per_assignments_f.person_id%TYPE

369: --
370: --
371:
372: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
373: ,p_person_id per_assignments_f.person_id%TYPE
374: ,p_position_id per_assignments_f.position_id%TYPE
375: ,p_grade_id per_assignments_f.grade_id%TYPE
376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
377: ,p_location_id per_assignments_f.location_id%TYPE

Line 374: ,p_position_id per_assignments_f.position_id%TYPE

370: --
371:
372: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
373: ,p_person_id per_assignments_f.person_id%TYPE
374: ,p_position_id per_assignments_f.position_id%TYPE
375: ,p_grade_id per_assignments_f.grade_id%TYPE
376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
377: ,p_location_id per_assignments_f.location_id%TYPE
378: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 375: ,p_grade_id per_assignments_f.grade_id%TYPE

371:
372: PROCEDURE msl_process( p_assignment_id per_assignments_f.assignment_id%TYPE
373: ,p_person_id per_assignments_f.person_id%TYPE
374: ,p_position_id per_assignments_f.position_id%TYPE
375: ,p_grade_id per_assignments_f.grade_id%TYPE
376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
377: ,p_location_id per_assignments_f.location_id%TYPE
378: ,p_organization_id per_assignments_f.organization_id%TYPE
379: ,p_date_of_birth date

Line 376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

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

Line 377: ,p_location_id per_assignments_f.location_id%TYPE

373: ,p_person_id per_assignments_f.person_id%TYPE
374: ,p_position_id per_assignments_f.position_id%TYPE
375: ,p_grade_id per_assignments_f.grade_id%TYPE
376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
377: ,p_location_id per_assignments_f.location_id%TYPE
378: ,p_organization_id per_assignments_f.organization_id%TYPE
379: ,p_date_of_birth date
380: ,p_first_name per_people_f.first_name%TYPE
381: ,p_last_name per_people_f.last_name%TYPE

Line 378: ,p_organization_id per_assignments_f.organization_id%TYPE

374: ,p_position_id per_assignments_f.position_id%TYPE
375: ,p_grade_id per_assignments_f.grade_id%TYPE
376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
377: ,p_location_id per_assignments_f.location_id%TYPE
378: ,p_organization_id per_assignments_f.organization_id%TYPE
379: ,p_date_of_birth date
380: ,p_first_name per_people_f.first_name%TYPE
381: ,p_last_name per_people_f.last_name%TYPE
382: ,p_full_name per_people_f.full_name%TYPE

Line 397: ,p_to_grade_id IN per_assignments_f.grade_id%type

393: ,p_annuitant_indicator IN VARCHAR2
394: ,p_pay_rate_determinant IN VARCHAR2
395: ,p_work_schedule IN VARCHAR2
396: ,p_part_time_hour IN VARCHAR2
397: ,p_to_grade_id IN per_assignments_f.grade_id%type
398: ,p_pay_plan IN VARCHAR2
399: ,p_to_pay_plan IN VARCHAR2
400: ,p_pay_table_id IN NUMBER
401: ,p_grade_or_level IN VARCHAR2

Line 2123: p_position_id in per_assignments_f.position_id%type,

2119: --
2120:
2121: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2122: p_person_id in number,
2123: p_position_id in per_assignments_f.position_id%type,
2124: p_effective_date in date,
2125: p_grade_id in per_assignments_f.grade_id%type,
2126: p_assignment_id in per_assignments_f.assignment_id%type,
2127: p_action in varchar2,

Line 2125: p_grade_id in per_assignments_f.grade_id%type,

2121: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2122: p_person_id in number,
2123: p_position_id in per_assignments_f.position_id%type,
2124: p_effective_date in date,
2125: p_grade_id in per_assignments_f.grade_id%type,
2126: p_assignment_id in per_assignments_f.assignment_id%type,
2127: p_action in varchar2,
2128: p_pay_plan out nocopy varchar2,
2129: p_pay_table_id out nocopy number,

Line 2126: p_assignment_id in per_assignments_f.assignment_id%type,

2122: p_person_id in number,
2123: p_position_id in per_assignments_f.position_id%type,
2124: p_effective_date in date,
2125: p_grade_id in per_assignments_f.grade_id%type,
2126: p_assignment_id in per_assignments_f.assignment_id%type,
2127: p_action in varchar2,
2128: p_pay_plan out nocopy varchar2,
2129: p_pay_table_id out nocopy number,
2130: p_grade_or_level out nocopy varchar2,

Line 2298: p_position_id in per_assignments_f.position_id%type,

2294:
2295: -- Bug#5089732 Added p_to_grade_id,p_to_pay_plan, p_to_grade_or_level parameters.
2296: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2297: p_person_id in number,
2298: p_position_id in per_assignments_f.position_id%type,
2299: p_effective_date in date,
2300: p_grade_id in per_assignments_f.grade_id%type,
2301: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2302: p_assignment_id in per_assignments_f.assignment_id%type,

Line 2300: p_grade_id in per_assignments_f.grade_id%type,

2296: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
2297: p_person_id in number,
2298: p_position_id in per_assignments_f.position_id%type,
2299: p_effective_date in date,
2300: p_grade_id in per_assignments_f.grade_id%type,
2301: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2302: p_assignment_id in per_assignments_f.assignment_id%type,
2303: p_action in varchar2,
2304: p_pay_plan out nocopy varchar2,

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

2297: p_person_id in number,
2298: p_position_id in per_assignments_f.position_id%type,
2299: p_effective_date in date,
2300: p_grade_id in per_assignments_f.grade_id%type,
2301: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2302: p_assignment_id in per_assignments_f.assignment_id%type,
2303: p_action in varchar2,
2304: p_pay_plan out nocopy varchar2,
2305: p_to_pay_plan out nocopy varchar2,

Line 2302: p_assignment_id in per_assignments_f.assignment_id%type,

2298: p_position_id in per_assignments_f.position_id%type,
2299: p_effective_date in date,
2300: p_grade_id in per_assignments_f.grade_id%type,
2301: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
2302: p_assignment_id in per_assignments_f.assignment_id%type,
2303: p_action in varchar2,
2304: p_pay_plan out nocopy varchar2,
2305: p_to_pay_plan out nocopy varchar2,
2306: p_pay_table_id out nocopy number,

Line 2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

2786: ,p_mass_salary_id IN NUMBER
2787: ,p_mass_salary_name IN VARCHAR2
2788: ,p_full_name IN per_people_f.full_name%TYPE
2789: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 2791: ,p_person_id IN per_assignments_f.person_id%TYPE

2787: ,p_mass_salary_name IN VARCHAR2
2788: ,p_full_name IN per_people_f.full_name%TYPE
2789: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 2792: ,p_position_id IN per_assignments_f.position_id%TYPE

2788: ,p_full_name IN per_people_f.full_name%TYPE
2789: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE
2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE

2789: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE
2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2797: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE
2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2797: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2798: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 2795: ,p_location_id IN per_assignments_f.location_id%TYPE

2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE
2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2797: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2798: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2799: ,p_msl_personnel_office_id IN VARCHAR2

Line 2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE

2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE
2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2797: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2798: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2799: ,p_msl_personnel_office_id IN VARCHAR2
2800: ,p_msl_agency_code_subelement IN VARCHAR2

Line 2797: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE
2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE
2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2797: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2798: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2799: ,p_msl_personnel_office_id IN VARCHAR2
2800: ,p_msl_agency_code_subelement IN VARCHAR2
2801: ,p_msl_user_table_id IN NUMBER

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

2811: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
2812: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
2813: ,p_work_schedule OUT NOCOPY VARCHAR2
2814: ,p_part_time_hour OUT NOCOPY VARCHAR2
2815: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
2816: ,p_pay_plan OUT NOCOPY VARCHAR2
2817: ,p_to_pay_plan OUT NOCOPY VARCHAR2
2818: ,p_pay_table_id OUT NOCOPY NUMBER
2819: ,p_grade_or_level OUT NOCOPY VARCHAR2

Line 2837: l_assignment_id per_assignments_f.assignment_id%TYPE;

2833: AND pay_rate_determinant = cur_prd;
2834:
2835: l_row_cnt NUMBER := 0;
2836: l_pos_grp1_rec per_position_extra_info%rowtype;
2837: l_assignment_id per_assignments_f.assignment_id%TYPE;
2838: l_person_id per_assignments_f.person_id%TYPE;
2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;
2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;

Line 2838: l_person_id per_assignments_f.person_id%TYPE;

2834:
2835: l_row_cnt NUMBER := 0;
2836: l_pos_grp1_rec per_position_extra_info%rowtype;
2837: l_assignment_id per_assignments_f.assignment_id%TYPE;
2838: l_person_id per_assignments_f.person_id%TYPE;
2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;
2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2842: l_location_id per_assignments_f.location_id%TYPE;

Line 2839: l_position_id per_assignments_f.position_id%TYPE;

2835: l_row_cnt NUMBER := 0;
2836: l_pos_grp1_rec per_position_extra_info%rowtype;
2837: l_assignment_id per_assignments_f.assignment_id%TYPE;
2838: l_person_id per_assignments_f.person_id%TYPE;
2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;
2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2842: l_location_id per_assignments_f.location_id%TYPE;
2843: l_organization_id per_assignments_f.organization_id%TYPE;

Line 2840: l_grade_id per_assignments_f.grade_id%TYPE;

2836: l_pos_grp1_rec per_position_extra_info%rowtype;
2837: l_assignment_id per_assignments_f.assignment_id%TYPE;
2838: l_person_id per_assignments_f.person_id%TYPE;
2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;
2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2842: l_location_id per_assignments_f.location_id%TYPE;
2843: l_organization_id per_assignments_f.organization_id%TYPE;
2844: l_tenure VARCHAR2(35);

Line 2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;

2837: l_assignment_id per_assignments_f.assignment_id%TYPE;
2838: l_person_id per_assignments_f.person_id%TYPE;
2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;
2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2842: l_location_id per_assignments_f.location_id%TYPE;
2843: l_organization_id per_assignments_f.organization_id%TYPE;
2844: l_tenure VARCHAR2(35);
2845: l_annuitant_indicator VARCHAR2(35);

Line 2842: l_location_id per_assignments_f.location_id%TYPE;

2838: l_person_id per_assignments_f.person_id%TYPE;
2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;
2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2842: l_location_id per_assignments_f.location_id%TYPE;
2843: l_organization_id per_assignments_f.organization_id%TYPE;
2844: l_tenure VARCHAR2(35);
2845: l_annuitant_indicator VARCHAR2(35);
2846: l_pay_rate_determinant VARCHAR2(35);

Line 2843: l_organization_id per_assignments_f.organization_id%TYPE;

2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;
2841: l_business_group_id per_assignments_f.business_group_iD%TYPE;
2842: l_location_id per_assignments_f.location_id%TYPE;
2843: l_organization_id per_assignments_f.organization_id%TYPE;
2844: l_tenure VARCHAR2(35);
2845: l_annuitant_indicator VARCHAR2(35);
2846: l_pay_rate_determinant VARCHAR2(35);
2847: l_work_schedule VARCHAR2(35);

Line 3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

3152: ,p_mass_salary_id IN NUMBER
3153: ,p_mass_salary_name IN VARCHAR2
3154: ,p_full_name IN per_people_f.full_name%TYPE
3155: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 3157: ,p_person_id IN per_assignments_f.person_id%TYPE

3153: ,p_mass_salary_name IN VARCHAR2
3154: ,p_full_name IN per_people_f.full_name%TYPE
3155: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 3158: ,p_position_id IN per_assignments_f.position_id%TYPE

3154: ,p_full_name IN per_people_f.full_name%TYPE
3155: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE
3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE

3155: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE
3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3163: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE
3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3163: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3164: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 3161: ,p_location_id IN per_assignments_f.location_id%TYPE

3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE
3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3163: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3164: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3165: ,p_msl_personnel_office_id IN VARCHAR2

Line 3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE

3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE
3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3163: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3164: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3165: ,p_msl_personnel_office_id IN VARCHAR2
3166: ,p_msl_agency_code_subelement IN VARCHAR2

Line 3163: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE
3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE
3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3163: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3164: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3165: ,p_msl_personnel_office_id IN VARCHAR2
3166: ,p_msl_agency_code_subelement IN VARCHAR2
3167: ,p_msl_user_table_id IN NUMBER

Line 3199: l_assignment_id per_assignments_f.assignment_id%TYPE;

3195: AND pay_rate_determinant = cur_prd;
3196:
3197: l_row_cnt NUMBER := 0;
3198: l_pos_grp1_rec per_position_extra_info%rowtype;
3199: l_assignment_id per_assignments_f.assignment_id%TYPE;
3200: l_person_id per_assignments_f.person_id%TYPE;
3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;
3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;

Line 3200: l_person_id per_assignments_f.person_id%TYPE;

3196:
3197: l_row_cnt NUMBER := 0;
3198: l_pos_grp1_rec per_position_extra_info%rowtype;
3199: l_assignment_id per_assignments_f.assignment_id%TYPE;
3200: l_person_id per_assignments_f.person_id%TYPE;
3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;
3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3204: l_location_id per_assignments_f.location_id%TYPE;

Line 3201: l_position_id per_assignments_f.position_id%TYPE;

3197: l_row_cnt NUMBER := 0;
3198: l_pos_grp1_rec per_position_extra_info%rowtype;
3199: l_assignment_id per_assignments_f.assignment_id%TYPE;
3200: l_person_id per_assignments_f.person_id%TYPE;
3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;
3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3204: l_location_id per_assignments_f.location_id%TYPE;
3205: l_organization_id per_assignments_f.organization_id%TYPE;

Line 3202: l_grade_id per_assignments_f.grade_id%TYPE;

3198: l_pos_grp1_rec per_position_extra_info%rowtype;
3199: l_assignment_id per_assignments_f.assignment_id%TYPE;
3200: l_person_id per_assignments_f.person_id%TYPE;
3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;
3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3204: l_location_id per_assignments_f.location_id%TYPE;
3205: l_organization_id per_assignments_f.organization_id%TYPE;
3206: l_increase_percent ghr_mass_actions_preview.increase_percent%type;

Line 3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;

3199: l_assignment_id per_assignments_f.assignment_id%TYPE;
3200: l_person_id per_assignments_f.person_id%TYPE;
3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;
3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3204: l_location_id per_assignments_f.location_id%TYPE;
3205: l_organization_id per_assignments_f.organization_id%TYPE;
3206: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
3207: l_tenure VARCHAR2(35);

Line 3204: l_location_id per_assignments_f.location_id%TYPE;

3200: l_person_id per_assignments_f.person_id%TYPE;
3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;
3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3204: l_location_id per_assignments_f.location_id%TYPE;
3205: l_organization_id per_assignments_f.organization_id%TYPE;
3206: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
3207: l_tenure VARCHAR2(35);
3208: l_annuitant_indicator VARCHAR2(35);

Line 3205: l_organization_id per_assignments_f.organization_id%TYPE;

3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;
3203: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3204: l_location_id per_assignments_f.location_id%TYPE;
3205: l_organization_id per_assignments_f.organization_id%TYPE;
3206: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
3207: l_tenure VARCHAR2(35);
3208: l_annuitant_indicator VARCHAR2(35);
3209: l_pay_rate_determinant VARCHAR2(35);

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

3887: --
3888: --
3889: --
3890:
3891: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3892: p_effective_date in date,
3893: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3894: IS
3895:

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

4203: --
4204: --
4205:
4206: procedure get_sub_element_code_pos_title
4207: (p_position_id in per_assignments_f.position_id%type,
4208: p_person_id in number,
4209: p_business_group_id in per_assignments_f.business_group_id%type,
4210: p_assignment_id in per_assignments_f.assignment_id%type,
4211: p_effective_date in date,

Line 4209: p_business_group_id in per_assignments_f.business_group_id%type,

4205:
4206: procedure get_sub_element_code_pos_title
4207: (p_position_id in per_assignments_f.position_id%type,
4208: p_person_id in number,
4209: p_business_group_id in per_assignments_f.business_group_id%type,
4210: p_assignment_id in per_assignments_f.assignment_id%type,
4211: p_effective_date in date,
4212: p_sub_element_code out nocopy varchar2,
4213: p_position_title out nocopy varchar2,

Line 4210: p_assignment_id in per_assignments_f.assignment_id%type,

4206: procedure get_sub_element_code_pos_title
4207: (p_position_id in per_assignments_f.position_id%type,
4208: p_person_id in number,
4209: p_business_group_id in per_assignments_f.business_group_id%type,
4210: p_assignment_id in per_assignments_f.assignment_id%type,
4211: p_effective_date in date,
4212: p_sub_element_code out nocopy varchar2,
4213: p_position_title out nocopy varchar2,
4214: p_position_number out nocopy varchar2,

Line 4320: p_position_id in per_assignments_f.position_id%type,

4316: p_tot_old_sal in number,
4317: p_tot_new_sal in number,
4318: p_old_auo_pay in number,
4319: p_new_auo_pay in number,
4320: p_position_id in per_assignments_f.position_id%type,
4321: p_position_title in varchar2,
4322: -- FWFA Changes Bug#4444609
4323: p_position_number in varchar2,
4324: p_position_seq_no in varchar2,

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

4917: p_mass_salary varchar2(32);
4918:
4919: --
4920: --
4921: -- Main Cursor which fetches from per_assignments_f and per_people_f
4922: --
4923: --
4924: --1. Cursor with organization.
4925: ---

Line 4944: from per_assignments_f paf,

4940: paf.location_id LOCATION_ID,
4941: paf.organization_id ORGANIZATION_ID,
4942: paf.business_group_id BUSINESS_GROUP_ID,
4943: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
4944: from per_assignments_f paf,
4945: per_people_f ppf,
4946: per_person_types ppt
4947: where ppf.person_id = paf.person_id
4948: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 4981: from per_assignments_f paf,

4977: paf.location_id LOCATION_ID,
4978: paf.organization_id ORGANIZATION_ID,
4979: paf.business_group_id BUSINESS_GROUP_ID,
4980: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
4981: from per_assignments_f paf,
4982: per_people_f ppf,
4983: per_person_types ppt,
4984: hr_organization_units hou
4985: where ppf.person_id = paf.person_id

Line 5039: l_assignment_id per_assignments_f.assignment_id%type;

5035: where code = '894')
5036: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99 */
5037: ------------- ) and update_hr_flag = 'Y';
5038:
5039: l_assignment_id per_assignments_f.assignment_id%type;
5040: l_position_id per_assignments_f.position_id%type;
5041: l_grade_id per_assignments_f.grade_id%type;
5042: l_business_group_id per_assignments_f.business_group_id%type;
5043:

Line 5040: l_position_id per_assignments_f.position_id%type;

5036: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99 */
5037: ------------- ) and update_hr_flag = 'Y';
5038:
5039: l_assignment_id per_assignments_f.assignment_id%type;
5040: l_position_id per_assignments_f.position_id%type;
5041: l_grade_id per_assignments_f.grade_id%type;
5042: l_business_group_id per_assignments_f.business_group_id%type;
5043:
5044: l_position_title varchar2(300);

Line 5041: l_grade_id per_assignments_f.grade_id%type;

5037: ------------- ) and update_hr_flag = 'Y';
5038:
5039: l_assignment_id per_assignments_f.assignment_id%type;
5040: l_position_id per_assignments_f.position_id%type;
5041: l_grade_id per_assignments_f.grade_id%type;
5042: l_business_group_id per_assignments_f.business_group_id%type;
5043:
5044: l_position_title varchar2(300);
5045: l_position_number varchar2(20);

Line 5042: l_business_group_id per_assignments_f.business_group_id%type;

5038:
5039: l_assignment_id per_assignments_f.assignment_id%type;
5040: l_position_id per_assignments_f.position_id%type;
5041: l_grade_id per_assignments_f.grade_id%type;
5042: l_business_group_id per_assignments_f.business_group_id%type;
5043:
5044: l_position_title varchar2(300);
5045: l_position_number varchar2(20);
5046: l_position_seq_no varchar2(20);

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

5213: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5214:
5215: --
5216: --
5217: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5218: ,p_person_id per_assignments_f.person_id%TYPE
5219: ,p_position_id per_assignments_f.position_id%TYPE
5220: ,p_grade_id per_assignments_f.grade_id%TYPE
5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 5218: ,p_person_id per_assignments_f.person_id%TYPE

5214:
5215: --
5216: --
5217: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5218: ,p_person_id per_assignments_f.person_id%TYPE
5219: ,p_position_id per_assignments_f.position_id%TYPE
5220: ,p_grade_id per_assignments_f.grade_id%TYPE
5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5222: ,p_location_id per_assignments_f.location_id%TYPE

Line 5219: ,p_position_id per_assignments_f.position_id%TYPE

5215: --
5216: --
5217: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5218: ,p_person_id per_assignments_f.person_id%TYPE
5219: ,p_position_id per_assignments_f.position_id%TYPE
5220: ,p_grade_id per_assignments_f.grade_id%TYPE
5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5222: ,p_location_id per_assignments_f.location_id%TYPE
5223: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 5220: ,p_grade_id per_assignments_f.grade_id%TYPE

5216: --
5217: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5218: ,p_person_id per_assignments_f.person_id%TYPE
5219: ,p_position_id per_assignments_f.position_id%TYPE
5220: ,p_grade_id per_assignments_f.grade_id%TYPE
5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5222: ,p_location_id per_assignments_f.location_id%TYPE
5223: ,p_organization_id per_assignments_f.organization_id%TYPE
5224: ,p_date_of_birth date

Line 5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

5217: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE
5218: ,p_person_id per_assignments_f.person_id%TYPE
5219: ,p_position_id per_assignments_f.position_id%TYPE
5220: ,p_grade_id per_assignments_f.grade_id%TYPE
5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5222: ,p_location_id per_assignments_f.location_id%TYPE
5223: ,p_organization_id per_assignments_f.organization_id%TYPE
5224: ,p_date_of_birth date
5225: ,p_first_name per_people_f.first_name%TYPE

Line 5222: ,p_location_id per_assignments_f.location_id%TYPE

5218: ,p_person_id per_assignments_f.person_id%TYPE
5219: ,p_position_id per_assignments_f.position_id%TYPE
5220: ,p_grade_id per_assignments_f.grade_id%TYPE
5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5222: ,p_location_id per_assignments_f.location_id%TYPE
5223: ,p_organization_id per_assignments_f.organization_id%TYPE
5224: ,p_date_of_birth date
5225: ,p_first_name per_people_f.first_name%TYPE
5226: ,p_last_name per_people_f.last_name%TYPE

Line 5223: ,p_organization_id per_assignments_f.organization_id%TYPE

5219: ,p_position_id per_assignments_f.position_id%TYPE
5220: ,p_grade_id per_assignments_f.grade_id%TYPE
5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5222: ,p_location_id per_assignments_f.location_id%TYPE
5223: ,p_organization_id per_assignments_f.organization_id%TYPE
5224: ,p_date_of_birth date
5225: ,p_first_name per_people_f.first_name%TYPE
5226: ,p_last_name per_people_f.last_name%TYPE
5227: ,p_full_name per_people_f.full_name%TYPE

Line 6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

6572: ,p_mass_salary_id IN NUMBER
6573: ,p_mass_salary_name IN VARCHAR2
6574: ,p_full_name IN per_people_f.full_name%TYPE
6575: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 6577: ,p_person_id IN per_assignments_f.person_id%TYPE

6573: ,p_mass_salary_name IN VARCHAR2
6574: ,p_full_name IN per_people_f.full_name%TYPE
6575: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 6578: ,p_position_id IN per_assignments_f.position_id%TYPE

6574: ,p_full_name IN per_people_f.full_name%TYPE
6575: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE
6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE

6575: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE
6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6583: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE
6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6583: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6584: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 6581: ,p_location_id IN per_assignments_f.location_id%TYPE

6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE
6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6583: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6584: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6585: ,p_msl_personnel_office_id IN VARCHAR2

Line 6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE

6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE
6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6583: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6584: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6585: ,p_msl_personnel_office_id IN VARCHAR2
6586: ,p_msl_agency_code_subelement IN VARCHAR2

Line 6583: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE
6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE
6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6583: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6584: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6585: ,p_msl_personnel_office_id IN VARCHAR2
6586: ,p_msl_agency_code_subelement IN VARCHAR2
6587: ,p_msl_user_table_id IN NUMBER

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

6597: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
6598: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
6599: ,p_work_schedule OUT NOCOPY VARCHAR2
6600: ,p_part_time_hour OUT NOCOPY VARCHAR2
6601: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
6602: ,p_pay_plan OUT NOCOPY VARCHAR2
6603: ,p_to_pay_plan OUT NOCOPY VARCHAR2
6604: ,p_pay_table_id OUT NOCOPY NUMBER
6605: ,p_grade_or_level OUT NOCOPY VARCHAR2

Line 6623: l_assignment_id per_assignments_f.assignment_id%TYPE;

6619: AND pay_rate_determinant = cur_prd;
6620:
6621: l_row_cnt NUMBER := 0;
6622: l_pos_grp1_rec per_position_extra_info%rowtype;
6623: l_assignment_id per_assignments_f.assignment_id%TYPE;
6624: l_person_id per_assignments_f.person_id%TYPE;
6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;
6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;

Line 6624: l_person_id per_assignments_f.person_id%TYPE;

6620:
6621: l_row_cnt NUMBER := 0;
6622: l_pos_grp1_rec per_position_extra_info%rowtype;
6623: l_assignment_id per_assignments_f.assignment_id%TYPE;
6624: l_person_id per_assignments_f.person_id%TYPE;
6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;
6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6628: l_location_id per_assignments_f.location_id%TYPE;

Line 6625: l_position_id per_assignments_f.position_id%TYPE;

6621: l_row_cnt NUMBER := 0;
6622: l_pos_grp1_rec per_position_extra_info%rowtype;
6623: l_assignment_id per_assignments_f.assignment_id%TYPE;
6624: l_person_id per_assignments_f.person_id%TYPE;
6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;
6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6628: l_location_id per_assignments_f.location_id%TYPE;
6629: l_organization_id per_assignments_f.organization_id%TYPE;

Line 6626: l_grade_id per_assignments_f.grade_id%TYPE;

6622: l_pos_grp1_rec per_position_extra_info%rowtype;
6623: l_assignment_id per_assignments_f.assignment_id%TYPE;
6624: l_person_id per_assignments_f.person_id%TYPE;
6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;
6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6628: l_location_id per_assignments_f.location_id%TYPE;
6629: l_organization_id per_assignments_f.organization_id%TYPE;
6630: l_tenure VARCHAR2(35);

Line 6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;

6623: l_assignment_id per_assignments_f.assignment_id%TYPE;
6624: l_person_id per_assignments_f.person_id%TYPE;
6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;
6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6628: l_location_id per_assignments_f.location_id%TYPE;
6629: l_organization_id per_assignments_f.organization_id%TYPE;
6630: l_tenure VARCHAR2(35);
6631: l_annuitant_indicator VARCHAR2(35);

Line 6628: l_location_id per_assignments_f.location_id%TYPE;

6624: l_person_id per_assignments_f.person_id%TYPE;
6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;
6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6628: l_location_id per_assignments_f.location_id%TYPE;
6629: l_organization_id per_assignments_f.organization_id%TYPE;
6630: l_tenure VARCHAR2(35);
6631: l_annuitant_indicator VARCHAR2(35);
6632: l_pay_rate_determinant VARCHAR2(35);

Line 6629: l_organization_id per_assignments_f.organization_id%TYPE;

6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;
6627: l_business_group_id per_assignments_f.business_group_iD%TYPE;
6628: l_location_id per_assignments_f.location_id%TYPE;
6629: l_organization_id per_assignments_f.organization_id%TYPE;
6630: l_tenure VARCHAR2(35);
6631: l_annuitant_indicator VARCHAR2(35);
6632: l_pay_rate_determinant VARCHAR2(35);
6633: l_work_schedule VARCHAR2(35);

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

6972: p_mass_salary varchar2(32);
6973:
6974: --
6975: --
6976: -- Main Cursor which fetches from per_assignments_f and per_people_f
6977: --
6978: --
6979: --1. Cursor with organization.
6980: ---

Line 6997: from per_assignments_f paf,

6993: paf.location_id LOCATION_ID,
6994: paf.organization_id ORGANIZATION_ID,
6995: paf.business_group_id BUSINESS_GROUP_ID,
6996: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
6997: from per_assignments_f paf,
6998: per_people_f ppf,
6999: per_person_types ppt
7000: where ppf.person_id = paf.person_id
7001: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 7031: from per_assignments_f paf,

7027: paf.location_id LOCATION_ID,
7028: paf.organization_id ORGANIZATION_ID,
7029: paf.business_group_id BUSINESS_GROUP_ID,
7030: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
7031: from per_assignments_f paf,
7032: per_people_f ppf,
7033: per_person_types ppt,
7034: hr_organization_units hou
7035: where ppf.person_id = paf.person_id

Line 7091: l_assignment_id per_assignments_f.assignment_id%type;

7087: where code = '890')
7088: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
7089: ------------- ) and update_hr_flag = 'Y';
7090:
7091: l_assignment_id per_assignments_f.assignment_id%type;
7092: l_position_id per_assignments_f.position_id%type;
7093: l_grade_id per_assignments_f.grade_id%type;
7094: l_business_group_id per_assignments_f.business_group_id%type;
7095:

Line 7092: l_position_id per_assignments_f.position_id%type;

7088: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
7089: ------------- ) and update_hr_flag = 'Y';
7090:
7091: l_assignment_id per_assignments_f.assignment_id%type;
7092: l_position_id per_assignments_f.position_id%type;
7093: l_grade_id per_assignments_f.grade_id%type;
7094: l_business_group_id per_assignments_f.business_group_id%type;
7095:
7096: l_position_title varchar2(300);

Line 7093: l_grade_id per_assignments_f.grade_id%type;

7089: ------------- ) and update_hr_flag = 'Y';
7090:
7091: l_assignment_id per_assignments_f.assignment_id%type;
7092: l_position_id per_assignments_f.position_id%type;
7093: l_grade_id per_assignments_f.grade_id%type;
7094: l_business_group_id per_assignments_f.business_group_id%type;
7095:
7096: l_position_title varchar2(300);
7097: l_position_number varchar2(20);

Line 7094: l_business_group_id per_assignments_f.business_group_id%type;

7090:
7091: l_assignment_id per_assignments_f.assignment_id%type;
7092: l_position_id per_assignments_f.position_id%type;
7093: l_grade_id per_assignments_f.grade_id%type;
7094: l_business_group_id per_assignments_f.business_group_id%type;
7095:
7096: l_position_title varchar2(300);
7097: l_position_number varchar2(20);
7098: l_position_seq_no varchar2(20);

Line 7221: l_to_grade_id per_assignments_f.grade_id%type;

7217: l_comment_range VARCHAR2(150);
7218: l_comments VARCHAR2(150);
7219:
7220: -- Bug#5089732 Added current pay plan, grade_or_level
7221: l_to_grade_id per_assignments_f.grade_id%type;
7222: l_to_pay_plan varchar2(30);
7223: l_to_grade_or_level varchar2(30);
7224: -- Bug#5089732
7225:

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

7261: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
7262: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
7263:
7264:
7265: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7266: ,p_person_id per_assignments_f.person_id%TYPE
7267: ,p_position_id per_assignments_f.position_id%TYPE
7268: ,p_grade_id per_assignments_f.grade_id%TYPE
7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 7266: ,p_person_id per_assignments_f.person_id%TYPE

7262: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
7263:
7264:
7265: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7266: ,p_person_id per_assignments_f.person_id%TYPE
7267: ,p_position_id per_assignments_f.position_id%TYPE
7268: ,p_grade_id per_assignments_f.grade_id%TYPE
7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7270: ,p_location_id per_assignments_f.location_id%TYPE

Line 7267: ,p_position_id per_assignments_f.position_id%TYPE

7263:
7264:
7265: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7266: ,p_person_id per_assignments_f.person_id%TYPE
7267: ,p_position_id per_assignments_f.position_id%TYPE
7268: ,p_grade_id per_assignments_f.grade_id%TYPE
7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7270: ,p_location_id per_assignments_f.location_id%TYPE
7271: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 7268: ,p_grade_id per_assignments_f.grade_id%TYPE

7264:
7265: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7266: ,p_person_id per_assignments_f.person_id%TYPE
7267: ,p_position_id per_assignments_f.position_id%TYPE
7268: ,p_grade_id per_assignments_f.grade_id%TYPE
7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7270: ,p_location_id per_assignments_f.location_id%TYPE
7271: ,p_organization_id per_assignments_f.organization_id%TYPE
7272: ,p_date_of_birth date

Line 7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

7265: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7266: ,p_person_id per_assignments_f.person_id%TYPE
7267: ,p_position_id per_assignments_f.position_id%TYPE
7268: ,p_grade_id per_assignments_f.grade_id%TYPE
7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7270: ,p_location_id per_assignments_f.location_id%TYPE
7271: ,p_organization_id per_assignments_f.organization_id%TYPE
7272: ,p_date_of_birth date
7273: ,p_first_name per_people_f.first_name%TYPE

Line 7270: ,p_location_id per_assignments_f.location_id%TYPE

7266: ,p_person_id per_assignments_f.person_id%TYPE
7267: ,p_position_id per_assignments_f.position_id%TYPE
7268: ,p_grade_id per_assignments_f.grade_id%TYPE
7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7270: ,p_location_id per_assignments_f.location_id%TYPE
7271: ,p_organization_id per_assignments_f.organization_id%TYPE
7272: ,p_date_of_birth date
7273: ,p_first_name per_people_f.first_name%TYPE
7274: ,p_last_name per_people_f.last_name%TYPE

Line 7271: ,p_organization_id per_assignments_f.organization_id%TYPE

7267: ,p_position_id per_assignments_f.position_id%TYPE
7268: ,p_grade_id per_assignments_f.grade_id%TYPE
7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7270: ,p_location_id per_assignments_f.location_id%TYPE
7271: ,p_organization_id per_assignments_f.organization_id%TYPE
7272: ,p_date_of_birth date
7273: ,p_first_name per_people_f.first_name%TYPE
7274: ,p_last_name per_people_f.last_name%TYPE
7275: ,p_full_name per_people_f.full_name%TYPE

Line 7290: ,p_to_grade_id IN per_assignments_f.grade_id%type

7286: ,p_annuitant_indicator IN VARCHAR2
7287: ,p_pay_rate_determinant IN VARCHAR2
7288: ,p_work_schedule IN VARCHAR2
7289: ,p_part_time_hour IN VARCHAR2
7290: ,p_to_grade_id IN per_assignments_f.grade_id%type
7291: ,p_pay_plan IN VARCHAR2
7292: ,p_to_pay_plan IN VARCHAR2
7293: ,p_pay_table_id IN NUMBER
7294: ,p_grade_or_level IN VARCHAR2