DBA Data[Home] [Help]

APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_DSBLTY_RSN_PRTE_F

Line 1470: cursor BEN_ELIG_DSBLTY_RSN_PRTE_F is

1466: from BEN_ELIG_DSBLTY_CTG_PRTE_f a
1467: where a.eligy_prfl_id = p_eligy_prfl_id
1468: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1469:
1470: cursor BEN_ELIG_DSBLTY_RSN_PRTE_F is
1471: select a.ELIG_DSBLTY_RSN_PRTE_ID , a.object_version_number, a.effective_end_date eed
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 ;

Line 1472: from BEN_ELIG_DSBLTY_RSN_PRTE_F a

1468: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1469:
1470: cursor BEN_ELIG_DSBLTY_RSN_PRTE_F is
1471: select a.ELIG_DSBLTY_RSN_PRTE_ID , a.object_version_number, a.effective_end_date eed
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

Line 2396: for l_row in BEN_ELIG_DSBLTY_RSN_PRTE_F loop

2392: ,p_datetrack_mode => p_datetrack_mode);
2393: end loop;
2394:
2395:
2396: for l_row in BEN_ELIG_DSBLTY_RSN_PRTE_F loop
2397: BEN_ELIG_DSBLTY_RSN_PRTE_api.delete_ELIG_DSBLTY_RSN_PRTE
2398: (p_validate => false
2399: ,p_ELIG_DSBLTY_RSN_PRTE_ID => l_row.ELIG_DSBLTY_RSN_PRTE_ID
2400: ,p_effective_start_date => l_effective_start_date