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_WGI_PKG dependencies on PER_ASSIGNMENTS

Line 61: FROM per_assignments_f paf, per_people_f ppf,

57: ppf.last_name, ppf.first_name, ppf.middle_names,
58: ppf.full_name, paf.position_id, paf.assignment_id,
59: paf.grade_id, paf.job_id, paf.location_id,
60: paf.organization_id
61: FROM per_assignments_f paf, per_people_f ppf,
62: per_person_types ppt
63: WHERE ppf.person_id = paf.person_id
64: AND paf.primary_flag = 'Y'
65: AND paf.assignment_type <> 'B'

Line 84: l_assignment_id per_assignments.assignment_id%TYPE;

80: -- remove person id, set default frequency to 90, uncomment element api
81: --
82: l_exists BOOLEAN;
83: l_person_id per_people_f.person_id%TYPE;
84: l_assignment_id per_assignments.assignment_id%TYPE;
85: l_national_identifier per_people_f.national_identifier%TYPE;
86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;

Line 91: l_position_id per_assignments.position_id%TYPE;

87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;
93: l_job_id per_assignments.job_id%TYPE;
94: l_location_id per_assignments.location_id%TYPE;
95: l_organization_id per_assignments.organization_id%TYPE;

Line 93: l_job_id per_assignments.job_id%TYPE;

89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;
93: l_job_id per_assignments.job_id%TYPE;
94: l_location_id per_assignments.location_id%TYPE;
95: l_organization_id per_assignments.organization_id%TYPE;
96: l_proc VARCHAR2 (30) := 'AWGI :';
97: l_pay_basis per_pay_bases.pay_basis%TYPE;

Line 94: l_location_id per_assignments.location_id%TYPE;

90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;
93: l_job_id per_assignments.job_id%TYPE;
94: l_location_id per_assignments.location_id%TYPE;
95: l_organization_id per_assignments.organization_id%TYPE;
96: l_proc VARCHAR2 (30) := 'AWGI :';
97: l_pay_basis per_pay_bases.pay_basis%TYPE;
98: l_organization_name hr_organization_units.NAME%TYPE;

Line 95: l_organization_id per_assignments.organization_id%TYPE;

91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;
93: l_job_id per_assignments.job_id%TYPE;
94: l_location_id per_assignments.location_id%TYPE;
95: l_organization_id per_assignments.organization_id%TYPE;
96: l_proc VARCHAR2 (30) := 'AWGI :';
97: l_pay_basis per_pay_bases.pay_basis%TYPE;
98: l_organization_name hr_organization_units.NAME%TYPE;
99: l_org_address_line1 hr_locations.address_line_1%TYPE;

Line 2811: p_position_id IN per_assignments.position_id%TYPE,

2807: --
2808: --
2809: FUNCTION checkpoiparm (
2810: p_in_personnel_office_id IN OUT NOCOPY ghr_pa_requests.personnel_office_id%TYPE,
2811: p_position_id IN per_assignments.position_id%TYPE,
2812: p_effective_date IN ghr_pa_requests.effective_date%TYPE
2813: )
2814: RETURN BOOLEAN
2815: IS