APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PRTT_PREM_BY_MO_F

Line 6441: from ben_prtt_prem_by_mo_f prm

6437: select prm.prtt_prem_by_mo_id,
6438: prm.object_version_number,
6439: prm.effective_start_date,
6440: prm.effective_end_date
6441: from ben_prtt_prem_by_mo_f prm
6442: where prm.prtt_prem_id = l_prtt_prem_id;
6443: --
6444: l_prm c_prm%rowtype;
6445: --

Line 10283: ** the ben_prtt_prem_by_mo_f row. The ben_prtt_prem_by_mo_f rows have

10279: This whole section has been deleted
10280: ** BBurns 15aug2001
10281: ** A 'invalid primary key' error occurred when a date track delete
10282: ** was attempted with a p_effective_date prior to the start of
10283: ** the ben_prtt_prem_by_mo_f row. The ben_prtt_prem_by_mo_f rows have
10284: ** already been reported to the carrier and should not be modified
10285: ** by this procedure.
10286: ** A review of how prtt_prem_by_mo_f is defined and the functionality
10287: ** of this procedure is in order.

Line 10290: -- delete child ben_prtt_prem_by_mo_f records

10286: ** A review of how prtt_prem_by_mo_f is defined and the functionality
10287: ** of this procedure is in order.
10288: **
10289: --
10290: -- delete child ben_prtt_prem_by_mo_f records
10291: --
10292: for l_prm in c_prm loop
10293: --
10294: if (l_datetrack_mode = hr_api.g_delete and