DBA Data[Home] [Help]

APPS.BEN_FORFEITURE_CONCURRENT dependencies on PER_ALL_PEOPLE_F

Line 415: per_all_people_f per

411: /* pen.prtt_enrt_rslt_id, pen.person_id, pen.pl_id, pen.oipl_id,
412: pen.pgm_id, pen.pl_typ_id
413: */
414: from ben_prtt_enrt_rslt_f pen,
415: per_all_people_f per
416: where per.person_id = pen.person_id
417: and per.business_group_id = pen.business_group_id
418: and p_effective_date between per.effective_start_date
419: and per.effective_end_date

Line 495: l_per_rec per_all_people_f%rowtype;

491: l_total_frfd_val number;
492: l_assignment_action_id number;
493: l_start_date date;
494: l_end_date date;
495: l_per_rec per_all_people_f%rowtype;
496: l_err_message varchar2(1000) ;
497: --
498: begin
499: --