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_PER_IN_LER

Line 688: -- This is procedure to delete all orphan child records of BEN_PER_IN_LER

684: -- ----------------------------------------------------------------------------
685: -- |-------------------------< delete_per_in_ler >--------------------------|
686: -- ----------------------------------------------------------------------------
687: --
688: -- This is procedure to delete all orphan child records of BEN_PER_IN_LER
689: -- and then records of BEN_PER_IN_LER itself where deleted person_id is directly
690: -- referenced.
691: -- Hierarchy to use
692: --

Line 689: -- and then records of BEN_PER_IN_LER itself where deleted person_id is directly

685: -- |-------------------------< delete_per_in_ler >--------------------------|
686: -- ----------------------------------------------------------------------------
687: --
688: -- This is procedure to delete all orphan child records of BEN_PER_IN_LER
689: -- and then records of BEN_PER_IN_LER itself where deleted person_id is directly
690: -- referenced.
691: -- Hierarchy to use
692: --
693: -- BEN_PER_IN_LER

Line 693: -- BEN_PER_IN_LER

689: -- and then records of BEN_PER_IN_LER itself where deleted person_id is directly
690: -- referenced.
691: -- Hierarchy to use
692: --
693: -- BEN_PER_IN_LER
694: -- BEN_BNFT_PRVDD_LDGR_F
695: -- BEN_CBR_PER_IN_LER
696: -- BEN_ELIG_PER_OPT_F
697: -- BEN_ELIG_DPNT

Line 715: FROM ben_per_in_ler a

711: --
712: cursor c2 is
713: SELECT /*+ PARALLEL(A) */
714: DISTINCT per_in_ler_id
715: FROM ben_per_in_ler a
716: WHERE a.person_id IS NOT NULL
717: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
718: FROM per_all_people_f per);
719: --

Line 804: DELETE FROM BEN_PER_IN_LER

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) ;
806: --
807: ben_batch_utils.write(p_text => 'BEN_PER_IN_LER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
808: --

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

803: FORALL i IN 1..l_data.COUNT
804: DELETE FROM BEN_PER_IN_LER
805: WHERE PER_IN_LER_ID = l_data(i) ;
806: --
807: ben_batch_utils.write(p_text => 'BEN_PER_IN_LER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
808: --
809: EXIT WHEN c2%NOTFOUND;
810: --
811: end loop;