DBA Data[Home] [Help]

APPS.CN_PMT_TRANS_PKG dependencies on CN_PAYMENT_TRANSACTIONS_S

Line 22: SELECT cn_payment_transactions_s.NEXTVAL

18: )
19: IS
20: CURSOR get_id
21: IS
22: SELECT cn_payment_transactions_s.NEXTVAL
23: FROM DUAL;
24: BEGIN
25: OPEN get_id;
26:

Line 318: SELECT cn_payment_transactions_s.NEXTVAL,

314: --Bug 3080846 for who columns
315: org_id,
316: object_version_number
317: )
318: SELECT cn_payment_transactions_s.NEXTVAL,
319: p_posting_batch_id,
320: v1.incentive_type_code,
321: v1.credit_type_id,
322: v1.period_id,

Line 414: SELECT cn_payment_transactions_s.NEXTVAL,

410: last_update_login,
411: org_id,
412: object_version_number
413: )
414: SELECT cn_payment_transactions_s.NEXTVAL,
415: p_posting_batch_id,
416: 'COMMISSION',
417: srp.credit_type_id,
418: srp.period_id,

Line 504: SELECT cn_payment_transactions_s.NEXTVAL,

500: org_id,
501: object_version_number,
502: processed_date
503: )
504: SELECT cn_payment_transactions_s.NEXTVAL,
505: p_posting_batch_id,
506: cl.trx_type,
507: spayee.payee_id,
508: cl.role_id,

Line 610: SELECT cn_payment_transactions_s.NEXTVAL,

606: org_id,
607: object_version_number,
608: processed_date
609: )
610: SELECT cn_payment_transactions_s.NEXTVAL,
611: p_posting_batch_id,
612: cl.trx_type,
613: cl.credited_salesrep_id,
614: cl.role_id,