DBA Data[Home] [Help]

APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PER_CM_PRVDD_F

Line 983: -- BEN_PER_CM_PRVDD_F

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

Line 1011: delete FROM ben_per_cm_prvdd_f

1007: LOOP
1008: FETCH c5 BULK COLLECT INTO l_data ;
1009: --
1010: FORALL i IN 1..l_data.COUNT
1011: delete FROM ben_per_cm_prvdd_f
1012: WHERE per_cm_id = l_data(i) ;
1013: --
1014: ben_batch_utils.write(p_text => 'BEN_PER_CM_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1015: --

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

1010: FORALL i IN 1..l_data.COUNT
1011: delete FROM ben_per_cm_prvdd_f
1012: WHERE per_cm_id = l_data(i) ;
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) ;