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_ELP_CACHE dependencies on BEN_PRTN_ELIG_PRFL_F

Line 269: from ben_prtn_elig_prfl_f mas2

265: WHERE MAS1.BUSINESS_GROUP_ID = c_business_group_id
266: AND c_effective_date
267: BETWEEN MAS1.EFFECTIVE_START_DATE AND MAS1.EFFECTIVE_END_DATE
268: and exists(select null
269: from ben_prtn_elig_prfl_f mas2
270: where mas1.prtn_elig_id = mas2.prtn_elig_id
271: AND c_effective_date
272: BETWEEN MAS2.EFFECTIVE_START_DATE AND MAS2.EFFECTIVE_END_DATE
273: )

Line 357: ben_prtn_elig_prfl_f tab2,

353: tab3.ELIG_COMPTNCY_FLAG,
354: tab3.ELIG_HLTH_CVG_FLAG,
355: tab3.ELIG_ANTHR_PL_FLAG
356: from ben_prtn_elig_f tab1,
357: ben_prtn_elig_prfl_f tab2,
358: ben_eligy_prfl_f tab3
359: where tab1.business_group_id = c_business_group_id
360: and tab1.prtn_elig_id = tab2.prtn_elig_id
361: and c_effective_date

Line 745: ben_prtn_elig_prfl_f tab2,

741: tab3.ELIG_COMPTNCY_FLAG,
742: tab3.ELIG_HLTH_CVG_FLAG,
743: tab3.ELIG_ANTHR_PL_FLAG
744: from ben_prtn_elig_f tab1,
745: ben_prtn_elig_prfl_f tab2,
746: ben_eligy_prfl_f tab3
747: where tab1.pgm_id = c_pgm_id
748: and tab1.prtn_elig_id = tab2.prtn_elig_id
749: and c_effective_date

Line 831: ben_prtn_elig_prfl_f tab2,

827: tab3.ELIG_COMPTNCY_FLAG,
828: tab3.ELIG_HLTH_CVG_FLAG,
829: tab3.ELIG_ANTHR_PL_FLAG
830: from ben_prtn_elig_f tab1,
831: ben_prtn_elig_prfl_f tab2,
832: ben_eligy_prfl_f tab3
833: where tab1.ptip_id = c_ptip_id
834: and tab1.prtn_elig_id = tab2.prtn_elig_id
835: and c_effective_date

Line 915: ben_prtn_elig_prfl_f tab2,

911: tab3.ELIG_COMPTNCY_FLAG,
912: tab3.ELIG_HLTH_CVG_FLAG,
913: tab3.ELIG_ANTHR_PL_FLAG
914: from ben_prtn_elig_f tab1,
915: ben_prtn_elig_prfl_f tab2,
916: ben_eligy_prfl_f tab3
917: where tab1.plip_id = c_plip_id
918: and tab1.prtn_elig_id = tab2.prtn_elig_id
919: and c_effective_date

Line 999: ben_prtn_elig_prfl_f tab2,

995: tab3.ELIG_COMPTNCY_FLAG,
996: tab3.ELIG_HLTH_CVG_FLAG,
997: tab3.ELIG_ANTHR_PL_FLAG
998: from ben_prtn_elig_f tab1,
999: ben_prtn_elig_prfl_f tab2,
1000: ben_eligy_prfl_f tab3
1001: where tab1.pl_id = c_pl_id
1002: and tab1.prtn_elig_id = tab2.prtn_elig_id
1003: and c_effective_date

Line 1083: ben_prtn_elig_prfl_f tab2,

1079: tab3.ELIG_COMPTNCY_FLAG,
1080: tab3.ELIG_HLTH_CVG_FLAG,
1081: tab3.ELIG_ANTHR_PL_FLAG
1082: from ben_prtn_elig_f tab1,
1083: ben_prtn_elig_prfl_f tab2,
1084: ben_eligy_prfl_f tab3
1085: where tab1.oipl_id = c_oipl_id
1086: and tab1.prtn_elig_id = tab2.prtn_elig_id
1087: and c_effective_date