DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_ALL_PEOPLE_F

Line 148: person_id /*per_people_f */per_all_people_f.person_id%type,

144: g_designations_remaining number(9) := 0;
145: g_max_errors_allowed number(9) := 200;
146: type g_report_rec is record
147: (
148: person_id /*per_people_f */per_all_people_f.person_id%type,
149: pgm_id ben_pgm_f.pgm_id%type,
150: pl_id ben_pl_f.pl_id%type,
151: oipl_id ben_oipl_f.oipl_id%type,
152: dpnt_cvg_strt_dt date,

Line 736: ,/*per_people_f*/ per_all_people_f ppf

732: /* end bug 2985206 */
733: and (p_benfts_grp_id is null
734: or exists(select null
735: from ben_benfts_grp bng
736: ,/*per_people_f*/ per_all_people_f ppf
737: where bng.benfts_grp_id = p_benfts_grp_id
738: and bng.business_group_id = pen.business_group_id
739: and ppf.person_id = pen.person_id
740: and ppf.benefit_group_id = bng.benfts_grp_id

Line 759: l_person_id /*per_people_f*/ per_all_people_f.person_id%type;

755: l_request_id number;
756: l_proc varchar2(80) := g_package||'.process';
757: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
758: l_object_version_number ben_benefit_actions.object_version_number%type;
759: l_person_id /*per_people_f*/ per_all_people_f.person_id%type;
760: l_person_action_id ben_person_actions.person_action_id%type;
761: l_ler_id ben_ler_f.ler_id%type;
762: l_range_id ben_batch_ranges.range_id%type;
763: l_chunk_size number := 20;