APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_JOB_PRTE_F

Line 1264: cursor BEN_ELIG_JOB_PRTE_F is

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
1266: from BEN_ELIG_JOB_PRTE_F a
1267: where a.eligy_prfl_id = p_eligy_prfl_id
1268: and a.effective_end_date = (select max(b.effective_end_date)

Line 1266: from BEN_ELIG_JOB_PRTE_F a

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
1266: from BEN_ELIG_JOB_PRTE_F a
1267: where a.eligy_prfl_id = p_eligy_prfl_id
1268: and a.effective_end_date = (select max(b.effective_end_date)
1269: from BEN_ELIG_JOB_PRTE_F b
1270: where a.elig_job_prte_id = b.elig_job_prte_id);

Line 1269: from BEN_ELIG_JOB_PRTE_F b

1265: select a.elig_job_prte_id, a.object_version_number, a.effective_end_date eed
1266: from BEN_ELIG_JOB_PRTE_F a
1267: where a.eligy_prfl_id = p_eligy_prfl_id
1268: and a.effective_end_date = (select max(b.effective_end_date)
1269: from BEN_ELIG_JOB_PRTE_F b
1270: where a.elig_job_prte_id = b.elig_job_prte_id);
1271:
1272: cursor BEN_ELIG_LBR_MMBR_PRTE_F is
1273: select a.elig_lbr_mmbr_prte_id, a.object_version_number, a.effective_end_date eed

Line 1959: for l_row in BEN_ELIG_JOB_PRTE_F loop

1955: ,p_effective_date => l_effective_date
1956: ,p_datetrack_mode => p_datetrack_mode);
1957: end if;
1958: end loop;
1959: for l_row in BEN_ELIG_JOB_PRTE_F loop
1960: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1961: or p_datetrack_mode <> hr_api.g_delete then
1962: if p_datetrack_mode = hr_api.g_zap then
1963: l_effective_date := l_row.eed;