APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_CNTNG_PRTN_ELIG_PRFL_F

Line 1441: cursor BEN_CNTNG_PRTN_ELIG_PRFL_F is

1437: from BEN_PRTN_ELIG_PRFL_F b
1438: where a.prtn_elig_prfl_id = b.prtn_elig_prfl_id);
1439:
1440:
1441: cursor BEN_CNTNG_PRTN_ELIG_PRFL_F is
1442: select a.cntng_prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
1443: from BEN_CNTNG_PRTN_ELIG_PRFL_F a
1444: where a.eligy_prfl_id = p_eligy_prfl_id
1445: and a.effective_end_date = (select max(b.effective_end_date)

Line 1443: from BEN_CNTNG_PRTN_ELIG_PRFL_F a

1439:
1440:
1441: cursor BEN_CNTNG_PRTN_ELIG_PRFL_F is
1442: select a.cntng_prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
1443: from BEN_CNTNG_PRTN_ELIG_PRFL_F a
1444: where a.eligy_prfl_id = p_eligy_prfl_id
1445: and a.effective_end_date = (select max(b.effective_end_date)
1446: from BEN_CNTNG_PRTN_ELIG_PRFL_F b
1447: where a.cntng_prtn_elig_prfl_id = b.cntng_prtn_elig_prfl_id);

Line 1446: from BEN_CNTNG_PRTN_ELIG_PRFL_F b

1442: select a.cntng_prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
1443: from BEN_CNTNG_PRTN_ELIG_PRFL_F a
1444: where a.eligy_prfl_id = p_eligy_prfl_id
1445: and a.effective_end_date = (select max(b.effective_end_date)
1446: from BEN_CNTNG_PRTN_ELIG_PRFL_F b
1447: where a.cntng_prtn_elig_prfl_id = b.cntng_prtn_elig_prfl_id);
1448:
1449:
1450:

Line 2334: for l_row in BEN_CNTNG_PRTN_ELIG_PRFL_F loop

2330: ,p_datetrack_mode => p_datetrack_mode);
2331: end if;
2332: end loop;
2333:
2334: for l_row in BEN_CNTNG_PRTN_ELIG_PRFL_F loop
2335: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2336: or p_datetrack_mode <> hr_api.g_delete then
2337: if p_datetrack_mode = hr_api.g_zap then
2338: l_effective_date := l_row.eed;