APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_CWB_XCHG

Line 270: FROM ben_cwb_xchg xchg

266: , asttl.assignment_status_type_id assignment_status_id
267: , ((per.base_salary * per.pay_annulization_factor / nvl (temp.planufactor, temp.grpufactor)) /
268: (
269: SELECT xchg_rate
270: FROM ben_cwb_xchg xchg
271: WHERE xchg.group_pl_id = temp.grpplid
272: AND xchg.lf_evt_ocrd_dt = temp.grplfevtocrddt
273: AND xchg.currency = per.base_salary_currency
274: )) corp_base_salary

Line 877: , ben_cwb_xchg plxchg

873: , ben_cwb_person_rates opt1rt
874: , ben_cwb_person_rates opt2rt
875: , ben_cwb_person_rates opt3rt
876: , ben_cwb_person_rates opt4rt
877: , ben_cwb_xchg plxchg
878: , ben_cwb_xchg opt1xchg
879: , ben_cwb_xchg opt2xchg
880: , ben_cwb_xchg opt3xchg
881: , ben_cwb_xchg opt4xchg

Line 878: , ben_cwb_xchg opt1xchg

874: , ben_cwb_person_rates opt2rt
875: , ben_cwb_person_rates opt3rt
876: , ben_cwb_person_rates opt4rt
877: , ben_cwb_xchg plxchg
878: , ben_cwb_xchg opt1xchg
879: , ben_cwb_xchg opt2xchg
880: , ben_cwb_xchg opt3xchg
881: , ben_cwb_xchg opt4xchg
882: , ben_per_in_ler pil

Line 879: , ben_cwb_xchg opt2xchg

875: , ben_cwb_person_rates opt3rt
876: , ben_cwb_person_rates opt4rt
877: , ben_cwb_xchg plxchg
878: , ben_cwb_xchg opt1xchg
879: , ben_cwb_xchg opt2xchg
880: , ben_cwb_xchg opt3xchg
881: , ben_cwb_xchg opt4xchg
882: , ben_per_in_ler pil
883: , ben_cwb_person_info per

Line 880: , ben_cwb_xchg opt3xchg

876: , ben_cwb_person_rates opt4rt
877: , ben_cwb_xchg plxchg
878: , ben_cwb_xchg opt1xchg
879: , ben_cwb_xchg opt2xchg
880: , ben_cwb_xchg opt3xchg
881: , ben_cwb_xchg opt4xchg
882: , ben_per_in_ler pil
883: , ben_cwb_person_info per
884: , per_assignment_status_types_tl asttl

Line 881: , ben_cwb_xchg opt4xchg

877: , ben_cwb_xchg plxchg
878: , ben_cwb_xchg opt1xchg
879: , ben_cwb_xchg opt2xchg
880: , ben_cwb_xchg opt3xchg
881: , ben_cwb_xchg opt4xchg
882: , ben_per_in_ler pil
883: , ben_cwb_person_info per
884: , per_assignment_status_types_tl asttl
885: , hr_all_organization_units_tl bgtl