DBA Data[Home] [Help]

APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_DSBLTY_CTG_PRTE_F

Line 1464: cursor BEN_ELIG_DSBLTY_CTG_PRTE_F is

1460: from BEN_ELIG_MRTL_STS_PRTE_F a
1461: where a.eligy_prfl_id = p_eligy_prfl_id
1462: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1463:
1464: cursor BEN_ELIG_DSBLTY_CTG_PRTE_F is
1465: select a.ELIG_DSBLTY_CTG_PRTE_ID , a.object_version_number, a.effective_end_date eed
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 ;

Line 1466: from BEN_ELIG_DSBLTY_CTG_PRTE_f a

1462: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1463:
1464: cursor BEN_ELIG_DSBLTY_CTG_PRTE_F is
1465: select a.ELIG_DSBLTY_CTG_PRTE_ID , a.object_version_number, a.effective_end_date eed
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

Line 2384: for l_row in BEN_ELIG_DSBLTY_CTG_PRTE_F loop

2380: ,p_effective_date => p_effective_date
2381: ,p_datetrack_mode => p_datetrack_mode);
2382: end loop;
2383:
2384: for l_row in BEN_ELIG_DSBLTY_CTG_PRTE_F loop
2385: BEN_ELIG_DSBLTY_CTG_PRTE_api.delete_ELIG_DSBLTY_CTG_PRTE
2386: (p_validate => false
2387: ,p_ELIG_DSBLTY_CTG_PRTE_ID => l_row.ELIG_DSBLTY_CTG_PRTE_ID
2388: ,p_effective_start_date => l_effective_start_date