APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_SVC_AREA_PRTE_F

Line 1416: cursor BEN_ELIG_SVC_AREA_PRTE_F is

1412: and a.effective_end_date = (select max(b.effective_end_date)
1413: from BEN_ELIG_SCHEDD_HRS_PRTE_F b
1414: where a.elig_schedd_hrs_prte_id = b.elig_schedd_hrs_prte_id);
1415:
1416: cursor BEN_ELIG_SVC_AREA_PRTE_F is
1417: select a.elig_svc_area_prte_id, a.object_version_number, a.effective_end_date eed
1418: from BEN_ELIG_SVC_AREA_PRTE_F a
1419: where a.eligy_prfl_id = p_eligy_prfl_id
1420: and a.effective_end_date = (select max(b.effective_end_date)

Line 1418: from BEN_ELIG_SVC_AREA_PRTE_F a

1414: where a.elig_schedd_hrs_prte_id = b.elig_schedd_hrs_prte_id);
1415:
1416: cursor BEN_ELIG_SVC_AREA_PRTE_F is
1417: select a.elig_svc_area_prte_id, a.object_version_number, a.effective_end_date eed
1418: from BEN_ELIG_SVC_AREA_PRTE_F a
1419: where a.eligy_prfl_id = p_eligy_prfl_id
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);

Line 1421: from BEN_ELIG_SVC_AREA_PRTE_F b

1417: select a.elig_svc_area_prte_id, a.object_version_number, a.effective_end_date eed
1418: from BEN_ELIG_SVC_AREA_PRTE_F a
1419: where a.eligy_prfl_id = p_eligy_prfl_id
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

Line 2282: for l_row in BEN_ELIG_SVC_AREA_PRTE_F loop

2278: ,p_effective_date => l_effective_date
2279: ,p_datetrack_mode => p_datetrack_mode);
2280: end if;
2281: end loop;
2282: for l_row in BEN_ELIG_SVC_AREA_PRTE_F loop
2283: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2284: or p_datetrack_mode <> hr_api.g_delete then
2285: if p_datetrack_mode = hr_api.g_zap then
2286: l_effective_date := l_row.eed;