APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_CBR_QUALD_BNF

Line 104: -- This is procedure to delete orphan records from BEN_CBR_QUALD_BNF

100: -- ----------------------------------------------------------------------------
101: -- |-------------------------< delete_cbr_quald_bnf >--------------------------|
102: -- ----------------------------------------------------------------------------
103: --
104: -- This is procedure to delete orphan records from BEN_CBR_QUALD_BNF
105: -- where deleted person_id is directly referenced.
106: --
107: procedure delete_cbr_quald_bnf
108: is

Line 118: DELETE FROM ben_cbr_quald_bnf a

114: --
115: hr_utility.set_location ('Entering ' || l_proc, 5);
116: --
117: --
118: DELETE FROM ben_cbr_quald_bnf a
119: WHERE NOT EXISTS (SELECT 1
120: FROM per_all_people_f per
121: WHERE per.person_id = a.cvrd_emp_person_id);
122: --

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

120: FROM per_all_people_f per
121: WHERE per.person_id = a.cvrd_emp_person_id);
122: --
123: --
124: ben_batch_utils.write(p_text => 'BEN_CBR_QUALD_BNF : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
125:
126: hr_utility.set_location ('Leaving ' || l_proc, 10);
127: --
128: end delete_cbr_quald_bnf;