APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_DSBLTY_DGR_PRTE_F

Line 1476: cursor BEN_ELIG_DSBLTY_DGR_PRTE_F is

1472: from BEN_ELIG_DSBLTY_RSN_PRTE_F a
1473: where a.eligy_prfl_id = p_eligy_prfl_id
1474: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1475:
1476: cursor BEN_ELIG_DSBLTY_DGR_PRTE_F is
1477: select a.ELIG_DSBLTY_DGR_PRTE_ID , a.object_version_number, a.effective_end_date eed
1478: from BEN_ELIG_DSBLTY_DGR_PRTE_F a
1479: where a.eligy_prfl_id = p_eligy_prfl_id
1480: and p_effective_date between a.effective_start_date and a.effective_end_date ;

Line 1478: from BEN_ELIG_DSBLTY_DGR_PRTE_F a

1474: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1475:
1476: cursor BEN_ELIG_DSBLTY_DGR_PRTE_F is
1477: select a.ELIG_DSBLTY_DGR_PRTE_ID , a.object_version_number, a.effective_end_date eed
1478: from BEN_ELIG_DSBLTY_DGR_PRTE_F a
1479: where a.eligy_prfl_id = p_eligy_prfl_id
1480: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1481:
1482: cursor BEN_ELIG_Suppl_role_prte_f is

Line 2407: for l_row in BEN_ELIG_DSBLTY_DGR_PRTE_F loop

2403: ,p_effective_date => p_effective_date
2404: ,p_datetrack_mode => p_datetrack_mode);
2405: end loop;
2406:
2407: for l_row in BEN_ELIG_DSBLTY_DGR_PRTE_F loop
2408: BEN_ELIG_DSBLTY_DGR_PRTE_api.delete_ELIG_DSBLTY_DGR_PRTE
2409: (p_validate => false
2410: ,p_ELIG_DSBLTY_DGR_PRTE_ID => l_row.ELIG_DSBLTY_DGR_PRTE_ID
2411: ,p_effective_start_date => l_effective_start_date

Line 2419: for l_row in BEN_ELIG_DSBLTY_DGR_PRTE_F loop

2415: ,p_datetrack_mode => p_datetrack_mode);
2416: end loop;
2417:
2418:
2419: for l_row in BEN_ELIG_DSBLTY_DGR_PRTE_F loop
2420: BEN_ELIG_DSBLTY_DGR_PRTE_api.delete_ELIG_DSBLTY_DGR_PRTE
2421: (p_validate => false
2422: ,p_ELIG_DSBLTY_DGR_PRTE_ID => l_row.ELIG_DSBLTY_DGR_PRTE_ID
2423: ,p_effective_start_date => l_effective_start_date