APPS.BEN_CWB_XCHG_PKG dependencies on BEN_CWB_PL_DSGN

Line 36: from ben_cwb_pl_dsgn

32: p_effective_date date) is
33: select pl_uom
34: ,nvl(p_effective_date, nvl(data_freeze_date, lf_evt_ocrd_dt))
35: ,business_group_id
36: from ben_cwb_pl_dsgn
37: where pl_id = p_group_pl_id
38: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
39: and oipl_id = -1;
40:

Line 233: l_xchg_rec.xchg_rate := ben_cwb_pl_dsgn_pkg.get_exchg_rate(l_pl_uom

229: --
230: l_xchg_rec.currency := xchg_rec.lCurrency;
231: l_xchg_rec.group_pl_id := p_group_pl_id;
232: l_xchg_rec.lf_evt_ocrd_dt := p_lf_evt_ocrd_dt;
233: l_xchg_rec.xchg_rate := ben_cwb_pl_dsgn_pkg.get_exchg_rate(l_pl_uom
234: ,xchg_rec.lCurrency
235: ,l_effective_date
236: ,l_bg_id);
237: --check for rate to be null

Line 274: l_xchg_rec.xchg_rate := ben_cwb_pl_dsgn_pkg.get_exchg_rate(l_pl_uom

270: --
271: l_xchg_rec.currency := xchg_rec.lCurrency;
272: l_xchg_rec.group_pl_id := p_group_pl_id;
273: l_xchg_rec.lf_evt_ocrd_dt := p_lf_evt_ocrd_dt;
274: l_xchg_rec.xchg_rate := ben_cwb_pl_dsgn_pkg.get_exchg_rate(l_pl_uom
275: ,xchg_rec.lCurrency
276: ,l_effective_date
277: ,l_bg_id);
278: --