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 160: l_pl_id ben_cwb_pl_dsgn.pl_id%type;

156: l_object_version_number ben_cwb_audit.object_version_number%type;
157: l_cd_meaning_old hr_lookups.meaning%type;
158: l_cd_meaning_new hr_lookups.meaning%type;
159: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
160: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
161: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
162: l_person_id fnd_user.employee_id%type;
163: --
164: cursor c_per_in_ler is

Line 161: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;

157: l_cd_meaning_old hr_lookups.meaning%type;
158: l_cd_meaning_new hr_lookups.meaning%type;
159: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
160: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
161: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
162: l_person_id fnd_user.employee_id%type;
163: --
164: cursor c_per_in_ler is
165: select inf.group_per_in_ler_id

Line 169: ,ben_cwb_pl_dsgn pl

165: select inf.group_per_in_ler_id
166: ,inf.group_pl_id pl_id
167: ,inf.lf_evt_ocrd_dt
168: from ben_cwb_person_info inf
169: ,ben_cwb_pl_dsgn pl
170: where inf.assignment_id = p_txn_old.transaction_id
171: and inf.group_pl_id = p_group_pl_id
172: and inf.group_pl_id = pl.pl_id
173: and inf.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt

Line 318: l_pl_id ben_cwb_pl_dsgn.pl_id%type;

314: l_object_version_number ben_cwb_audit.object_version_number%type;
315: l_cd_meaning_old varchar2(240);
316: l_cd_meaning_new varchar2(240);
317: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
318: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
319: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
320: l_lang varchar2(30);
321: l_temp varchar2(30);
322: l_person_id fnd_user.employee_id%type;

Line 319: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;

315: l_cd_meaning_old varchar2(240);
316: l_cd_meaning_new varchar2(240);
317: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
318: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
319: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
320: l_lang varchar2(30);
321: l_temp varchar2(30);
322: l_person_id fnd_user.employee_id%type;
323:

Line 330: ,ben_cwb_pl_dsgn pl

326: select inf.group_per_in_ler_id
327: ,inf.group_pl_id pl_id
328: ,inf.lf_evt_ocrd_dt
329: from ben_cwb_person_info inf
330: ,ben_cwb_pl_dsgn pl
331: where inf.assignment_id = p_txn_old.transaction_id
332: and inf.group_pl_id = p_group_pl_id
333: and inf.group_pl_id = pl.pl_id
334: and inf.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt