DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on PER_ASSIGNMENTS_F

Line 88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

84: ,p_mass_salary_id IN NUMBER
85: ,p_mass_salary_name IN VARCHAR2
86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 89: ,p_person_id IN per_assignments_f.person_id%TYPE

85: ,p_mass_salary_name IN VARCHAR2
86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 90: ,p_position_id IN per_assignments_f.position_id%TYPE

86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 91: ,p_grade_id IN per_assignments_f.grade_id%TYPE

87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 93: ,p_location_id IN per_assignments_f.location_id%TYPE

89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
97: ,p_msl_personnel_office_id IN VARCHAR2

Line 94: ,p_organization_id IN per_assignments_f.organization_id%TYPE

90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
97: ,p_msl_personnel_office_id IN VARCHAR2
98: ,p_msl_agency_code_subelement IN VARCHAR2

Line 95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
97: ,p_msl_personnel_office_id IN VARCHAR2
98: ,p_msl_agency_code_subelement IN VARCHAR2
99: ,p_msl_user_table_id IN NUMBER

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

109: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
110: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
111: ,p_work_schedule OUT NOCOPY VARCHAR2
112: ,p_part_time_hour OUT NOCOPY VARCHAR2
113: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
114: ,p_pay_plan OUT NOCOPY VARCHAR2
115: ,p_to_pay_plan OUT NOCOPY VARCHAR2
116: ,p_pay_table_id OUT NOCOPY NUMBER
117: ,p_grade_or_level OUT NOCOPY VARCHAR2

Line 132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

128: ,p_mass_salary_id IN NUMBER
129: ,p_mass_salary_name IN VARCHAR2
130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 133: ,p_person_id IN per_assignments_f.person_id%TYPE

129: ,p_mass_salary_name IN VARCHAR2
130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 134: ,p_position_id IN per_assignments_f.position_id%TYPE

130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 135: ,p_grade_id IN per_assignments_f.grade_id%TYPE

131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 137: ,p_location_id IN per_assignments_f.location_id%TYPE

133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
141: ,p_msl_personnel_office_id IN VARCHAR2

Line 138: ,p_organization_id IN per_assignments_f.organization_id%TYPE

134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
141: ,p_msl_personnel_office_id IN VARCHAR2
142: ,p_msl_agency_code_subelement IN VARCHAR2

Line 139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
141: ,p_msl_personnel_office_id IN VARCHAR2
142: ,p_msl_agency_code_subelement IN VARCHAR2
143: ,p_msl_user_table_id IN NUMBER

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

219: p_supervisory_diff_perc out nocopy number,
220: p_staffing_differential out nocopy number);
221:
222: procedure get_sub_element_code_pos_title
223: (p_position_id in per_assignments_f.position_id%type,
224: p_person_id in number,
225: p_business_group_id in per_assignments_f.business_group_id%type,
226: p_assignment_id in per_assignments_f.assignment_id%type,
227: p_effective_date in date,

Line 225: p_business_group_id in per_assignments_f.business_group_id%type,

221:
222: procedure get_sub_element_code_pos_title
223: (p_position_id in per_assignments_f.position_id%type,
224: p_person_id in number,
225: p_business_group_id in per_assignments_f.business_group_id%type,
226: p_assignment_id in per_assignments_f.assignment_id%type,
227: p_effective_date in date,
228: p_sub_element_code out nocopy varchar2,
229: p_position_title out nocopy varchar2,

Line 226: p_assignment_id in per_assignments_f.assignment_id%type,

222: procedure get_sub_element_code_pos_title
223: (p_position_id in per_assignments_f.position_id%type,
224: p_person_id in number,
225: p_business_group_id in per_assignments_f.business_group_id%type,
226: p_assignment_id in per_assignments_f.assignment_id%type,
227: p_effective_date in date,
228: p_sub_element_code out nocopy varchar2,
229: p_position_title out nocopy varchar2,
230: p_position_number out nocopy varchar2,

Line 262: p_position_id in per_assignments_f.position_id%type,

258: procedure purge_old_data (p_mass_salary_id in number);
259:
260: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
261: p_person_id in number,
262: p_position_id in per_assignments_f.position_id%type,
263: p_effective_date in date,
264: p_grade_id in per_assignments_f.grade_id%type,
265: p_assignment_id in per_assignments_f.assignment_id%type,
266: p_action in varchar2,

Line 264: p_grade_id in per_assignments_f.grade_id%type,

260: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
261: p_person_id in number,
262: p_position_id in per_assignments_f.position_id%type,
263: p_effective_date in date,
264: p_grade_id in per_assignments_f.grade_id%type,
265: p_assignment_id in per_assignments_f.assignment_id%type,
266: p_action in varchar2,
267: p_pay_plan out nocopy varchar2,
268: p_pay_table_id out nocopy number,

Line 265: p_assignment_id in per_assignments_f.assignment_id%type,

261: p_person_id in number,
262: p_position_id in per_assignments_f.position_id%type,
263: p_effective_date in date,
264: p_grade_id in per_assignments_f.grade_id%type,
265: p_assignment_id in per_assignments_f.assignment_id%type,
266: p_action in varchar2,
267: p_pay_plan out nocopy varchar2,
268: p_pay_table_id out nocopy number,
269: p_grade_or_level out nocopy varchar2,

Line 276: p_position_id in per_assignments_f.position_id%type,

272:
273: --Bug#5089732 Created new overloaded procedure get_pay_plan_and_table_id
274: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
275: p_person_id in number,
276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,

Line 278: p_grade_id in per_assignments_f.grade_id%type,

274: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
275: p_person_id in number,
276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,
281: p_action in varchar2,
282: p_pay_plan out nocopy varchar2,

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

275: p_person_id in number,
276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,
281: p_action in varchar2,
282: p_pay_plan out nocopy varchar2,
283: p_to_pay_plan out nocopy varchar2,

Line 280: p_assignment_id in per_assignments_f.assignment_id%type,

276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,
281: p_action in varchar2,
282: p_pay_plan out nocopy varchar2,
283: p_to_pay_plan out nocopy varchar2,
284: p_pay_table_id out nocopy number,

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

292: FUNCTION check_grade_retention(p_prd in varchar2
293: ,p_person_id in number
294: ,p_effective_date in date) return varchar2;
295:
296: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
297: p_effective_date in date,
298: p_pos_ei_data out nocopy per_position_extra_info%rowtype);
299:
300: procedure create_mass_act_prev (

Line 322: p_position_id in per_assignments_f.position_id%type,

318: p_tot_old_sal in number,
319: p_tot_new_sal in number,
320: p_old_auo_pay in number,
321: p_new_auo_pay in number,
322: p_position_id in per_assignments_f.position_id%type,
323: p_position_title in varchar2,
324: -- FWFA Changes Bug#4444609
325: p_position_number in varchar2,
326: p_position_seq_no in varchar2,

Line 439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

435: ,p_mass_salary_id IN NUMBER
436: ,p_mass_salary_name IN VARCHAR2
437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

Line 440: ,p_person_id IN per_assignments_f.person_id%TYPE

436: ,p_mass_salary_name IN VARCHAR2
437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE

Line 441: ,p_position_id IN per_assignments_f.position_id%TYPE

437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE

Line 442: ,p_grade_id IN per_assignments_f.grade_id%TYPE

438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

Line 443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE

439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 444: ,p_location_id IN per_assignments_f.location_id%TYPE

440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
448: ,p_msl_personnel_office_id IN VARCHAR2

Line 445: ,p_organization_id IN per_assignments_f.organization_id%TYPE

441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
448: ,p_msl_personnel_office_id IN VARCHAR2
449: ,p_msl_agency_code_subelement IN VARCHAR2

Line 446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE

442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
448: ,p_msl_personnel_office_id IN VARCHAR2
449: ,p_msl_agency_code_subelement IN VARCHAR2
450: ,p_msl_user_table_id IN NUMBER

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

460: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
461: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
462: ,p_work_schedule OUT NOCOPY VARCHAR2
463: ,p_part_time_hour OUT NOCOPY VARCHAR2
464: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
465: ,p_pay_plan OUT NOCOPY VARCHAR2
466: ,p_to_pay_plan OUT NOCOPY VARCHAR2
467: ,p_pay_table_id OUT NOCOPY NUMBER
468: ,p_grade_or_level OUT NOCOPY VARCHAR2