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 93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

89: ,p_full_name IN per_people_f.full_name%TYPE
90: ,p_national_identifier IN per_people_f.national_identifier%TYPE
91: --Bug # 9329643
92: ,p_employee_number IN per_people_f.employee_number%TYPE
93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_person_id IN per_assignments_f.person_id%TYPE
95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 94: ,p_person_id IN per_assignments_f.person_id%TYPE

90: ,p_national_identifier IN per_people_f.national_identifier%TYPE
91: --Bug # 9329643
92: ,p_employee_number IN per_people_f.employee_number%TYPE
93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_person_id IN per_assignments_f.person_id%TYPE
95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
98: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 95: ,p_position_id IN per_assignments_f.position_id%TYPE

91: --Bug # 9329643
92: ,p_employee_number IN per_people_f.employee_number%TYPE
93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_person_id IN per_assignments_f.person_id%TYPE
95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
98: ,p_location_id IN per_assignments_f.location_id%TYPE
99: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 96: ,p_grade_id IN per_assignments_f.grade_id%TYPE

92: ,p_employee_number IN per_people_f.employee_number%TYPE
93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_person_id IN per_assignments_f.person_id%TYPE
95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
98: ,p_location_id IN per_assignments_f.location_id%TYPE
99: ,p_organization_id IN per_assignments_f.organization_id%TYPE
100: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_person_id IN per_assignments_f.person_id%TYPE
95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
98: ,p_location_id IN per_assignments_f.location_id%TYPE
99: ,p_organization_id IN per_assignments_f.organization_id%TYPE
100: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
101: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 98: ,p_location_id IN per_assignments_f.location_id%TYPE

94: ,p_person_id IN per_assignments_f.person_id%TYPE
95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
98: ,p_location_id IN per_assignments_f.location_id%TYPE
99: ,p_organization_id IN per_assignments_f.organization_id%TYPE
100: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
101: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
102: ,p_msl_personnel_office_id IN VARCHAR2

Line 99: ,p_organization_id IN per_assignments_f.organization_id%TYPE

95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
98: ,p_location_id IN per_assignments_f.location_id%TYPE
99: ,p_organization_id IN per_assignments_f.organization_id%TYPE
100: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
101: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
102: ,p_msl_personnel_office_id IN VARCHAR2
103: ,p_msl_agency_code_subelement IN VARCHAR2

Line 100: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

96: ,p_grade_id IN per_assignments_f.grade_id%TYPE
97: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
98: ,p_location_id IN per_assignments_f.location_id%TYPE
99: ,p_organization_id IN per_assignments_f.organization_id%TYPE
100: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
101: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
102: ,p_msl_personnel_office_id IN VARCHAR2
103: ,p_msl_agency_code_subelement IN VARCHAR2
104: ,p_msl_user_table_id IN NUMBER

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

114: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
115: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
116: ,p_work_schedule OUT NOCOPY VARCHAR2
117: ,p_part_time_hour OUT NOCOPY VARCHAR2
118: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
119: ,p_pay_plan OUT NOCOPY VARCHAR2
120: ,p_to_pay_plan OUT NOCOPY VARCHAR2
121: ,p_pay_table_id OUT NOCOPY NUMBER
122: ,p_grade_or_level OUT NOCOPY VARCHAR2

Line 139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

135: ,p_full_name IN per_people_f.full_name%TYPE
136: ,p_national_identifier IN per_people_f.national_identifier%TYPE
137: --Bug # 9329643
138: ,p_employee_number IN per_people_f.employee_number%TYPE
139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
140: ,p_person_id IN per_assignments_f.person_id%TYPE
141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 140: ,p_person_id IN per_assignments_f.person_id%TYPE

136: ,p_national_identifier IN per_people_f.national_identifier%TYPE
137: --Bug # 9329643
138: ,p_employee_number IN per_people_f.employee_number%TYPE
139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
140: ,p_person_id IN per_assignments_f.person_id%TYPE
141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
144: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 141: ,p_position_id IN per_assignments_f.position_id%TYPE

137: --Bug # 9329643
138: ,p_employee_number IN per_people_f.employee_number%TYPE
139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
140: ,p_person_id IN per_assignments_f.person_id%TYPE
141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
144: ,p_location_id IN per_assignments_f.location_id%TYPE
145: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 142: ,p_grade_id IN per_assignments_f.grade_id%TYPE

138: ,p_employee_number IN per_people_f.employee_number%TYPE
139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
140: ,p_person_id IN per_assignments_f.person_id%TYPE
141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
144: ,p_location_id IN per_assignments_f.location_id%TYPE
145: ,p_organization_id IN per_assignments_f.organization_id%TYPE
146: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
140: ,p_person_id IN per_assignments_f.person_id%TYPE
141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
144: ,p_location_id IN per_assignments_f.location_id%TYPE
145: ,p_organization_id IN per_assignments_f.organization_id%TYPE
146: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
147: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 144: ,p_location_id IN per_assignments_f.location_id%TYPE

140: ,p_person_id IN per_assignments_f.person_id%TYPE
141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
144: ,p_location_id IN per_assignments_f.location_id%TYPE
145: ,p_organization_id IN per_assignments_f.organization_id%TYPE
146: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
147: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
148: ,p_msl_personnel_office_id IN VARCHAR2

Line 145: ,p_organization_id IN per_assignments_f.organization_id%TYPE

141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
144: ,p_location_id IN per_assignments_f.location_id%TYPE
145: ,p_organization_id IN per_assignments_f.organization_id%TYPE
146: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
147: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
148: ,p_msl_personnel_office_id IN VARCHAR2
149: ,p_msl_agency_code_subelement IN VARCHAR2

Line 146: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

142: ,p_grade_id IN per_assignments_f.grade_id%TYPE
143: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
144: ,p_location_id IN per_assignments_f.location_id%TYPE
145: ,p_organization_id IN per_assignments_f.organization_id%TYPE
146: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
147: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
148: ,p_msl_personnel_office_id IN VARCHAR2
149: ,p_msl_agency_code_subelement IN VARCHAR2
150: ,p_msl_user_table_id IN NUMBER

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

226: p_supervisory_diff_perc out nocopy number,
227: p_staffing_differential out nocopy number);
228:
229: procedure get_sub_element_code_pos_title
230: (p_position_id in per_assignments_f.position_id%type,
231: p_person_id in number,
232: p_business_group_id in per_assignments_f.business_group_id%type,
233: p_assignment_id in per_assignments_f.assignment_id%type,
234: p_effective_date in date,

Line 232: p_business_group_id in per_assignments_f.business_group_id%type,

228:
229: procedure get_sub_element_code_pos_title
230: (p_position_id in per_assignments_f.position_id%type,
231: p_person_id in number,
232: p_business_group_id in per_assignments_f.business_group_id%type,
233: p_assignment_id in per_assignments_f.assignment_id%type,
234: p_effective_date in date,
235: p_sub_element_code out nocopy varchar2,
236: p_position_title out nocopy varchar2,

Line 233: p_assignment_id in per_assignments_f.assignment_id%type,

229: procedure get_sub_element_code_pos_title
230: (p_position_id in per_assignments_f.position_id%type,
231: p_person_id in number,
232: p_business_group_id in per_assignments_f.business_group_id%type,
233: p_assignment_id in per_assignments_f.assignment_id%type,
234: p_effective_date in date,
235: p_sub_element_code out nocopy varchar2,
236: p_position_title out nocopy varchar2,
237: p_position_number out nocopy varchar2,

Line 269: p_position_id in per_assignments_f.position_id%type,

265: procedure purge_old_data (p_mass_salary_id in number);
266:
267: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
268: p_person_id in number,
269: p_position_id in per_assignments_f.position_id%type,
270: p_effective_date in date,
271: p_grade_id in per_assignments_f.grade_id%type,
272: p_assignment_id in per_assignments_f.assignment_id%type,
273: p_action in varchar2,

Line 271: p_grade_id in per_assignments_f.grade_id%type,

267: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
268: p_person_id in number,
269: p_position_id in per_assignments_f.position_id%type,
270: p_effective_date in date,
271: p_grade_id in per_assignments_f.grade_id%type,
272: p_assignment_id in per_assignments_f.assignment_id%type,
273: p_action in varchar2,
274: p_pay_plan out nocopy varchar2,
275: p_pay_table_id out nocopy number,

Line 272: p_assignment_id in per_assignments_f.assignment_id%type,

268: p_person_id in number,
269: p_position_id in per_assignments_f.position_id%type,
270: p_effective_date in date,
271: p_grade_id in per_assignments_f.grade_id%type,
272: p_assignment_id in per_assignments_f.assignment_id%type,
273: p_action in varchar2,
274: p_pay_plan out nocopy varchar2,
275: p_pay_table_id out nocopy number,
276: p_grade_or_level out nocopy varchar2,

Line 283: p_position_id in per_assignments_f.position_id%type,

279:
280: --Bug#5089732 Created new overloaded procedure get_pay_plan_and_table_id
281: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
282: p_person_id in number,
283: p_position_id in per_assignments_f.position_id%type,
284: p_effective_date in date,
285: p_grade_id in per_assignments_f.grade_id%type,
286: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
287: p_assignment_id in per_assignments_f.assignment_id%type,

Line 285: p_grade_id in per_assignments_f.grade_id%type,

281: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
282: p_person_id in number,
283: p_position_id in per_assignments_f.position_id%type,
284: p_effective_date in date,
285: p_grade_id in per_assignments_f.grade_id%type,
286: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
287: p_assignment_id in per_assignments_f.assignment_id%type,
288: p_action in varchar2,
289: p_pay_plan out nocopy varchar2,

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

282: p_person_id in number,
283: p_position_id in per_assignments_f.position_id%type,
284: p_effective_date in date,
285: p_grade_id in per_assignments_f.grade_id%type,
286: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
287: p_assignment_id in per_assignments_f.assignment_id%type,
288: p_action in varchar2,
289: p_pay_plan out nocopy varchar2,
290: p_to_pay_plan out nocopy varchar2,

Line 287: p_assignment_id in per_assignments_f.assignment_id%type,

283: p_position_id in per_assignments_f.position_id%type,
284: p_effective_date in date,
285: p_grade_id in per_assignments_f.grade_id%type,
286: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
287: p_assignment_id in per_assignments_f.assignment_id%type,
288: p_action in varchar2,
289: p_pay_plan out nocopy varchar2,
290: p_to_pay_plan out nocopy varchar2,
291: p_pay_table_id out nocopy number,

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

299: FUNCTION check_grade_retention(p_prd in varchar2
300: ,p_person_id in number
301: ,p_effective_date in date) return varchar2;
302:
303: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
304: p_effective_date in date,
305: p_pos_ei_data out nocopy per_position_extra_info%rowtype);
306:
307: procedure create_mass_act_prev (

Line 331: p_position_id in per_assignments_f.position_id%type,

327: p_tot_old_sal in number,
328: p_tot_new_sal in number,
329: p_old_auo_pay in number,
330: p_new_auo_pay in number,
331: p_position_id in per_assignments_f.position_id%type,
332: p_position_title in varchar2,
333: -- FWFA Changes Bug#4444609
334: p_position_number in varchar2,
335: p_position_seq_no in varchar2,

Line 450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

446: ,p_full_name IN per_people_f.full_name%TYPE
447: ,p_national_identifier IN per_people_f.national_identifier%TYPE
448: --Bug # 9329643
449: ,p_employee_number IN per_people_f.employee_number%TYPE
450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
451: ,p_person_id IN per_assignments_f.person_id%TYPE
452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 451: ,p_person_id IN per_assignments_f.person_id%TYPE

447: ,p_national_identifier IN per_people_f.national_identifier%TYPE
448: --Bug # 9329643
449: ,p_employee_number IN per_people_f.employee_number%TYPE
450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
451: ,p_person_id IN per_assignments_f.person_id%TYPE
452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
455: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 452: ,p_position_id IN per_assignments_f.position_id%TYPE

448: --Bug # 9329643
449: ,p_employee_number IN per_people_f.employee_number%TYPE
450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
451: ,p_person_id IN per_assignments_f.person_id%TYPE
452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
455: ,p_location_id IN per_assignments_f.location_id%TYPE
456: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 453: ,p_grade_id IN per_assignments_f.grade_id%TYPE

449: ,p_employee_number IN per_people_f.employee_number%TYPE
450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
451: ,p_person_id IN per_assignments_f.person_id%TYPE
452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
455: ,p_location_id IN per_assignments_f.location_id%TYPE
456: ,p_organization_id IN per_assignments_f.organization_id%TYPE
457: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
451: ,p_person_id IN per_assignments_f.person_id%TYPE
452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
455: ,p_location_id IN per_assignments_f.location_id%TYPE
456: ,p_organization_id IN per_assignments_f.organization_id%TYPE
457: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
458: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 455: ,p_location_id IN per_assignments_f.location_id%TYPE

451: ,p_person_id IN per_assignments_f.person_id%TYPE
452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
455: ,p_location_id IN per_assignments_f.location_id%TYPE
456: ,p_organization_id IN per_assignments_f.organization_id%TYPE
457: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
458: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
459: ,p_msl_personnel_office_id IN VARCHAR2

Line 456: ,p_organization_id IN per_assignments_f.organization_id%TYPE

452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
455: ,p_location_id IN per_assignments_f.location_id%TYPE
456: ,p_organization_id IN per_assignments_f.organization_id%TYPE
457: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
458: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
459: ,p_msl_personnel_office_id IN VARCHAR2
460: ,p_msl_agency_code_subelement IN VARCHAR2

Line 457: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

453: ,p_grade_id IN per_assignments_f.grade_id%TYPE
454: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
455: ,p_location_id IN per_assignments_f.location_id%TYPE
456: ,p_organization_id IN per_assignments_f.organization_id%TYPE
457: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
458: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
459: ,p_msl_personnel_office_id IN VARCHAR2
460: ,p_msl_agency_code_subelement IN VARCHAR2
461: ,p_msl_user_table_id IN NUMBER

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

471: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
472: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
473: ,p_work_schedule OUT NOCOPY VARCHAR2
474: ,p_part_time_hour OUT NOCOPY VARCHAR2
475: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
476: ,p_pay_plan OUT NOCOPY VARCHAR2
477: ,p_to_pay_plan OUT NOCOPY VARCHAR2
478: ,p_pay_table_id OUT NOCOPY NUMBER
479: ,p_grade_or_level OUT NOCOPY VARCHAR2