DBA Data[Home] [Help]

APPS.CN_NOTIFY_WRITEOFFS dependencies on CN_REPOSITORIES

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

24: x_end_date DATE;
25: x_rowid ROWID;
26: l_sys_batch_size NUMBER;
27:
28: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;
29:
30:
31: BEGIN
32: IF (debug_pipe IS NOT NULL) THEN

Line 81: cn_repositories cr

77: 'AR',
78: cn_global.wo_event_id,
79: x_org_id
80: FROM ar_adjustments aa,
81: cn_repositories cr
82: WHERE aa.type in ('LINE', 'INVOICE') --AE 02-22-96
83: AND aa.status = 'A' --AE 02-23-96
84: AND aa.line_adjusted is not NULL --AE 02-06-96
85: AND aa.gl_date BETWEEN x_start_date AND x_end_date