DBA Data[Home] [Help]

APPS.CN_WF_PMT_PKG dependencies on CN_PAYRUNS_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 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: