APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_WK_LOC_PRTE_F

Line 1424: cursor BEN_ELIG_WK_LOC_PRTE_F is

1420: and a.effective_end_date = (select max(b.effective_end_date)
1421: from BEN_ELIG_SVC_AREA_PRTE_F b
1422: where a.elig_svc_area_prte_id = b.elig_svc_area_prte_id);
1423:
1424: cursor BEN_ELIG_WK_LOC_PRTE_F is
1425: select a.elig_wk_loc_prte_id, a.object_version_number, a.effective_end_date eed
1426: from BEN_ELIG_WK_LOC_PRTE_F a
1427: where a.eligy_prfl_id = p_eligy_prfl_id
1428: and a.effective_end_date = (select max(b.effective_end_date)

Line 1426: from BEN_ELIG_WK_LOC_PRTE_F a

1422: where a.elig_svc_area_prte_id = b.elig_svc_area_prte_id);
1423:
1424: cursor BEN_ELIG_WK_LOC_PRTE_F is
1425: select a.elig_wk_loc_prte_id, a.object_version_number, a.effective_end_date eed
1426: from BEN_ELIG_WK_LOC_PRTE_F a
1427: where a.eligy_prfl_id = p_eligy_prfl_id
1428: and a.effective_end_date = (select max(b.effective_end_date)
1429: from BEN_ELIG_WK_LOC_PRTE_F b
1430: where a.elig_wk_loc_prte_id = b.elig_wk_loc_prte_id);

Line 1429: from BEN_ELIG_WK_LOC_PRTE_F b

1425: select a.elig_wk_loc_prte_id, a.object_version_number, a.effective_end_date eed
1426: from BEN_ELIG_WK_LOC_PRTE_F a
1427: where a.eligy_prfl_id = p_eligy_prfl_id
1428: and a.effective_end_date = (select max(b.effective_end_date)
1429: from BEN_ELIG_WK_LOC_PRTE_F b
1430: where a.elig_wk_loc_prte_id = b.elig_wk_loc_prte_id);
1431:
1432: cursor BEN_PRTN_ELIG_PRFL_F is
1433: select a.prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed

Line 2299: for l_row in BEN_ELIG_WK_LOC_PRTE_F loop

2295: ,p_effective_date => l_effective_date
2296: ,p_datetrack_mode => p_datetrack_mode);
2297: end if;
2298: end loop;
2299: for l_row in BEN_ELIG_WK_LOC_PRTE_F loop
2300: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2301: or p_datetrack_mode <> hr_api.g_delete then
2302: if p_datetrack_mode = hr_api.g_zap then
2303: l_effective_date := l_row.eed;