APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_HRS_WKD_PRTE_F

Line 1256: cursor BEN_ELIG_HRS_WKD_PRTE_F is

1252: and a.effective_end_date = (select max(b.effective_end_date)
1253: from BEN_ELIG_HRLY_SLRD_PRTE_F b
1254: where a.elig_hrly_slrd_prte_id = b.elig_hrly_slrd_prte_id);
1255:
1256: cursor BEN_ELIG_HRS_WKD_PRTE_F is
1257: select a.elig_hrs_wkd_prte_id, a.object_version_number, a.effective_end_date eed
1258: from BEN_ELIG_HRS_WKD_PRTE_F a
1259: where a.eligy_prfl_id = p_eligy_prfl_id
1260: and a.effective_end_date = (select max(b.effective_end_date)

Line 1258: from BEN_ELIG_HRS_WKD_PRTE_F a

1254: where a.elig_hrly_slrd_prte_id = b.elig_hrly_slrd_prte_id);
1255:
1256: cursor BEN_ELIG_HRS_WKD_PRTE_F is
1257: select a.elig_hrs_wkd_prte_id, a.object_version_number, a.effective_end_date eed
1258: from BEN_ELIG_HRS_WKD_PRTE_F a
1259: where a.eligy_prfl_id = p_eligy_prfl_id
1260: and a.effective_end_date = (select max(b.effective_end_date)
1261: from BEN_ELIG_HRS_WKD_PRTE_F b
1262: where a.elig_hrs_wkd_prte_id = b.elig_hrs_wkd_prte_id);

Line 1261: from BEN_ELIG_HRS_WKD_PRTE_F b

1257: select a.elig_hrs_wkd_prte_id, a.object_version_number, a.effective_end_date eed
1258: from BEN_ELIG_HRS_WKD_PRTE_F a
1259: where a.eligy_prfl_id = p_eligy_prfl_id
1260: and a.effective_end_date = (select max(b.effective_end_date)
1261: from BEN_ELIG_HRS_WKD_PRTE_F b
1262: where a.elig_hrs_wkd_prte_id = b.elig_hrs_wkd_prte_id);
1263:
1264: cursor BEN_ELIG_JOB_PRTE_F is
1265: select a.elig_job_prte_id, a.object_version_number, a.effective_end_date eed

Line 1942: for l_row in BEN_ELIG_HRS_WKD_PRTE_F loop

1938: ,p_effective_date => l_effective_date
1939: ,p_datetrack_mode => p_datetrack_mode);
1940: end if;
1941: end loop;
1942: for l_row in BEN_ELIG_HRS_WKD_PRTE_F loop
1943: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1944: or p_datetrack_mode <> hr_api.g_delete then
1945: if p_datetrack_mode = hr_api.g_zap then
1946: l_effective_date := l_row.eed;