APPS.BEN_FORFEITURE_CONCURRENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 474: from per_all_assignments_f paf

470: and bnb.effective_end_date;
471: --
472: cursor c_asg(p_assignment_type varchar2,p_person_id number ) is
473: select paf.assignment_id
474: from per_all_assignments_f paf
475: where paf.person_id = p_person_id
476: and paf.business_group_id = p_business_group_id
477: and paf.primary_flag = 'Y'
478: and paf.assignment_type = p_assignment_type

Line 483: l_ass_rec per_all_assignments_f%ROWTYPE;

479: and p_effective_date
480: between paf.effective_start_date
481: and paf.effective_end_date;
482: --
483: l_ass_rec per_all_assignments_f%ROWTYPE;
484: l_assignment_id number;
485: --
486: l_per_cntr_val number;
487: l_per_distr_val number;