DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on PER_ASSIGNMENTS_F

Line 27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE

23: , p_mass_salary_name IN varchar2
24: , p_full_name IN per_people_f.full_name%TYPE
25: , p_national_identifier IN per_people_f.national_identifier%TYPE
26: , p_employee_number IN per_people_f.employee_number%TYPE
27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

Line 28: , p_person_id IN per_assignments_f.person_id%TYPE

24: , p_full_name IN per_people_f.full_name%TYPE
25: , p_national_identifier IN per_people_f.national_identifier%TYPE
26: , p_employee_number IN per_people_f.employee_number%TYPE
27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32: , p_location_id IN per_assignments_f.location_id%TYPE

Line 29: , p_position_id IN per_assignments_f.position_id%TYPE

25: , p_national_identifier IN per_people_f.national_identifier%TYPE
26: , p_employee_number IN per_people_f.employee_number%TYPE
27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32: , p_location_id IN per_assignments_f.location_id%TYPE
33: , p_organization_id IN per_assignments_f.organization_id%TYPE

Line 30: , p_grade_id IN per_assignments_f.grade_id%TYPE

26: , p_employee_number IN per_people_f.employee_number%TYPE
27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32: , p_location_id IN per_assignments_f.location_id%TYPE
33: , p_organization_id IN per_assignments_f.organization_id%TYPE
34: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE

Line 31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE

27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32: , p_location_id IN per_assignments_f.location_id%TYPE
33: , p_organization_id IN per_assignments_f.organization_id%TYPE
34: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
35: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

Line 32: , p_location_id IN per_assignments_f.location_id%TYPE

28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32: , p_location_id IN per_assignments_f.location_id%TYPE
33: , p_organization_id IN per_assignments_f.organization_id%TYPE
34: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
35: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
36: , p_mnoa_personnel_office_id IN varchar2

Line 33: , p_organization_id IN per_assignments_f.organization_id%TYPE

29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32: , p_location_id IN per_assignments_f.location_id%TYPE
33: , p_organization_id IN per_assignments_f.organization_id%TYPE
34: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
35: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
36: , p_mnoa_personnel_office_id IN varchar2
37: , p_mnoa_agency_code_subelement IN varchar2

Line 34: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE

30: , p_grade_id IN per_assignments_f.grade_id%TYPE
31: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
32: , p_location_id IN per_assignments_f.location_id%TYPE
33: , p_organization_id IN per_assignments_f.organization_id%TYPE
34: , p_mnoa_organization_id IN per_assignments_f.organization_id%TYPE
35: , p_mnoa_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
36: , p_mnoa_personnel_office_id IN varchar2
37: , p_mnoa_agency_code_subelement IN varchar2
38: , p_mnoa_job_id IN number default NULL

Line 53: , p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%TYPE

49: , p_annuitant_indicator OUT NOCOPY varchar2
50: , p_pay_rate_determinant OUT NOCOPY varchar2
51: , p_work_schedule OUT NOCOPY varchar2
52: , p_part_time_hour OUT NOCOPY varchar2
53: , p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%TYPE
54: , p_pay_plan OUT NOCOPY varchar2
55: , p_to_pay_plan OUT NOCOPY varchar2
56: , p_pay_table_id OUT NOCOPY number
57: , p_grade_or_level OUT NOCOPY varchar2