DBA Data[Home] [Help]

APPS.CN_NOTIFY_ORDERS dependencies on CN_NOT_TRX_S

Line 194: cn_not_trx_s.NEXTVAL,

190: adjusted_flag,
191: event_id)
192: SELECT
193: asoh.org_id,
194: cn_not_trx_s.NEXTVAL,
195: FLOOR(cn_not_trx_s.CURRVAL/NVL(l_sys_batch_size,200)),
196: SYSDATE,
197: asoh.booked_date,
198: l_proc_audit_id,

Line 195: FLOOR(cn_not_trx_s.CURRVAL/NVL(l_sys_batch_size,200)),

191: event_id)
192: SELECT
193: asoh.org_id,
194: cn_not_trx_s.NEXTVAL,
195: FLOOR(cn_not_trx_s.CURRVAL/NVL(l_sys_batch_size,200)),
196: SYSDATE,
197: asoh.booked_date,
198: l_proc_audit_id,
199: 'N',

Line 309: cn_not_trx_s.NEXTVAL,

305: adjusted_flag,
306: event_id)
307: SELECT
308: asoh.org_id,
309: cn_not_trx_s.NEXTVAL,
310: FLOOR(cn_not_trx_s.CURRVAL/NVL(l_sys_batch_size,200)),
311: SYSDATE,
312: asoh.booked_date,
313: l_proc_audit_id,

Line 310: FLOOR(cn_not_trx_s.CURRVAL/NVL(l_sys_batch_size,200)),

306: event_id)
307: SELECT
308: asoh.org_id,
309: cn_not_trx_s.NEXTVAL,
310: FLOOR(cn_not_trx_s.CURRVAL/NVL(l_sys_batch_size,200)),
311: SYSDATE,
312: asoh.booked_date,
313: l_proc_audit_id,
314: 'N',

Line 1370: cn_not_trx_s.NEXTVAL,

1366: adjusted_flag,
1367: event_id,
1368: org_id)
1369: SELECT
1370: cn_not_trx_s.NEXTVAL,
1371: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
1372: SYSDATE,
1373: asoh.booked_date,
1374: l_proc_audit_id,

Line 1371: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),

1367: event_id,
1368: org_id)
1369: SELECT
1370: cn_not_trx_s.NEXTVAL,
1371: FLOOR(cn_not_trx_s.CURRVAL/l_sys_batch_size),
1372: SYSDATE,
1373: asoh.booked_date,
1374: l_proc_audit_id,
1375: 'N',