APPS.CN_NOTIFY_INVOICES 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:
33: BEGIN

Line 95: cn_repositories cr

91: x_org_id
92: FROM ra_customer_trx rct,
93: ra_cust_trx_types rctt,
94: ra_cust_trx_line_gl_dist rctlgd,
95: cn_repositories cr
96: WHERE rct.customer_trx_id = rctlgd.customer_trx_id
97: AND rct.cust_trx_type_id = rctt.cust_trx_type_id
98: AND rct.complete_flag = 'Y'
99: AND rctt.type in ('INV', 'CM','DM')

Line 146: cn_repositories cr

142: x_org_id
143: FROM ra_customer_trx rct,
144: ra_cust_trx_types rctt,
145: ra_cust_trx_line_gl_dist rctlgd,
146: cn_repositories cr
147: WHERE rct.customer_trx_id = rctlgd.customer_trx_id
148: AND rct.cust_trx_type_id = rctt.cust_trx_type_id
149: AND rct.complete_flag = 'Y'
150: --AE AND rctt.type in ('INV', 'CM','DM')