[Home] [Help]
3856: pel.business_group_id per_business_group_id,
3857: per.business_group_id mgr_business_group_id,
3858: pel.ws_mgr_id
3859: from ben_pil_elctbl_chc_popl pel,
3860: per_all_people_f per
3861: where pel.per_in_ler_id = cv_per_in_ler_id
3862: and pel.ws_mgr_id = per.person_id (+)
3863: and l_effective_date between effective_start_date
3864: and effective_end_date;
3877: epe.business_group_id per_business_group_id,
3878: per.business_group_id mgr_business_group_id
3879: from ben_elig_per_elctbl_chc epe,
3880: ben_pil_elctbl_chc_popl pel,
3881: per_all_people_f per
3882: where epe.per_in_ler_id = cv_per_in_ler_id
3883: and epe.per_in_ler_id = pel.per_in_ler_id
3884: and epe.pl_id = pel.pl_id
3885: and epe.ws_mgr_id = per.person_id (+)
4393: epe.business_group_id per_business_group_id,
4394: per.business_group_id mgr_business_group_id
4395: from ben_elig_per_elctbl_chc epe,
4396: ben_pil_elctbl_chc_popl pel,
4397: per_all_people_f per
4398: where epe.per_in_ler_id = cv_per_in_ler_id
4399: and epe.per_in_ler_id = pel.per_in_ler_id
4400: and epe.pl_id = pel.pl_id
4401: and epe.ws_mgr_id = per.person_id (+)
7422: l_gsp_eval_elig_flag varchar2(30);
7423: --
7424: -- Bug:2237993 CWB
7425: --
7426: l_person_id per_all_people_f.person_id%type;
7427: cursor c_person_info is
7428: select person_id
7429: from ben_person_actions
7430: where benefit_action_id = p_benefit_action_id
8520: p_effective_date in date) is
8521: --
8522: l_package varchar2(80);
8523: l_output_string varchar2(100);
8524: l_per_rec per_all_people_f%rowtype;
8525: l_ass_rec per_all_assignments_f%rowtype;
8526: l_bus_rec per_business_groups%rowtype;
8527: l_org_rec hr_all_organization_units%rowtype;
8528: l_org2_rec hr_all_organization_units%rowtype;
8706: IS
8707: --
8708: l_package VARCHAR2 (80);
8709: l_output_string VARCHAR2 (100);
8710: l_per_rec per_all_people_f%ROWTYPE;
8711: l_ass_rec per_all_assignments_f%ROWTYPE;
8712: l_bus_rec per_business_groups%ROWTYPE;
8713: l_org_rec hr_all_organization_units%ROWTYPE;
8714: l_org2_rec hr_all_organization_units%ROWTYPE;
9893: l_parplip_row ben_plip_f%rowtype;
9894: l_parpl_row ben_pl_f%rowtype;
9895: l_paropt_row ben_cobj_cache.g_opt_inst_row;
9896: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
9897: l_per_row per_all_people_F%rowtype;
9898: l_pil_row ben_per_in_ler%rowtype;
9899: l_empasg_row per_all_assignments_f%rowtype;
9900: l_benasg_row per_all_assignments_f%rowtype;
9901: l_appasg_row ben_person_object.g_cache_ass_table;
12502: l_env ben_env_object.g_global_env_rec_type;
12503: l_encoded_message varchar2(2000);
12504: l_app_short_name varchar2(2000);
12505: l_message_name varchar2(2000);
12506: l_per_rec per_all_people_f%rowtype;
12507: p_prtt_cache varchar2(1) ;
12508: l_module varchar2(30);
12509: --
12510: begin