DBA Data[Home] [Help]

APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 1360: cursor BEN_ELIG_PER_TYP_PRTE_F is

1356: and a.effective_end_date = (select max(b.effective_end_date)
1357: from BEN_ELIG_PCT_FL_TM_PRTE_F b
1358: where a.elig_pct_fl_tm_prte_id = b.elig_pct_fl_tm_prte_id);
1359:
1360: cursor BEN_ELIG_PER_TYP_PRTE_F is
1361: select a.elig_per_typ_prte_id, a.object_version_number, a.effective_end_date eed
1362: from BEN_ELIG_PER_TYP_PRTE_F a
1363: where a.eligy_prfl_id = p_eligy_prfl_id
1364: and a.effective_end_date = (select max(b.effective_end_date)

Line 1362: from BEN_ELIG_PER_TYP_PRTE_F a

1358: where a.elig_pct_fl_tm_prte_id = b.elig_pct_fl_tm_prte_id);
1359:
1360: cursor BEN_ELIG_PER_TYP_PRTE_F is
1361: select a.elig_per_typ_prte_id, a.object_version_number, a.effective_end_date eed
1362: from BEN_ELIG_PER_TYP_PRTE_F a
1363: where a.eligy_prfl_id = p_eligy_prfl_id
1364: and a.effective_end_date = (select max(b.effective_end_date)
1365: from BEN_ELIG_PER_TYP_PRTE_F b
1366: where a.elig_per_typ_prte_id = b.elig_per_typ_prte_id);

Line 1365: from BEN_ELIG_PER_TYP_PRTE_F b

1361: select a.elig_per_typ_prte_id, a.object_version_number, a.effective_end_date eed
1362: from BEN_ELIG_PER_TYP_PRTE_F a
1363: where a.eligy_prfl_id = p_eligy_prfl_id
1364: and a.effective_end_date = (select max(b.effective_end_date)
1365: from BEN_ELIG_PER_TYP_PRTE_F b
1366: where a.elig_per_typ_prte_id = b.elig_per_typ_prte_id);
1367:
1368: cursor BEN_ELIG_PPL_GRP_PRTE_F is
1369: select a.elig_ppl_grp_prte_id, a.object_version_number, a.effective_end_date eed

Line 2163: for l_row in BEN_ELIG_PER_TYP_PRTE_F loop

2159: ,p_effective_date => l_effective_date
2160: ,p_datetrack_mode => p_datetrack_mode);
2161: end if;
2162: end loop;
2163: for l_row in BEN_ELIG_PER_TYP_PRTE_F loop
2164: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2165: or p_datetrack_mode <> hr_api.g_delete then
2166: if p_datetrack_mode = hr_api.g_zap then
2167: l_effective_date := l_row.eed;