APPS.GHR_MTO_INT dependencies on GHR_MASS_TRANSFERS

Line 243: from ghr_mass_transfers

239: p_inter_bg_transfer out nocopy varchar2) is
240:
241: cursor cur_eff_date is
242: select effective_date, name, within_bg_transfer
243: from ghr_mass_transfers
244: where mass_transfer_id = p_mass_transfer_id;
245:
246: l_effdate date;
247: l_name ghr_mass_transfers.name%type;

Line 247: l_name ghr_mass_transfers.name%type;

243: from ghr_mass_transfers
244: where mass_transfer_id = p_mass_transfer_id;
245:
246: l_effdate date;
247: l_name ghr_mass_transfers.name%type;
248: l_bg_tran ghr_mass_transfers.within_bg_transfer%type;
249: l_proc varchar2(72) := g_package||'get_transfer_parameters';
250:
251: begin

Line 248: l_bg_tran ghr_mass_transfers.within_bg_transfer%type;

244: where mass_transfer_id = p_mass_transfer_id;
245:
246: l_effdate date;
247: l_name ghr_mass_transfers.name%type;
248: l_bg_tran ghr_mass_transfers.within_bg_transfer%type;
249: l_proc varchar2(72) := g_package||'get_transfer_parameters';
250:
251: begin
252:

Line 4024: l_transfer_name ghr_mass_transfers.name%type;

4020: l_proc_name varchar2(30) := 'mass_transfer_out';
4021: l_proc varchar2(72) := g_package||l_proc_name;
4022:
4023: l_effdate date;
4024: l_transfer_name ghr_mass_transfers.name%type;
4025: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4026:
4027: l_position_id per_assignments_f.position_id%type;
4028: l_location_id per_assignments_f.location_id%type;

Line 4140: 'GHR_MASS_TRANSFERS for mass_transfer_id:'||

4136:
4137: log_message(
4138: p_procedure => l_proc_name,
4139: p_message => 'Failed to get Transfer Out information from'||
4140: 'GHR_MASS_TRANSFERS for mass_transfer_id:'||
4141: p_transfer_id);
4142: commit;
4143: hr_utility.set_message(8301, 'GHR_38534_MT_ID_ERR');
4144: hr_utility.raise_error;