APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_CWB_PL_DSGN

Line 957: FROM ben_cwb_pl_dsgn grp_pl

953: , grp_pl.ws_abr_id grpwsabrid
954: , grp_pl.pl_annulization_factor grpufactor
955: , hr_general.decode_lookup ('BEN_NNMNTRY_UOM', grp_pl.ws_nnmntry_uom) grpunits
956: , grp_pl.pl_uom grpcurr
957: FROM ben_cwb_pl_dsgn grp_pl
958: , ben_cwb_pl_dsgn pl1
959: , ben_cwb_pl_dsgn opt1
960: , ben_cwb_pl_dsgn opt2
961: , ben_cwb_pl_dsgn opt3

Line 958: , ben_cwb_pl_dsgn pl1

954: , grp_pl.pl_annulization_factor grpufactor
955: , hr_general.decode_lookup ('BEN_NNMNTRY_UOM', grp_pl.ws_nnmntry_uom) grpunits
956: , grp_pl.pl_uom grpcurr
957: FROM ben_cwb_pl_dsgn grp_pl
958: , ben_cwb_pl_dsgn pl1
959: , ben_cwb_pl_dsgn opt1
960: , ben_cwb_pl_dsgn opt2
961: , ben_cwb_pl_dsgn opt3
962: , ben_cwb_pl_dsgn opt4

Line 959: , ben_cwb_pl_dsgn opt1

955: , hr_general.decode_lookup ('BEN_NNMNTRY_UOM', grp_pl.ws_nnmntry_uom) grpunits
956: , grp_pl.pl_uom grpcurr
957: FROM ben_cwb_pl_dsgn grp_pl
958: , ben_cwb_pl_dsgn pl1
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

Line 960: , ben_cwb_pl_dsgn opt2

956: , grp_pl.pl_uom grpcurr
957: FROM ben_cwb_pl_dsgn grp_pl
958: , ben_cwb_pl_dsgn pl1
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

Line 961: , ben_cwb_pl_dsgn opt3

957: FROM ben_cwb_pl_dsgn grp_pl
958: , ben_cwb_pl_dsgn pl1
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

Line 962: , ben_cwb_pl_dsgn opt4

958: , ben_cwb_pl_dsgn pl1
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

Line 1119: FROM ben_cwb_pl_dsgn pl

1115: p_lf_evt_ocrd_dt DATE) IS
1116: SELECT DISTINCT pl.pl_id,
1117: pl.name,
1118: pl.lf_evt_ocrd_dt
1119: FROM ben_cwb_pl_dsgn pl
1120: WHERE pl.pl_stat_cd IN ( 'A', 'I' )
1121: AND pl.group_pl_id = pl.pl_id
1122: AND pl.oipl_id = -1
1123: AND ( fnd_profile.Value('HR_CROSS_BUSINESS_GROUP') = 'Y'