DBA Data[Home] [Help]

APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on HR_GENERAL

Line 955: , hr_general.decode_lookup ('BEN_NNMNTRY_UOM', grp_pl.ws_nnmntry_uom) grpunits

951: , grp_pl.emp_interview_typ_cd perf_type
952: , to_char (grp_pl.asg_updt_eff_date, 'yyyy/mm/dd') asg_date
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

Line 1124: OR hr_general.get_business_group_id = pl.business_group_id )

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'
1124: OR hr_general.get_business_group_id = pl.business_group_id )
1125: AND ( Nvl(fnd_profile.Value('BEN_CWB_PLAN_SECURITY'), 'N') = 'N'
1126: OR EXISTS (SELECT NULL
1127: FROM ben_resp_plan_mapping mapg
1128: WHERE mapg.responsibility_id = fnd_global.resp_id