APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_ASNT_SET_PRTE_F

Line 1104: cursor BEN_ELIG_ASNT_SET_PRTE_F is

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
1106: from BEN_ELIG_ASNT_SET_PRTE_F a
1107: where a.eligy_prfl_id = p_eligy_prfl_id
1108: and a.effective_end_date = (select max(b.effective_end_date)

Line 1106: from BEN_ELIG_ASNT_SET_PRTE_F a

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
1106: from BEN_ELIG_ASNT_SET_PRTE_F a
1107: where a.eligy_prfl_id = p_eligy_prfl_id
1108: and a.effective_end_date = (select max(b.effective_end_date)
1109: from BEN_ELIG_ASNT_SET_PRTE_F b
1110: where a.elig_asnt_set_prte_id = b.elig_asnt_set_prte_id);

Line 1109: from BEN_ELIG_ASNT_SET_PRTE_F b

1105: select a.elig_asnt_set_prte_id, a.object_version_number, a.effective_end_date eed
1106: from BEN_ELIG_ASNT_SET_PRTE_F a
1107: where a.eligy_prfl_id = p_eligy_prfl_id
1108: and a.effective_end_date = (select max(b.effective_end_date)
1109: from BEN_ELIG_ASNT_SET_PRTE_F b
1110: where a.elig_asnt_set_prte_id = b.elig_asnt_set_prte_id);
1111:
1112: cursor BEN_ELIG_BENFTS_GRP_PRTE_F is
1113: select a.elig_benfts_grp_prte_id, a.object_version_number, a.effective_end_date eed

Line 1619: for l_row in BEN_ELIG_ASNT_SET_PRTE_F loop

1615: ,p_effective_date => l_effective_date
1616: ,p_datetrack_mode => p_datetrack_mode);
1617: end if;
1618: end loop;
1619: for l_row in BEN_ELIG_ASNT_SET_PRTE_F loop
1620: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1621: or p_datetrack_mode <> hr_api.g_delete then
1622: if p_datetrack_mode = hr_api.g_zap then
1623: l_effective_date := l_row.eed;