APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_PY_BSS_PRTE_F

Line 1400: cursor BEN_ELIG_PY_BSS_PRTE_F is

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
1402: from BEN_ELIG_PY_BSS_PRTE_F a
1403: where a.eligy_prfl_id = p_eligy_prfl_id
1404: and a.effective_end_date = (select max(b.effective_end_date)

Line 1402: from BEN_ELIG_PY_BSS_PRTE_F a

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
1402: from BEN_ELIG_PY_BSS_PRTE_F a
1403: where a.eligy_prfl_id = p_eligy_prfl_id
1404: and a.effective_end_date = (select max(b.effective_end_date)
1405: from BEN_ELIG_PY_BSS_PRTE_F b
1406: where a.elig_py_bss_prte_id = b.elig_py_bss_prte_id);

Line 1405: from BEN_ELIG_PY_BSS_PRTE_F b

1401: select a.elig_py_bss_prte_id, a.object_version_number, a.effective_end_date eed
1402: from BEN_ELIG_PY_BSS_PRTE_F a
1403: where a.eligy_prfl_id = p_eligy_prfl_id
1404: and a.effective_end_date = (select max(b.effective_end_date)
1405: from BEN_ELIG_PY_BSS_PRTE_F b
1406: where a.elig_py_bss_prte_id = b.elig_py_bss_prte_id);
1407:
1408: cursor BEN_ELIG_SCHEDD_HRS_PRTE_F is
1409: select a.elig_schedd_hrs_prte_id, a.object_version_number, a.effective_end_date eed

Line 2248: for l_row in BEN_ELIG_PY_BSS_PRTE_F loop

2244: ,p_effective_date => l_effective_date
2245: ,p_datetrack_mode => p_datetrack_mode);
2246: end if;
2247: end loop;
2248: for l_row in BEN_ELIG_PY_BSS_PRTE_F loop
2249: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2250: or p_datetrack_mode <> hr_api.g_delete then
2251: if p_datetrack_mode = hr_api.g_zap then
2252: l_effective_date := l_row.eed;