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 4025: l_transfer_name ghr_mass_transfers.name%type;

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

Line 4141: 'GHR_MASS_TRANSFERS for mass_transfer_id:'||

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