[Home] [Help]
4248: pel.business_group_id per_business_group_id,
4249: per.business_group_id mgr_business_group_id,
4250: pel.ws_mgr_id
4251: from ben_pil_elctbl_chc_popl pel,
4252: per_all_people_f per
4253: where pel.per_in_ler_id = cv_per_in_ler_id
4254: and pel.ws_mgr_id = per.person_id (+)
4255: and l_effective_date between effective_start_date
4256: and effective_end_date;
4269: epe.business_group_id per_business_group_id,
4270: per.business_group_id mgr_business_group_id
4271: from ben_elig_per_elctbl_chc epe,
4272: ben_pil_elctbl_chc_popl pel,
4273: per_all_people_f per
4274: where epe.per_in_ler_id = cv_per_in_ler_id
4275: and epe.per_in_ler_id = pel.per_in_ler_id
4276: and epe.pl_id = pel.pl_id
4277: and epe.ws_mgr_id = per.person_id (+)
4785: epe.business_group_id per_business_group_id,
4786: per.business_group_id mgr_business_group_id
4787: from ben_elig_per_elctbl_chc epe,
4788: ben_pil_elctbl_chc_popl pel,
4789: per_all_people_f per
4790: where epe.per_in_ler_id = cv_per_in_ler_id
4791: and epe.per_in_ler_id = pel.per_in_ler_id
4792: and epe.pl_id = pel.pl_id
4793: and epe.ws_mgr_id = per.person_id (+)
7828: l_gsp_eval_elig_flag varchar2(30);
7829: --
7830: -- Bug:2237993 CWB
7831: --
7832: l_person_id per_all_people_f.person_id%type;
7833: cursor c_person_info is
7834: select person_id
7835: from ben_person_actions
7836: where benefit_action_id = p_benefit_action_id
8928: p_effective_date in date) is
8929: --
8930: l_package varchar2(80);
8931: l_output_string nvarchar2(100);
8932: l_per_rec per_all_people_f%rowtype;
8933: l_ass_rec per_all_assignments_f%rowtype;
8934: l_bus_rec per_business_groups%rowtype;
8935: l_org_rec hr_all_organization_units%rowtype;
8936: l_org2_rec hr_all_organization_units%rowtype;
9114: IS
9115: --
9116: l_package VARCHAR2 (80);
9117: l_output_string NVARCHAR2 (100);
9118: l_per_rec per_all_people_f%ROWTYPE;
9119: l_ass_rec per_all_assignments_f%ROWTYPE;
9120: l_bus_rec per_business_groups%ROWTYPE;
9121: l_org_rec hr_all_organization_units%ROWTYPE;
9122: l_org2_rec hr_all_organization_units%ROWTYPE;
10349: l_parplip_row ben_plip_f%rowtype;
10350: l_parpl_row ben_pl_f%rowtype;
10351: l_paropt_row ben_cobj_cache.g_opt_inst_row;
10352: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
10353: l_per_row per_all_people_F%rowtype;
10354: l_pil_row ben_per_in_ler%rowtype;
10355: l_empasg_row per_all_assignments_f%rowtype;
10356: l_benasg_row per_all_assignments_f%rowtype;
10357: l_appasg_row ben_person_object.g_cache_ass_table;
13123: l_env ben_env_object.g_global_env_rec_type;
13124: l_encoded_message varchar2(2000);
13125: l_app_short_name varchar2(2000);
13126: l_message_name varchar2(2000);
13127: l_per_rec per_all_people_f%rowtype;
13128: p_prtt_cache varchar2(1) ;
13129: l_module varchar2(30);
13130: --
13131: begin