APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on BEN_CWB_PL_DSGN

Line 513: , ben_cwb_pl_dsgn dsgn

509: ,p_lf_evt_dt date) is
510: select HRCHY_TO_USE_CD
511: from
512: BEN_ENRT_PERD enrt
513: , ben_cwb_pl_dsgn dsgn
514: where dsgn.pl_id = p_group_pl_id
515: and enrt.enrt_perd_id = dsgn.enrt_perd_id
516: and dsgn.lf_evt_ocrd_dt= p_lf_evt_dt;
517:

Line 848: l_group_pl_name ben_cwb_pl_dsgn.name%type;

844: ,p_pp_stat_cd out nocopy varchar2
845: ,p_pl_id out nocopy number) is
846: --
847: l_group_per_in_ler_id number;
848: l_group_pl_name ben_cwb_pl_dsgn.name%type;
849: l_plan_name ben_cwb_pl_dsgn.name%type;
850: l_prsrv_bdgt_cd ben_cwb_pl_dsgn.prsrv_bdgt_cd%type;
851: l_period varchar2(80);
852: l_elig_status varchar2(80);

Line 849: l_plan_name ben_cwb_pl_dsgn.name%type;

845: ,p_pl_id out nocopy number) is
846: --
847: l_group_per_in_ler_id number;
848: l_group_pl_name ben_cwb_pl_dsgn.name%type;
849: l_plan_name ben_cwb_pl_dsgn.name%type;
850: l_prsrv_bdgt_cd ben_cwb_pl_dsgn.prsrv_bdgt_cd%type;
851: l_period varchar2(80);
852: l_elig_status varchar2(80);
853: l_event_status varchar2(80);

Line 850: l_prsrv_bdgt_cd ben_cwb_pl_dsgn.prsrv_bdgt_cd%type;

846: --
847: l_group_per_in_ler_id number;
848: l_group_pl_name ben_cwb_pl_dsgn.name%type;
849: l_plan_name ben_cwb_pl_dsgn.name%type;
850: l_prsrv_bdgt_cd ben_cwb_pl_dsgn.prsrv_bdgt_cd%type;
851: l_period varchar2(80);
852: l_elig_status varchar2(80);
853: l_event_status varchar2(80);
854: l_pp_stat_cd varchar2(80);

Line 920: ,ben_cwb_pl_dsgn grppln

916: ,l_event_status
917: ,l_pp_stat_cd
918: ,l_pl_id
919: from ben_per_in_ler pil
920: ,ben_cwb_pl_dsgn grppln
921: ,ben_cwb_pl_dsgn pln
922: ,ben_cwb_person_rates rates
923: ,ben_cwb_person_info per
924: ,hr_lookups elig_stat

Line 921: ,ben_cwb_pl_dsgn pln

917: ,l_pp_stat_cd
918: ,l_pl_id
919: from ben_per_in_ler pil
920: ,ben_cwb_pl_dsgn grppln
921: ,ben_cwb_pl_dsgn pln
922: ,ben_cwb_person_rates rates
923: ,ben_cwb_person_info per
924: ,hr_lookups elig_stat
925: ,hr_lookups event_stat