DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on CS_TRANSACTION_TYPES

Line 91: cs_transaction_types ctt

87: Begin
88: Select Nvl(ctt.no_charge_flag,'N')
89: into l_no_chg_flag
90: from cs_txn_billing_types ctbt,
91: cs_transaction_types ctt
92: where ctbt.transaction_type_id = ctt.transaction_type_id
93: and ctbt.txn_billing_type_id = p_txn_billing_type_id;
94: Return l_no_chg_flag;
95: Exception

Line 598: from cs_transaction_types_b tt,

594: l_profile varchar2(1);
595:
596: cursor valid_txn_billing_type is
597: select tbt.txn_billing_type_id
598: from cs_transaction_types_b tt,
599: cs_txn_billing_types tbt,
600: cs_billing_type_categories cbtc,
601: cs_txn_billing_oetxn_all tb,
602: oe_transaction_types_vl oeh,

Line 4321: cs_transaction_types_vl c

4317: into x_line_type_id,
4318: x_line_category_code
4319: from cs_txn_billing_types a,
4320: CS_TXN_BILLING_OETXN_ALL b,
4321: cs_transaction_types_vl c
4322: where a.txn_billing_type_id = b.txn_billing_type_id
4323: and a.transaction_type_id = c.transaction_type_id
4324: and a.txn_billing_type_id = p_txn_billing_type_id
4325: and b.org_id = p_org_id;