eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_ASG_UPDATE dependencies on BEN_CWB_PL_DSGN

Line 165: l_pl_id ben_cwb_pl_dsgn.pl_id%type;

161: l_object_version_number ben_cwb_audit.object_version_number%type;
162: l_cd_meaning_old hr_lookups.meaning%type;
163: l_cd_meaning_new hr_lookups.meaning%type;
164: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
165: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
166: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
167: l_person_id fnd_user.employee_id%type;
168: --
169: cursor c_per_in_ler is

Line 166: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;

162: l_cd_meaning_old hr_lookups.meaning%type;
163: l_cd_meaning_new hr_lookups.meaning%type;
164: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
165: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
166: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
167: l_person_id fnd_user.employee_id%type;
168: --
169: cursor c_per_in_ler is
170: select inf.group_per_in_ler_id

Line 174: ,ben_cwb_pl_dsgn pl

170: select inf.group_per_in_ler_id
171: ,inf.group_pl_id pl_id
172: ,inf.lf_evt_ocrd_dt
173: from ben_cwb_person_info inf
174: ,ben_cwb_pl_dsgn pl
175: where inf.assignment_id = p_txn_old.transaction_id
176: and inf.group_pl_id = p_group_pl_id
177: and inf.group_pl_id = pl.pl_id
178: and inf.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt

Line 323: l_pl_id ben_cwb_pl_dsgn.pl_id%type;

319: l_object_version_number ben_cwb_audit.object_version_number%type;
320: l_cd_meaning_old varchar2(240);
321: l_cd_meaning_new varchar2(240);
322: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
323: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
324: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
325: l_lang varchar2(30);
326: l_temp varchar2(30);
327: l_person_id fnd_user.employee_id%type;

Line 324: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;

320: l_cd_meaning_old varchar2(240);
321: l_cd_meaning_new varchar2(240);
322: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
323: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
324: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
325: l_lang varchar2(30);
326: l_temp varchar2(30);
327: l_person_id fnd_user.employee_id%type;
328:

Line 335: ,ben_cwb_pl_dsgn pl

331: select inf.group_per_in_ler_id
332: ,inf.group_pl_id pl_id
333: ,inf.lf_evt_ocrd_dt
334: from ben_cwb_person_info inf
335: ,ben_cwb_pl_dsgn pl
336: where inf.assignment_id = p_txn_old.transaction_id
337: and inf.group_pl_id = p_group_pl_id
338: and inf.group_pl_id = pl.pl_id
339: and inf.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt