APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on FND_PROFILE

Line 896: fnd_profile.value ('BEN_DISPLAY_EMPLOYEE_NAME') name_profile

892: , per_grades_tl grdtl
893: ,
894: (
895: SELECT /*+ merge leading(grp_pl)*/
896: fnd_profile.value ('BEN_DISPLAY_EMPLOYEE_NAME') name_profile
897: , nvl (fnd_profile.value ('BEN_CWB_WS_PCT_ES_DECS_DISP'), 2) pct_decs
898: , pl1.pl_id plid
899: , pl1.name plname
900: , pl1.oipl_id ploiplid

Line 897: , nvl (fnd_profile.value ('BEN_CWB_WS_PCT_ES_DECS_DISP'), 2) pct_decs

893: ,
894: (
895: SELECT /*+ merge leading(grp_pl)*/
896: fnd_profile.value ('BEN_DISPLAY_EMPLOYEE_NAME') name_profile
897: , nvl (fnd_profile.value ('BEN_CWB_WS_PCT_ES_DECS_DISP'), 2) pct_decs
898: , pl1.pl_id plid
899: , pl1.name plname
900: , pl1.oipl_id ploiplid
901: , pl1.ws_abr_id plwsabrid

Line 1123: AND ( fnd_profile.Value('HR_CROSS_BUSINESS_GROUP') = 'Y'

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'
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

Line 1125: AND ( Nvl(fnd_profile.Value('BEN_CWB_PLAN_SECURITY'), 'N') = 'N'

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
1129: AND mapg.pl_id = pl.pl_id) )

Line 1169: AND fnd_profile.Value('BEN_CWB_PLAN_SECURITY') <> 'Y' ) THEN

1165: END IF;
1166:
1167: IF ( P_GROUP_PL_ID IS NULL
1168: AND P_LF_EVT_OCRD_DT IS NULL
1169: AND fnd_profile.Value('BEN_CWB_PLAN_SECURITY') <> 'Y' ) THEN
1170: ben_cwb_cd_summary_pkg.Message_log_proc('Plan Security is disabled', 30);
1171:
1172: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||table_name_var;
1173: