APPS.CN_WF_PMT_PKG dependencies on CN_PAYMENT_TRANSACTIONS_ALL

Line 33: FROM cn_payment_transactions_all cnpt, cn_payruns_all pr

29:
30: -- changes for bug#2568937
31: CURSOR get_details IS
32: SELECT cnpt.commission_header_id commission_header_id, cnpt.quota_id quota_id, pr.payrun_mode
33: FROM cn_payment_transactions_all cnpt, cn_payruns_all pr
34: WHERE cnpt.payment_transaction_id = p_posting_detail_id
35: AND cnpt.payrun_id = pr.payrun_id ;
36:
37: -- added new cursor for for bug#2568937 start

Line 46: FROM cn_repositories_all rp, cn_payment_transactions_all trxn

42: -- added new cursor for for bug#2568937 end
43:
44: CURSOR get_accgen_type IS
45: SELECT nvl (payables_ccid_level, 'CUSTOM')
46: FROM cn_repositories_all rp, cn_payment_transactions_all trxn
47: WHERE trxn.org_id = rp.org_id
48: AND trxn.payment_transaction_id = p_posting_detail_id ;
49:
50:

Line 229: update cn_payment_transactions_all

225: l_posting_detail_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'POSTING_DETAIL_ID');
228: if (funcmode = 'RUN') then
229: update cn_payment_transactions_all
230: set expense_ccid = l_expense_ccid,
231: liability_ccid = l_liability_ccid,
232: --Update WHO columns for bug 3866105 (the same as 11.5.8 bug 3854249, 11.5.10 3866113) by Julia Huang on 9/1/04.
233: LAST_UPDATE_DATE = SYSDATE,

Line 311: FROM cn_payment_transactions_all cnpt, cn_payruns_all pr

307: aname => 'POSTING_DETAIL_ID');
308:
309: SELECT pr.payrun_mode, pr.org_id , cnpt.incentive_type_code
310: INTO l_profile_value, l_cached_org_id, l_itc
311: FROM cn_payment_transactions_all cnpt, cn_payruns_all pr
312: WHERE cnpt.payment_transaction_id = l_payment_transaction_id
313: AND cnpt.payrun_id = pr.payrun_id ;
314:
315: