APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 1328: cursor BEN_ELIG_ORG_UNIT_PRTE_F is

1324: and a.effective_end_date = (select max(b.effective_end_date)
1325: from BEN_ELIG_OPTD_MDCR_PRTE_F b
1326: where a.elig_optd_mdcr_prte_id = b.elig_optd_mdcr_prte_id);
1327:
1328: cursor BEN_ELIG_ORG_UNIT_PRTE_F is
1329: select a.elig_org_unit_prte_id, a.object_version_number, a.effective_end_date eed
1330: from BEN_ELIG_ORG_UNIT_PRTE_F a
1331: where a.eligy_prfl_id = p_eligy_prfl_id
1332: and a.effective_end_date = (select max(b.effective_end_date)

Line 1330: from BEN_ELIG_ORG_UNIT_PRTE_F a

1326: where a.elig_optd_mdcr_prte_id = b.elig_optd_mdcr_prte_id);
1327:
1328: cursor BEN_ELIG_ORG_UNIT_PRTE_F is
1329: select a.elig_org_unit_prte_id, a.object_version_number, a.effective_end_date eed
1330: from BEN_ELIG_ORG_UNIT_PRTE_F a
1331: where a.eligy_prfl_id = p_eligy_prfl_id
1332: and a.effective_end_date = (select max(b.effective_end_date)
1333: from BEN_ELIG_ORG_UNIT_PRTE_F b
1334: where a.elig_org_unit_prte_id = b.elig_org_unit_prte_id);

Line 1333: from BEN_ELIG_ORG_UNIT_PRTE_F b

1329: select a.elig_org_unit_prte_id, a.object_version_number, a.effective_end_date eed
1330: from BEN_ELIG_ORG_UNIT_PRTE_F a
1331: where a.eligy_prfl_id = p_eligy_prfl_id
1332: and a.effective_end_date = (select max(b.effective_end_date)
1333: from BEN_ELIG_ORG_UNIT_PRTE_F b
1334: where a.elig_org_unit_prte_id = b.elig_org_unit_prte_id);
1335:
1336: cursor BEN_ELIG_OTHR_PTIP_PRTE_F is
1337: select a.elig_othr_ptip_prte_id, a.object_version_number, a.effective_end_date eed

Line 2095: for l_row in BEN_ELIG_ORG_UNIT_PRTE_F loop

2091: ,p_effective_date => l_effective_date
2092: ,p_datetrack_mode => p_datetrack_mode);
2093: end if;
2094: end loop;
2095: for l_row in BEN_ELIG_ORG_UNIT_PRTE_F loop
2096: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2097: or p_datetrack_mode <> hr_api.g_delete then
2098: if p_datetrack_mode = hr_api.g_zap then
2099: l_effective_date := l_row.eed;