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_LF_EVT_CLPS_RESTORE dependencies on DUAL

Line 5455: decode( (select 'Y' from dual where exists

5451: pbn.BUSINESS_GROUP_ID,
5452: pbn.PER_IN_LER_ID,
5453: pbn.pbn_ATTRIBUTE_CATEGORY,
5454: /* Bug 12964358: Check whether there are date track updated records after the effective_start_date*/
5455: decode( (select 'Y' from dual where exists
5456: (select 'Y' from ben_pl_bnf_f pbn1
5457: where pbn1.per_in_ler_id = pbn.per_in_ler_id
5458: and pbn1.prtt_enrt_rslt_id = pbn.prtt_enrt_rslt_id
5459: and pbn1.business_group_id = pbn.business_group_id

Line 5527: decode( (select 'Y' from dual where exists

5523: pbn.BUSINESS_GROUP_ID,
5524: pbn.PER_IN_LER_ID,
5525: pbn.LCR_ATTRIBUTE_CATEGORY,
5526: /* Bug 12964358: Check whether there are date track updated records after the effective_start_date*/
5527: decode( (select 'Y' from dual where exists
5528: (select 'Y' from ben_le_clsn_n_rstr pbn1
5529: where pbn1.per_in_ler_id = pbn.per_in_ler_id
5530: and pbn1.prtt_enrt_rslt_id = pbn.prtt_enrt_rslt_id
5531: and pbn1.business_group_id = pbn.business_group_id

Line 10062: select '1' from dual where exists

10058: l_env_obj ben_env_object.g_global_env_rec_type;
10059:
10060: /*Bug 13711703 */
10061: cursor c_reopen_le is
10062: select '1' from dual where exists
10063: (select '1' from ben_pil_elctbl_chc_popl pel
10064: where pel.per_in_ler_id = p_per_in_ler_id
10065: and pel.reopen_le_on_reprocess = 'Y');
10066: l_reopen_le_on_reprocess varchar2(30);