APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_PYRL_PRTE_F

Line 1392: cursor BEN_ELIG_PYRL_PRTE_F is

1388: and a.effective_end_date = (select max(b.effective_end_date)
1389: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F b
1390: where a.elig_pstl_cd_r_rng_prte_id = b.elig_pstl_cd_r_rng_prte_id);
1391:
1392: cursor BEN_ELIG_PYRL_PRTE_F is
1393: select a.elig_pyrl_prte_id, a.object_version_number, a.effective_end_date eed
1394: from BEN_ELIG_PYRL_PRTE_F a
1395: where a.eligy_prfl_id = p_eligy_prfl_id
1396: and a.effective_end_date = (select max(b.effective_end_date)

Line 1394: from BEN_ELIG_PYRL_PRTE_F a

1390: where a.elig_pstl_cd_r_rng_prte_id = b.elig_pstl_cd_r_rng_prte_id);
1391:
1392: cursor BEN_ELIG_PYRL_PRTE_F is
1393: select a.elig_pyrl_prte_id, a.object_version_number, a.effective_end_date eed
1394: from BEN_ELIG_PYRL_PRTE_F a
1395: where a.eligy_prfl_id = p_eligy_prfl_id
1396: and a.effective_end_date = (select max(b.effective_end_date)
1397: from BEN_ELIG_PYRL_PRTE_F b
1398: where a.elig_pyrl_prte_id = b.elig_pyrl_prte_id);

Line 1397: from BEN_ELIG_PYRL_PRTE_F b

1393: select a.elig_pyrl_prte_id, a.object_version_number, a.effective_end_date eed
1394: from BEN_ELIG_PYRL_PRTE_F a
1395: where a.eligy_prfl_id = p_eligy_prfl_id
1396: and a.effective_end_date = (select max(b.effective_end_date)
1397: from BEN_ELIG_PYRL_PRTE_F b
1398: where a.elig_pyrl_prte_id = b.elig_pyrl_prte_id);
1399:
1400: cursor BEN_ELIG_PY_BSS_PRTE_F is
1401: select a.elig_py_bss_prte_id, a.object_version_number, a.effective_end_date eed

Line 2231: for l_row in BEN_ELIG_PYRL_PRTE_F loop

2227: ,p_effective_date => l_effective_date
2228: ,p_datetrack_mode => p_datetrack_mode);
2229: end if;
2230: end loop;
2231: for l_row in BEN_ELIG_PYRL_PRTE_F loop
2232: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2233: or p_datetrack_mode <> hr_api.g_delete then
2234: if p_datetrack_mode = hr_api.g_zap then
2235: l_effective_date := l_row.eed;