APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_AGE_PRTE_F

Line 1096: cursor BEN_ELIG_AGE_PRTE_F is

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
1098: from BEN_ELIG_AGE_PRTE_F a
1099: where a.eligy_prfl_id = p_eligy_prfl_id
1100: and a.effective_end_date = (select max(b.effective_end_date)

Line 1098: from BEN_ELIG_AGE_PRTE_F a

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
1098: from BEN_ELIG_AGE_PRTE_F a
1099: where a.eligy_prfl_id = p_eligy_prfl_id
1100: and a.effective_end_date = (select max(b.effective_end_date)
1101: from BEN_ELIG_AGE_PRTE_F b
1102: where a.elig_age_prte_id = b.elig_age_prte_id);

Line 1101: from BEN_ELIG_AGE_PRTE_F b

1097: select a.elig_age_prte_id, a.object_version_number, a.effective_end_date eed
1098: from BEN_ELIG_AGE_PRTE_F a
1099: where a.eligy_prfl_id = p_eligy_prfl_id
1100: and a.effective_end_date = (select max(b.effective_end_date)
1101: from BEN_ELIG_AGE_PRTE_F b
1102: where a.elig_age_prte_id = b.elig_age_prte_id);
1103:
1104: cursor BEN_ELIG_ASNT_SET_PRTE_F is
1105: select a.elig_asnt_set_prte_id, a.object_version_number, a.effective_end_date eed

Line 1602: for l_row in BEN_ELIG_AGE_PRTE_F loop

1598: ,p_effective_date => l_effective_date
1599: ,p_datetrack_mode => p_datetrack_mode);
1600: end if;
1601: end loop;
1602: for l_row in BEN_ELIG_AGE_PRTE_F loop
1603: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1604: or p_datetrack_mode <> hr_api.g_delete then
1605: if p_datetrack_mode = hr_api.g_zap then
1606: l_effective_date := l_row.eed;