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_PERSON_GROUPS_API dependencies on BEN_CWB_PL_DSGN

Line 431: from ben_cwb_pl_dsgn pl

427: end if;
428: --
429: select uses_bdgt_flag, prsrv_bdgt_cd
430: into l_uses_bdgt_flag, l_prsrv_bdgt_cd
431: from ben_cwb_pl_dsgn pl
432: where pl.pl_id = p_grp_bdgt_old.group_pl_id
433: and pl.lf_evt_ocrd_dt = p_grp_bdgt_old.lf_evt_ocrd_dt
434: and pl.oipl_id = p_grp_bdgt_old.group_oipl_id;
435: --

Line 579: l_pl_dsgn ben_cwb_pl_dsgn%rowtype;

575: procedure create_audit_record
576: (p_grp_bdgt_old in csr_grps%rowtype
577: ) is
578: l_grp_bdgt_new csr_grps%rowtype;
579: l_pl_dsgn ben_cwb_pl_dsgn%rowtype;
580: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
581: l_object_version_number ben_cwb_audit.object_version_number%type;
582: l_cd_meaning_old hr_lookups.meaning%type;
583: l_cd_meaning_new hr_lookups.meaning%type;

Line 600: from ben_cwb_pl_dsgn

596: fetch csr_grps into l_grp_bdgt_new;
597: close csr_grps;
598:
599: select * into l_pl_dsgn
600: from ben_cwb_pl_dsgn
601: where pl_id = p_grp_bdgt_old.group_pl_id
602: and lf_evt_ocrd_dt = p_grp_bdgt_old.lf_evt_ocrd_dt
603: and oipl_id = -1;
604: