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_ELIGY_PRFL_RL_F

Line 1088: cursor BEN_ELIGY_PRFL_RL_F is

1084: (p_eligy_prfl_id in number
1085: ,p_effective_date in date
1086: ,p_datetrack_mode in varchar2) is
1087:
1088: cursor BEN_ELIGY_PRFL_RL_F is
1089: select a.eligy_prfl_rl_id, a.object_version_number, a.effective_end_date eed
1090: from BEN_ELIGY_PRFL_RL_F a
1091: where a.eligy_prfl_id = p_eligy_prfl_id
1092: and a.effective_end_date = (select max(b.effective_end_date)

Line 1090: from BEN_ELIGY_PRFL_RL_F a

1086: ,p_datetrack_mode in varchar2) is
1087:
1088: cursor BEN_ELIGY_PRFL_RL_F is
1089: select a.eligy_prfl_rl_id, a.object_version_number, a.effective_end_date eed
1090: from BEN_ELIGY_PRFL_RL_F a
1091: where a.eligy_prfl_id = p_eligy_prfl_id
1092: and a.effective_end_date = (select max(b.effective_end_date)
1093: from BEN_ELIGY_PRFL_RL_F b
1094: where a.eligy_prfl_rl_id = b.eligy_prfl_rl_id);

Line 1093: from BEN_ELIGY_PRFL_RL_F b

1089: select a.eligy_prfl_rl_id, a.object_version_number, a.effective_end_date eed
1090: from BEN_ELIGY_PRFL_RL_F a
1091: where a.eligy_prfl_id = p_eligy_prfl_id
1092: and a.effective_end_date = (select max(b.effective_end_date)
1093: from BEN_ELIGY_PRFL_RL_F b
1094: where a.eligy_prfl_rl_id = b.eligy_prfl_rl_id);
1095:
1096: cursor BEN_ELIG_AGE_PRTE_F is
1097: select a.elig_age_prte_id, a.object_version_number, a.effective_end_date eed

Line 1571: l_row BEN_ELIGY_PRFL_RL_F%rowtype;

1567: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1568: --
1569: -- End Bug No 4411798
1570: --
1571: l_row BEN_ELIGY_PRFL_RL_F%rowtype;
1572: l_effective_start_date date;
1573: l_effective_end_date date;
1574: l_effective_date date;
1575:

Line 1585: for l_row in BEN_ELIGY_PRFL_RL_F loop

1581: -- BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
1582: -- BEN_ELIG_DSBLD_STAT_PRTE_F
1583: -- BEN_ELIG_MLTRY_STAT_PRTE_F
1584: -- BEN_ELIG_PRTT_ANTHR_PGM_F
1585: for l_row in BEN_ELIGY_PRFL_RL_F loop
1586: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1587: or p_datetrack_mode <> hr_api.g_delete then
1588: if p_datetrack_mode = hr_api.g_zap then
1589: l_effective_date := l_row.eed;