APPS.CN_NOTIFY_CLAWBACKS dependencies on CN_REPOSITORIES

Line 31: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;

27: x_end_due_date DATE;
28: x_rowid ROWID;
29: l_sys_batch_size NUMBER;
30:
31: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;
32:
33: BEGIN
34: IF (debug_pipe IS NOT NULL) THEN
35: cn_debug.init_pipe(debug_pipe, debug_level);

Line 57: ,cn_repositories r

53: --bug 513940 -J.C
54: SELECT r.clawback_grace_days
55: INTO x_clb_grace_period
56: FROM cn_periods p
57: ,cn_repositories r
58: ,gl_sets_of_books s
59: WHERE r.current_period_id = p.period_id(+)
60: AND r.application_id = 283
61: AND r.set_of_books_id = s.set_of_books_id

Line 115: cn_repositories cr

111: FROM ar_payment_schedules aps,
112: ra_customer_trx rct,
113: ra_cust_trx_types rctt,
114: ra_cust_trx_line_gl_dist rctlgd,
115: cn_repositories cr
116: WHERE aps.due_date BETWEEN x_start_due_date AND x_end_due_date
117: AND aps.amount_line_items_remaining > 0
118: --AE AND aps.class in ('INV', 'CM') --AE 02-06-96
119: AND aps.customer_trx_id = rct.customer_trx_id --AE 02-07-96