DBA Data[Home] [Help]

APPS.CN_NOTIFY_PAYMENTS dependencies on CN_GLOBAL

Line 79: cn_global.pmt_event_id,

75: 'N',
76: ara.rowid,
77: ara.receivable_application_id,
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'

Line 95: AND event_id= cn_global.pmt_event_id

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