DBA Data[Home] [Help]

APPS.CN_NOTIFY_WRITEOFFS dependencies on CN_GLOBAL

Line 78: cn_global.wo_event_id,

74: 'N',
75: aa.rowid,
76: aa.adjustment_id,
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

Line 95: AND event_id= cn_global.wo_event_id

91: AND NOT EXISTS (
92: SELECT 1
93: FROM cn_not_trx
94: WHERE source_trx_id = aa.adjustment_id
95: AND event_id= cn_global.wo_event_id
96: AND org_id = x_org_id) ;
97:
98:
99: x_trx_count := SQL%ROWCOUNT;