DBA Data[Home] [Help]

APPS.CN_CALC_CLASSIFY_PVT dependencies on CN_NOTIFY_LOG_ALL

Line 168: FROM cn_notify_log_all notify

164: WHERE pb.physical_batch_id = p_physical_batch_id)
165: AND ch.processed_date BETWEEN l_ruleset.start_date AND l_ruleset.end_date
166: AND ch.org_id = g_org_id
167: AND exists (SELECT 1
168: FROM cn_notify_log_all notify
169: WHERE notify.period_id = ch.processed_period_id
170: AND notify.status = 'INCOMPLETE'
171: AND revert_state = 'COL'
172: AND org_id = g_org_id

Line 191: FROM cn_notify_log_all notify

187: WHERE pb.physical_batch_id = p_physical_batch_id)
188: AND ch.processed_date BETWEEN l_ruleset.start_date AND l_ruleset.end_date
189: AND ch.org_id = g_org_id
190: AND exists (SELECT 1
191: FROM cn_notify_log_all notify
192: WHERE notify.period_id = ch.processed_period_id
193: AND notify.status = 'INCOMPLETE'
194: AND revert_state = 'COL'
195: AND org_id = g_org_id