APPS.CN_UPG_PMT_REASONS_PKG dependencies on CN_PAYMENT_WORKSHEETS_ALL

Line 145: (select 1 from cn_payment_worksheets_all

141: fnd_file.put_line(FND_FILE.LOG, 'About to clean out dangling junk records');
142: delete /*+ ROWID(r) */ from cn_reasons_all r
143: where rowid between l_start_rowid and l_end_rowid
144: and (updated_table = 'CN_PAYMENT_WORKSHEETS' and not exists
145: (select 1 from cn_payment_worksheets_all
146: where payment_worksheet_id = upd_table_id)
147: or updated_table = 'CN_PAYRUNS' and not exists
148: (select 1 from cn_payruns_all
149: where payrun_id = upd_table_id));