APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_CBR_QUALD_BNF_F

Line 1128: cursor BEN_ELIG_CBR_QUALD_BNF_F is

1124: and a.effective_end_date = (select max(b.effective_end_date)
1125: from BEN_ELIG_BRGNG_UNIT_PRTE_F b
1126: where a.elig_brgng_unit_prte_id = b.elig_brgng_unit_prte_id);
1127:
1128: cursor BEN_ELIG_CBR_QUALD_BNF_F is
1129: select a.elig_cbr_quald_bnf_id, a.object_version_number, a.effective_end_date eed
1130: from BEN_ELIG_CBR_QUALD_BNF_F a
1131: where a.eligy_prfl_id = p_eligy_prfl_id
1132: and a.effective_end_date = (select max(b.effective_end_date)

Line 1130: from BEN_ELIG_CBR_QUALD_BNF_F a

1126: where a.elig_brgng_unit_prte_id = b.elig_brgng_unit_prte_id);
1127:
1128: cursor BEN_ELIG_CBR_QUALD_BNF_F is
1129: select a.elig_cbr_quald_bnf_id, a.object_version_number, a.effective_end_date eed
1130: from BEN_ELIG_CBR_QUALD_BNF_F a
1131: where a.eligy_prfl_id = p_eligy_prfl_id
1132: and a.effective_end_date = (select max(b.effective_end_date)
1133: from BEN_ELIG_CBR_QUALD_BNF_F b
1134: where a.elig_cbr_quald_bnf_id = b.elig_cbr_quald_bnf_id);

Line 1133: from BEN_ELIG_CBR_QUALD_BNF_F b

1129: select a.elig_cbr_quald_bnf_id, a.object_version_number, a.effective_end_date eed
1130: from BEN_ELIG_CBR_QUALD_BNF_F a
1131: where a.eligy_prfl_id = p_eligy_prfl_id
1132: and a.effective_end_date = (select max(b.effective_end_date)
1133: from BEN_ELIG_CBR_QUALD_BNF_F b
1134: where a.elig_cbr_quald_bnf_id = b.elig_cbr_quald_bnf_id);
1135:
1136: cursor BEN_ELIG_CMBN_AGE_LOS_PRTE_F is
1137: select a.elig_cmbn_age_los_prte_id, a.object_version_number, a.effective_end_date eed

Line 1670: for l_row in BEN_ELIG_CBR_QUALD_BNF_F loop

1666: ,p_effective_date => l_effective_date
1667: ,p_datetrack_mode => p_datetrack_mode);
1668: end if;
1669: end loop;
1670: for l_row in BEN_ELIG_CBR_QUALD_BNF_F loop
1671: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1672: or p_datetrack_mode <> hr_api.g_delete then
1673: if p_datetrack_mode = hr_api.g_zap then
1674: l_effective_date := l_row.eed;