DBA Data[Home] [Help]

APPS.CN_WF_PMT_PKG dependencies on CN_REPOSITORIES

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 51: l_accgen_type cn_repositories.payables_ccid_level%type;

47: WHERE trxn.org_id = rp.org_id
48: AND trxn.payment_transaction_id = p_posting_detail_id ;
49:
50:
51: l_accgen_type cn_repositories.payables_ccid_level%type;
52:
53: l_revenue_class_id cn_commission_headers.revenue_class_id%type;
54: l_profile_value VArchar2(01);
55: