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

Line 1521: (epe.elctbl_flag='Y' or ('Y' = (select 'Y' from dual

1517: epe.per_in_ler_id=pil.per_in_ler_id and
1518: epe.pl_id =p_pl_id and
1519: /*Bug 8528791 : Added the below condition to pick the interim if the LE has no electability */
1520: --epe.elctbl_flag='Y' and
1521: (epe.elctbl_flag='Y' or ('Y' = (select 'Y' from dual
1522: where not exists
1523: (select 'Y' from ben_elig_per_elctbl_chc epe1,
1524: ben_per_in_ler pil1
1525: where epe1.pl_id =p_pl_id

Line 1570: (epe.elctbl_flag='Y' or ('Y' = (select 'Y' from dual

1566: epe.per_in_ler_id=pil.per_in_ler_id and
1567: epe.pl_typ_id =p_pl_typ_id and
1568: /*Bug 8528791 : Added the below condition to pick the interim if the LE has no electability */
1569: --epe.elctbl_flag='Y' and
1570: (epe.elctbl_flag='Y' or ('Y' = (select 'Y' from dual
1571: where not exists
1572: (select 'Y' from ben_elig_per_elctbl_chc epe1,
1573: ben_per_in_ler pil1
1574: where epe1.pl_typ_id =p_pl_typ_id