DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_ELIG dependencies on PER_POSITION_EXTRA_INFO

Line 57: l_pos_ei_data per_position_extra_info%rowtype;

53: l_ors_exists boolean;
54: l_pay_plan_exists boolean;
55: l_grade_exists boolean;
56: l_count number := 0;
57: l_pos_ei_data per_position_extra_info%rowtype;
58: l_effective_date date;
59: l_duty_station_code ghr_duty_stations_f.duty_station_code%type;
60: l_errbuf varchar2(2000);
61: l_retcode number;

Line 112: from per_position_extra_info pos

108:
109: --Bug#2459352
110: cursor c_fed_employee(c_position_id IN NUMBER) is
111: select pos.position_extra_info_id
112: from per_position_extra_info pos
113: where pos.position_id = c_position_id
114: and pos.information_type = 'GHR_US_POS_VALID_GRADE';
115:
116: