APPS.BEN_EFC_ADJUSTMENTS dependencies on PER_ALL_PEOPLE_F

Line 533: per_all_people_f per

529: pil.ler_id,
530: pil.per_in_ler_stat_cd
531: from BEN_ELIG_PER_ELCTBL_CHC epe,
532: ben_per_in_ler pil,
533: per_all_people_f per
534: where pil.per_in_ler_id = epe.per_in_ler_id
535: and epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
536: and per.person_id = pil.person_id
537: and pil.lf_evt_ocrd_dt

Line 556: per_all_people_f per

552: enb.val
553: from ben_enrt_bnft enb,
554: BEN_ELIG_PER_ELCTBL_CHC epe,
555: ben_per_in_ler pil,
556: per_all_people_f per
557: where enb.ELIG_PER_ELCTBL_CHC_id = epe.ELIG_PER_ELCTBL_CHC_id
558: and pil.per_in_ler_id = epe.per_in_ler_id
559: and enb.enrt_bnft_id = c_enb_id
560: and per.person_id = pil.person_id

Line 1501: l_per_row per_all_people_f%ROWTYPE;

1497: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
1498: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1499: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1500: l_df_counts ben_efc_functions.g_attach_df_counts;
1501: l_per_row per_all_people_f%ROWTYPE;
1502: l_empasg_row per_all_assignments_f%ROWTYPE;
1503: l_benasg_row per_all_assignments_f%ROWTYPE;
1504: l_pil_row ben_per_in_ler%rowtype;
1505: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;

Line 1556: ||' per_all_people_f per ';

1552: end if;
1553: --
1554: l_from_str := ' FROM ben_elig_per_f pep, '
1555: ||' ben_per_in_ler pil, '
1556: ||' per_all_people_f per ';
1557: --
1558: l_where_str := ' where pep.per_in_ler_id = pil.per_in_ler_id '
1559: ||' and (pep.comp_ref_amt is not null '
1560: ||' or pep.rt_comp_ref_amt is not null) '

Line 2131: l_per_row per_all_people_f%ROWTYPE;

2127: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
2128: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2129: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2130: l_df_counts ben_efc_functions.g_attach_df_counts;
2131: l_per_row per_all_people_f%ROWTYPE;
2132: l_empasg_row per_all_assignments_f%ROWTYPE;
2133: l_benasg_row per_all_assignments_f%ROWTYPE;
2134: l_pil_row ben_per_in_ler%rowtype;
2135: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;

Line 2245: ||' per_all_people_f per ';

2241: --
2242: l_from_str := ' FROM ben_elig_per_opt_f epo, '
2243: ||' ben_elig_per_f pep, '
2244: ||' ben_per_in_ler pil, '
2245: ||' per_all_people_f per ';
2246: --
2247: l_where_str := ' where epo.elig_per_id = pep.elig_per_id '
2248: ||' and epo.effective_start_date '
2249: ||' between pep.effective_start_date and pep.effective_end_date '

Line 2971: per_all_people_f per

2967: from per_pay_proposals ppp,
2968: per_assignments_f asg,
2969: per_pay_bases ppb,
2970: pay_all_payrolls_f paf,
2971: per_all_people_f per
2972: where per.person_id = c_person_id
2973: and asg.assignment_type <> 'C'
2974: and asg.person_id = per.person_id
2975: and asg.primary_flag = 'Y'

Line 3024: ||' per_all_people_f per ';

3020: --
3021: l_from_str := ' FROM ben_enrt_bnft enb, '
3022: ||' BEN_ELIG_PER_ELCTBL_CHC epe, '
3023: ||' ben_per_in_ler pil, '
3024: ||' per_all_people_f per ';
3025: --
3026: l_where_str := ' where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id '
3027: ||' and epe.per_in_ler_id = pil.per_in_ler_id '
3028: ||' and pil.person_id = per.person_id '

Line 4600: l_per_row per_all_people_F%rowtype;

4596: l_detected boolean;
4597: l_pk1 number;
4598: --
4599: l_currepe_row ben_determine_rates.g_curr_epe_rec;
4600: l_per_row per_all_people_F%rowtype;
4601: l_asg_row per_all_assignments_f%rowtype;
4602: l_ast_row per_assignment_status_types%rowtype;
4603: l_adr_row per_addresses%rowtype;
4604: --