DBA Data[Home] [Help]

APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PER_CM_USG_F

Line 985: -- BEN_PER_CM_USG_F

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
989: --

Line 1023: delete FROM ben_per_cm_usg_f

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) ;
1025: --
1026: ben_batch_utils.write(p_text => 'BEN_PER_CM_USG_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1027: --

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

1022: FORALL i IN 1..l_data.COUNT
1023: delete FROM ben_per_cm_usg_f
1024: WHERE per_cm_id = l_data(i) ;
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) ;