APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 704: -- BEN_ELIG_PER_ELCTBL_CHC

700: -- BEN_PRTT_PREM_F
701: -- BEN_ENRT_PREM
702: -- BEN_ENRT_BNFT
703: -- BEN_ENRT_RT
704: -- BEN_ELIG_PER_ELCTBL_CHC
705: --
706: procedure delete_per_in_ler
707: is
708: --

Line 762: from BEN_ELIG_PER_ELCTBL_CHC a

758: --
759: FORALL i IN 1..l_data.COUNT
760: delete from BEN_ENRT_RT
761: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
762: from BEN_ELIG_PER_ELCTBL_CHC a
763: where a.PER_IN_LER_ID = l_data(i) );
764: --
765: ben_batch_utils.write(p_text => 'BEN_ENRT_RT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
766: --

Line 784: from BEN_ELIG_PER_ELCTBL_CHC a

780: --
781: FORALL i IN 1..l_data.COUNT
782: delete from BEN_ENRT_PREM
783: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
784: from BEN_ELIG_PER_ELCTBL_CHC a
785: where a.PER_IN_LER_ID = l_data(i) );
786: --
787: ben_batch_utils.write(p_text => 'BEN_ENRT_PREM : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
788: --

Line 792: from BEN_ELIG_PER_ELCTBL_CHC a

788: --
789: FORALL i IN 1..l_data.COUNT
790: delete from BEN_ENRT_BNFT
791: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
792: from BEN_ELIG_PER_ELCTBL_CHC a
793: where a.PER_IN_LER_ID = l_data(i) );
794: --
795: ben_batch_utils.write(p_text => 'BEN_ENRT_BNFT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
796: --

Line 798: delete from BEN_ELIG_PER_ELCTBL_CHC a

794: --
795: ben_batch_utils.write(p_text => 'BEN_ENRT_BNFT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
796: --
797: FORALL i IN 1..l_data.COUNT
798: delete from BEN_ELIG_PER_ELCTBL_CHC a
799: where PER_IN_LER_ID = l_data(i) ;
800: --
801: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_ELCTBL_CHC : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
802: --

Line 801: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_ELCTBL_CHC : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

797: FORALL i IN 1..l_data.COUNT
798: delete from BEN_ELIG_PER_ELCTBL_CHC a
799: where PER_IN_LER_ID = l_data(i) ;
800: --
801: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_ELCTBL_CHC : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
802: --
803: FORALL i IN 1..l_data.COUNT
804: DELETE FROM BEN_PER_IN_LER
805: WHERE PER_IN_LER_ID = l_data(i) ;