DBA Data[Home] [Help]

APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PER_CM_TRGR_F

Line 984: -- BEN_PER_CM_TRGR_F

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: --
987: procedure delete_per_cm_f
988: is

Line 1017: delete FROM ben_per_cm_trgr_f

1013: --
1014: ben_batch_utils.write(p_text => 'BEN_PER_CM_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1015: --
1016: FORALL i IN 1..l_data.COUNT
1017: delete FROM ben_per_cm_trgr_f
1018: WHERE per_cm_id = l_data(i) ;
1019: --
1020: ben_batch_utils.write(p_text => 'BEN_PER_CM_TRGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1021: --

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

1016: FORALL i IN 1..l_data.COUNT
1017: delete FROM ben_per_cm_trgr_f
1018: WHERE per_cm_id = l_data(i) ;
1019: --
1020: ben_batch_utils.write(p_text => 'BEN_PER_CM_TRGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1021: --
1022: FORALL i IN 1..l_data.COUNT
1023: delete FROM ben_per_cm_usg_f
1024: WHERE per_cm_id = l_data(i) ;