DBA Data[Home] [Help]

APPS.CN_NOTIFY_PAYMENTS dependencies on CN_REPOSITORIES

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

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

Line 82: cn_repositories cr

78: 'AR',
79: cn_global.pmt_event_id,
80: x_org_id
81: FROM ar_receivable_applications ara,
82: cn_repositories cr
83: WHERE ara.application_type = 'CASH'
84: AND ara.status = 'APP'
85: AND ara.gl_date BETWEEN x_start_date AND x_end_date
86: AND ara.posting_control_id <> -3 --AE 02-22-96