DBA Data[Home] [Help]

APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_RESP_PLAN_MAPPING

Line 1127: FROM ben_resp_plan_mapping mapg

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) )
1130: AND Nvl(p_pl_id, pl.group_pl_id) = pl.group_pl_id
1131: AND Nvl(p_lf_evt_ocrd_dt, pl.lf_evt_ocrd_dt) = pl.lf_evt_ocrd_dt