APPS.BEN_EXT_CHLG dependencies on BEN_EXT_CHG_EVT_LOG

Line 136: FROM ben_ext_chg_evt_log a

132: ) return boolean is
133: --
134: cursor get_change is
135: SELECT null
136: FROM ben_ext_chg_evt_log a
137: WHERE a.person_id = p_person_id
138: AND a.chg_evt_cd = p_chg_evt_cd
139: AND trunc(a.chg_eff_dt) = trunc(p_chg_eff_dt);
140: --

Line 5911: l_old_user_person_type ben_ext_chg_evt_log.old_val1%TYPE;

5907: l_chg_eff_dt date;
5908: l_count number := 0;
5909: l_ext_chg_evt_log_id number;
5910: l_object_version_number number;
5911: l_old_user_person_type ben_ext_chg_evt_log.old_val1%TYPE;
5912: l_old_person_typ ben_ext_chg_evt_log.old_val1%TYPE;
5913: l_new_user_person_type ben_ext_chg_evt_log.new_val1%TYPE;
5914: -- Bug 4705814.
5915: --

Line 5912: l_old_person_typ ben_ext_chg_evt_log.old_val1%TYPE;

5908: l_count number := 0;
5909: l_ext_chg_evt_log_id number;
5910: l_object_version_number number;
5911: l_old_user_person_type ben_ext_chg_evt_log.old_val1%TYPE;
5912: l_old_person_typ ben_ext_chg_evt_log.old_val1%TYPE;
5913: l_new_user_person_type ben_ext_chg_evt_log.new_val1%TYPE;
5914: -- Bug 4705814.
5915: --
5916: l_proc varchar2(72) := 'ben_ext_chlg.log_ptu_chg';

Line 5913: l_new_user_person_type ben_ext_chg_evt_log.new_val1%TYPE;

5909: l_ext_chg_evt_log_id number;
5910: l_object_version_number number;
5911: l_old_user_person_type ben_ext_chg_evt_log.old_val1%TYPE;
5912: l_old_person_typ ben_ext_chg_evt_log.old_val1%TYPE;
5913: l_new_user_person_type ben_ext_chg_evt_log.new_val1%TYPE;
5914: -- Bug 4705814.
5915: --
5916: l_proc varchar2(72) := 'ben_ext_chlg.log_ptu_chg';
5917: --