APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on FND_GLOBAL

Line 869: , fnd_global.conc_request_id conc_request_id

865: AND hrchy1.lvl_num = 1
866: AND hrchy1.mgr_per_in_ler_id = mgrper.group_per_in_ler_id
867: ) wrk_mgr_name
868: , temp.grpcurr corp_currency
869: , fnd_global.conc_request_id conc_request_id
870: , NULL start_date
871: , NULL end_date
872: FROM ben_cwb_person_rates plrt
873: , ben_cwb_person_rates opt1rt

Line 1128: WHERE mapg.responsibility_id = fnd_global.resp_id

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
1132: ORDER BY pl.pl_id,

Line 1135: SELECT FND_GLOBAL.conc_request_id

1131: AND Nvl(p_lf_evt_ocrd_dt, pl.lf_evt_ocrd_dt) = pl.lf_evt_ocrd_dt
1132: ORDER BY pl.pl_id,
1133: pl.lf_evt_ocrd_dt;
1134: BEGIN
1135: SELECT FND_GLOBAL.conc_request_id
1136: INTO conc_prog_id
1137: FROM DUAL;
1138:
1139: SELECT s.table_owner

Line 1158: IF fnd_global.conc_request_id = -1

1154: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Purge or Not : '||Nvl(P_PURGE, 'Not Mentioned'), 10);
1155:
1156: l_check_var := BEN_CWB_CD_SUMMARY_PKG.check_refresh_jobs;
1157:
1158: IF fnd_global.conc_request_id = -1
1159: AND l_check_var = 1 THEN
1160: ben_cwb_cd_summary_pkg.Message_log_proc('This Concurrent Program already in Progress, Cannot run this request', 20);
1161:
1162: fnd_message.Set_name('BEN', 'BEN_CWB_CD_REFRESH_RUNG');