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_ELIGY_PROFILE_API dependencies on BEN_ELIG_MRTL_STS_PRTE_F

Line 1458: cursor BEN_ELIG_MRTL_STS_PRTE_F is

1454: where a.eligy_prfl_id = p_eligy_prfl_id
1455: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1456:
1457:
1458: cursor BEN_ELIG_MRTL_STS_PRTE_F is
1459: select a.ELIG_MRTL_STS_PRTE_ID , a.object_version_number, a.effective_end_date eed
1460: from BEN_ELIG_MRTL_STS_PRTE_F a
1461: where a.eligy_prfl_id = p_eligy_prfl_id
1462: and p_effective_date between a.effective_start_date and a.effective_end_date ;

Line 1460: from BEN_ELIG_MRTL_STS_PRTE_F a

1456:
1457:
1458: cursor BEN_ELIG_MRTL_STS_PRTE_F is
1459: select a.ELIG_MRTL_STS_PRTE_ID , a.object_version_number, a.effective_end_date eed
1460: from BEN_ELIG_MRTL_STS_PRTE_F a
1461: where a.eligy_prfl_id = p_eligy_prfl_id
1462: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1463:
1464: cursor BEN_ELIG_DSBLTY_CTG_PRTE_F is

Line 2373: for l_row in BEN_ELIG_MRTL_STS_PRTE_F loop

2369: end if;
2370: end loop;
2371:
2372:
2373: for l_row in BEN_ELIG_MRTL_STS_PRTE_F loop
2374: BEN_ELIG_MRTL_STS_PRTE_api.delete_ELIG_MRTL_STS_PRTE
2375: (p_validate => false
2376: ,p_ELIG_MRTL_STS_PRTE_ID => l_row.ELIG_MRTL_STS_PRTE_ID
2377: ,p_effective_start_date => l_effective_start_date