DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_ALL_PEOPLE_F

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

139: g_designations_remaining number(9) := 0;
140: g_max_errors_allowed number(9) := 200;
141: type g_report_rec is record
142: (
143: person_id /*per_people_f */per_all_people_f.person_id%type,
144: pgm_id ben_pgm_f.pgm_id%type,
145: pl_id ben_pl_f.pl_id%type,
146: oipl_id ben_oipl_f.oipl_id%type,
147: dpnt_cvg_strt_dt date,

Line 731: ,/*per_people_f*/ per_all_people_f ppf

727: /* end bug 2985206 */
728: and (p_benfts_grp_id is null
729: or exists(select null
730: from ben_benfts_grp bng
731: ,/*per_people_f*/ per_all_people_f ppf
732: where bng.benfts_grp_id = p_benfts_grp_id
733: and bng.business_group_id = pen.business_group_id
734: and ppf.person_id = pen.person_id
735: and ppf.benefit_group_id = bng.benfts_grp_id

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

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