DBA Data[Home] [Help]

APPS.BEN_CWB_XCHG_PKG dependencies on BEN_CWB_PERSON_RATES

Line 110: from ben_cwb_person_rates cpr

106:
107: UNION
108:
109: select distinct cpr.currency lCurrency
110: from ben_cwb_person_rates cpr
111: ,ben_cwb_person_info cpi
112: where cpr.group_per_in_ler_id = cpi.group_per_in_ler_id
113: and cpi.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
114: and cpi.group_pl_id = p_group_pl_id

Line 131: from ben_cwb_person_rates cpr

127:
128: UNION
129:
130: select distinct cpr.currency lCurrency
131: from ben_cwb_person_rates cpr
132: where cpr.group_pl_id = p_group_pl_id
133: and cpr.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
134: and cpr.currency is not null
135: