eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 908: -- This is procedure to delete all orphan child records of BEN_ELIG_CVRD_DPNT_F

904: -- ----------------------------------------------------------------------------
905: -- |-------------------------< delete_elig_cvrd_dpnt_f >--------------------------|
906: -- ----------------------------------------------------------------------------
907: --
908: -- This is procedure to delete all orphan child records of BEN_ELIG_CVRD_DPNT_F
909: -- and then records of BEN_ELIG_CVRD_DPNT_F itself where deleted person_id is directly
910: -- referenced.
911: -- Hierarchy to use
912: --

Line 909: -- and then records of BEN_ELIG_CVRD_DPNT_F itself where deleted person_id is directly

905: -- |-------------------------< delete_elig_cvrd_dpnt_f >--------------------------|
906: -- ----------------------------------------------------------------------------
907: --
908: -- This is procedure to delete all orphan child records of BEN_ELIG_CVRD_DPNT_F
909: -- and then records of BEN_ELIG_CVRD_DPNT_F itself where deleted person_id is directly
910: -- referenced.
911: -- Hierarchy to use
912: --
913: -- BEN_ELIG_CVRD_DPNT_F

Line 913: -- BEN_ELIG_CVRD_DPNT_F

909: -- and then records of BEN_ELIG_CVRD_DPNT_F itself where deleted person_id is directly
910: -- referenced.
911: -- Hierarchy to use
912: --
913: -- BEN_ELIG_CVRD_DPNT_F
914: -- BEN_EXT_CRIT_VAL
915: -- BEN_CVRD_DPNT_CTFN_PRVDD_F
916: --
917: procedure delete_elig_cvrd_dpnt_f

Line 926: FROM ben_elig_cvrd_dpnt_f a

922: --
923: cursor c4 is
924: SELECT /*+ PARALLEL(A) */
925: DISTINCT elig_cvrd_dpnt_id
926: FROM ben_elig_cvrd_dpnt_f a
927: WHERE NOT EXISTS (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL(PER) */ 1
928: FROM per_all_people_f per
929: WHERE per.person_id = a.dpnt_person_id);
930: --

Line 958: DELETE FROM ben_elig_cvrd_dpnt_f

954: --
955: ben_batch_utils.write(p_text => 'BEN_EXT_CRIT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
956: --
957: FORALL i IN 1..l_data.COUNT
958: DELETE FROM ben_elig_cvrd_dpnt_f
959: WHERE elig_cvrd_dpnt_id = l_data (i);
960: --
961: ben_batch_utils.write(p_text => 'BEN_ELIG_CVRD_DPNT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
962: --

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

957: FORALL i IN 1..l_data.COUNT
958: DELETE FROM ben_elig_cvrd_dpnt_f
959: WHERE elig_cvrd_dpnt_id = l_data (i);
960: --
961: ben_batch_utils.write(p_text => 'BEN_ELIG_CVRD_DPNT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
962: --
963: EXIT WHEN c4%NOTFOUND;
964: --
965: end loop;