APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 823: -- This is procedure to delete all orphan child records of BEN_PRTT_ENRT_RSLT_F

819: -- ----------------------------------------------------------------------------
820: -- |-------------------------< delete_prtt_enrt_rslt_f >--------------------------|
821: -- ----------------------------------------------------------------------------
822: --
823: -- This is procedure to delete all orphan child records of BEN_PRTT_ENRT_RSLT_F
824: -- and then records of BEN_PRTT_ENRT_RSLT_F itself where deleted person_id is directly
825: -- referenced.
826: -- Hierarchy to use
827: --

Line 824: -- and then records of BEN_PRTT_ENRT_RSLT_F itself where deleted person_id is directly

820: -- |-------------------------< delete_prtt_enrt_rslt_f >--------------------------|
821: -- ----------------------------------------------------------------------------
822: --
823: -- This is procedure to delete all orphan child records of BEN_PRTT_ENRT_RSLT_F
824: -- and then records of BEN_PRTT_ENRT_RSLT_F itself where deleted person_id is directly
825: -- referenced.
826: -- Hierarchy to use
827: --
828: -- BEN_PRTT_ENRT_RSLT_F

Line 828: -- BEN_PRTT_ENRT_RSLT_F

824: -- and then records of BEN_PRTT_ENRT_RSLT_F itself where deleted person_id is directly
825: -- referenced.
826: -- Hierarchy to use
827: --
828: -- BEN_PRTT_ENRT_RSLT_F
829: -- BEN_PRMRY_CARE_PRVDR_F
830: -- BEN_PRTT_ENRT_ACTN_F
831: -- BEN_PRTT_ENRT_CTFN_PRVDD_F
832: -- BEN_PRTT_PREM_F

Line 844: FROM ben_prtt_enrt_rslt_f a

840: --
841: cursor c3 is
842: SELECT /*+ PARALLEL(A) */
843: DISTINCT prtt_enrt_rslt_id
844: FROM ben_prtt_enrt_rslt_f a
845: WHERE a.person_id IS NOT NULL
846: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
847: FROM per_all_people_f per);
848: --

Line 889: DELETE FROM BEN_PRTT_ENRT_RSLT_F

885: --
886: ben_batch_utils.write(p_text => 'BEN_PRTT_RT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
887: --
888: FORALL i IN 1..l_data.COUNT
889: DELETE FROM BEN_PRTT_ENRT_RSLT_F
890: WHERE prtt_enrt_rslt_id = l_data(i);
891: --
892: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_RSLT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
893: --

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

888: FORALL i IN 1..l_data.COUNT
889: DELETE FROM BEN_PRTT_ENRT_RSLT_F
890: WHERE prtt_enrt_rslt_id = l_data(i);
891: --
892: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_RSLT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
893: --
894: EXIT WHEN c3%NOTFOUND;
895: --
896: end loop;