APPS.GHR_BENEFITS_EIT dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: p_assignment_id per_all_assignments_f.assignment_id%type,

8: p_business_group_id per_all_people_f.business_group_id%type,
9: p_pl_code ben_pl_f.short_code%type,
10: p_opt_code ben_opt_f.short_code%type,
11: p_pre_tax varchar2,
12: p_assignment_id per_all_assignments_f.assignment_id%type,
13: p_temps_total_cost varchar2,
14: p_temp_appt varchar2 default 'N')
15: IS
16: -- Cursor to get Program

Line 261: from per_all_assignments_f asg

257:
258: cursor c_chk_asg_exists(p_effective_date in date)
259: is
260: select 1
261: from per_all_assignments_f asg
262: where asg.assignment_id = p_assignment_id
263: and p_effective_date between asg.effective_start_date
264: and asg.effective_end_date;
265:

Line 972: p_assignment_id per_all_assignments_f.assignment_id%type) IS

968: p_effective_date VARCHAR2,
969: p_business_group_id per_all_people_f.business_group_id%type,
970: p_pl_code ben_pl_f.short_code%type,
971: p_opt_code ben_opt_f.short_code%type,
972: p_assignment_id per_all_assignments_f.assignment_id%type) IS
973:
974: -- Cursor to get Program
975: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
976: c_business_group_id ben_pgm_f.business_group_id%type,