APPS.CN_NOTIFY_CLAWBACKS dependencies on CN_GLOBAL

Line 65: x_start_due_date := x_start_date - nvl(x_clb_grace_period, cn_global.cbk_grace_period);

61: AND r.set_of_books_id = s.set_of_books_id
62: AND r.org_id = x_org_id
63: AND r.org_id=p.org_id(+);
64:
65: x_start_due_date := x_start_date - nvl(x_clb_grace_period, cn_global.cbk_grace_period);
66: x_end_due_date := x_end_date - nvl(x_clb_grace_period,cn_global.cbk_grace_period);
67:
68:
69: -- Insert notification records for clawbacks for those payment schedules

Line 66: x_end_due_date := x_end_date - nvl(x_clb_grace_period,cn_global.cbk_grace_period);

62: AND r.org_id = x_org_id
63: AND r.org_id=p.org_id(+);
64:
65: x_start_due_date := x_start_date - nvl(x_clb_grace_period, cn_global.cbk_grace_period);
66: x_end_due_date := x_end_date - nvl(x_clb_grace_period,cn_global.cbk_grace_period);
67:
68:
69: -- Insert notification records for clawbacks for those payment schedules
70: -- that went past due between the start date of the start period and the

Line 109: cn_global.cbk_event_id,

105: 'N',
106: aps.rowid,
107: aps.payment_schedule_id,
108: 'AR',
109: cn_global.cbk_event_id,
110: x_org_id
111: FROM ar_payment_schedules aps,
112: ra_customer_trx rct,
113: ra_cust_trx_types rctt,

Line 138: AND event_id= cn_global.cbk_event_id

134: AND NOT EXISTS (
135: SELECT 1
136: FROM cn_not_trx
137: WHERE source_trx_id = aps.payment_schedule_id
138: AND event_id= cn_global.cbk_event_id
139: AND org_id = x_org_id) ;
140:
141:
142: x_trx_count := SQL%ROWCOUNT;