959: , ben_cwb_pl_dsgn opt1
960: , ben_cwb_pl_dsgn opt2
961: , ben_cwb_pl_dsgn opt3
962: , ben_cwb_pl_dsgn opt4
963: , hr_lookups hrl1
964: , hr_lookups hrl2
965: , hr_lookups hrl3
966: , hr_lookups hrl4
967: , hr_lookups hrl5
960: , ben_cwb_pl_dsgn opt2
961: , ben_cwb_pl_dsgn opt3
962: , ben_cwb_pl_dsgn opt4
963: , hr_lookups hrl1
964: , hr_lookups hrl2
965: , hr_lookups hrl3
966: , hr_lookups hrl4
967: , hr_lookups hrl5
968: WHERE p_group_pl_id = grp_pl.pl_id
961: , ben_cwb_pl_dsgn opt3
962: , ben_cwb_pl_dsgn opt4
963: , hr_lookups hrl1
964: , hr_lookups hrl2
965: , hr_lookups hrl3
966: , hr_lookups hrl4
967: , hr_lookups hrl5
968: WHERE p_group_pl_id = grp_pl.pl_id
969: AND p_lf_evt_ocrd_dt = grp_pl.lf_evt_ocrd_dt
962: , ben_cwb_pl_dsgn opt4
963: , hr_lookups hrl1
964: , hr_lookups hrl2
965: , hr_lookups hrl3
966: , hr_lookups hrl4
967: , hr_lookups hrl5
968: WHERE p_group_pl_id = grp_pl.pl_id
969: AND p_lf_evt_ocrd_dt = grp_pl.lf_evt_ocrd_dt
970: AND grp_pl.oipl_id = - 1
963: , hr_lookups hrl1
964: , hr_lookups hrl2
965: , hr_lookups hrl3
966: , hr_lookups hrl4
967: , hr_lookups hrl5
968: WHERE p_group_pl_id = grp_pl.pl_id
969: AND p_lf_evt_ocrd_dt = grp_pl.lf_evt_ocrd_dt
970: AND grp_pl.oipl_id = - 1
971: AND grp_pl.group_pl_id = grp_pl.pl_id