APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PRTT_PREM_BY_MO_F

Line 6152: from ben_prtt_prem_by_mo_f prm

6148: select prm.prtt_prem_by_mo_id,
6149: prm.object_version_number,
6150: prm.effective_start_date,
6151: prm.effective_end_date
6152: from ben_prtt_prem_by_mo_f prm
6153: where prm.prtt_prem_id = l_prtt_prem_id;
6154: --
6155: l_prm c_prm%rowtype;
6156: --

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

8787: This whole section has been deleted
8788: ** BBurns 15aug2001
8789: ** A 'invalid primary key' error occurred when a date track delete
8790: ** was attempted with a p_effective_date prior to the start of
8791: ** the ben_prtt_prem_by_mo_f row. The ben_prtt_prem_by_mo_f rows have
8792: ** already been reported to the carrier and should not be modified
8793: ** by this procedure.
8794: ** A review of how prtt_prem_by_mo_f is defined and the functionality
8795: ** of this procedure is in order.

Line 8798: -- delete child ben_prtt_prem_by_mo_f records

8794: ** A review of how prtt_prem_by_mo_f is defined and the functionality
8795: ** of this procedure is in order.
8796: **
8797: --
8798: -- delete child ben_prtt_prem_by_mo_f records
8799: --
8800: for l_prm in c_prm loop
8801: --
8802: if (l_datetrack_mode = hr_api.g_delete and