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_CM_F

Line 977: -- This is procedure to delete all orphan child records of BEN_PER_CM_F

973: -- ----------------------------------------------------------------------------
974: -- |-------------------------< delete_per_cm_f >--------------------------|
975: -- ----------------------------------------------------------------------------
976: --
977: -- This is procedure to delete all orphan child records of BEN_PER_CM_F
978: -- and then records of BEN_PER_CM_F itself where deleted person_id is directly
979: -- referenced.
980: -- Hierarchy to use
981: --

Line 978: -- and then records of BEN_PER_CM_F itself where deleted person_id is directly

974: -- |-------------------------< delete_per_cm_f >--------------------------|
975: -- ----------------------------------------------------------------------------
976: --
977: -- This is procedure to delete all orphan child records of BEN_PER_CM_F
978: -- and then records of BEN_PER_CM_F itself where deleted person_id is directly
979: -- referenced.
980: -- Hierarchy to use
981: --
982: -- BEN_PER_CM_F

Line 982: -- BEN_PER_CM_F

978: -- and then records of BEN_PER_CM_F itself where deleted person_id is directly
979: -- referenced.
980: -- Hierarchy to use
981: --
982: -- BEN_PER_CM_F
983: -- BEN_PER_CM_PRVDD_F
984: -- BEN_PER_CM_TRGR_F
985: -- BEN_PER_CM_USG_F
986: --

Line 996: FROM ben_per_cm_f a

992: --
993: cursor c5 is
994: SELECT /*+ PARALLEL(A) */
995: DISTINCT per_cm_id
996: FROM ben_per_cm_f a
997: WHERE NOT EXISTS (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL(PER) */ 1
998: FROM per_all_people_f per
999: WHERE per.person_id = a.person_id);
1000: --

Line 1029: delete FROM ben_per_cm_f

1025: --
1026: ben_batch_utils.write(p_text => 'BEN_PER_CM_USG_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1027: --
1028: FORALL i IN 1..l_data.COUNT
1029: delete FROM ben_per_cm_f
1030: WHERE per_cm_id = l_data(i) ;
1031: --
1032: ben_batch_utils.write(p_text => 'BEN_PER_CM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1033: --

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

1028: FORALL i IN 1..l_data.COUNT
1029: delete FROM ben_per_cm_f
1030: WHERE per_cm_id = l_data(i) ;
1031: --
1032: ben_batch_utils.write(p_text => 'BEN_PER_CM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1033: --
1034: EXIT WHEN c5%NOTFOUND;
1035: --
1036: end loop;