APPS.CN_CALC_ROLLUP_PVT dependencies on CN_NOTIFY_LOG_ALL

Line 659: FROM cn_notify_log_all

655: AND commission_header_id = p_commission_header_id;
656:
657: CURSOR ex_ancestors IS
658: SELECT salesrep_id, comp_group_id GROUP_ID, MIN( start_date ) start_date, MAX( end_date ) end_date
659: FROM cn_notify_log_all
660: WHERE action_link_id = p_action_link_id AND org_id = g_org_id AND notify_log_id > p_action_link_id
661: GROUP BY salesrep_id, comp_group_id;
662:
663: CURSOR path_check( p_rollup_date DATE, p_parent_salesrep_id NUMBER, p_child_salesrep_id NUMBER ) IS

Line 1367: FROM cn_notify_log_all event

1363: CURSOR l_notify_cr IS
1364: SELECT *
1365: FROM ( SELECT event.salesrep_id, event.comp_group_id, event.start_date
1366: , NVL( event.end_date, g_end_of_time ) end_date, event.action, event.notify_log_id
1367: FROM cn_notify_log_all event
1368: WHERE event.physical_batch_id = p_physical_batch_id
1369: AND event.action IN( 'SOURCE_CLS', 'XROLL', 'ROLL_PULL', 'DELETE_ROLL_PULL' )
1370: AND event.status = 'INCOMPLETE'
1371: UNION

Line 1374: FROM cn_notify_log_all event, cn_process_batches_all batch

1370: AND event.status = 'INCOMPLETE'
1371: UNION
1372: SELECT event.salesrep_id, event.comp_group_id, event.start_date
1373: , NVL( event.end_date, g_end_of_time ) end_date, event.action, event.notify_log_id
1374: FROM cn_notify_log_all event, cn_process_batches_all batch
1375: WHERE batch.physical_batch_id = p_physical_batch_id
1376: AND batch.salesrep_id = event.salesrep_id
1377: AND event.org_id = g_org_id
1378: AND event.period_id BETWEEN batch.period_id AND batch.end_period_id