DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on CS_TRANSACTION_TYPES

Line 83: cs_transaction_types ctt

79: Begin
80: Select Nvl(ctt.no_charge_flag,'N')
81: into l_no_chg_flag
82: from cs_txn_billing_types ctbt,
83: cs_transaction_types ctt
84: where ctbt.transaction_type_id = ctt.transaction_type_id
85: and ctbt.txn_billing_type_id = p_txn_billing_type_id;
86: Return l_no_chg_flag;
87: Exception

Line 590: from cs_transaction_types_b tt,

586: l_profile varchar2(1);
587:
588: cursor valid_txn_billing_type is
589: select tbt.txn_billing_type_id
590: from cs_transaction_types_b tt,
591: cs_txn_billing_types tbt,
592: cs_billing_type_categories cbtc,
593: cs_txn_billing_oetxn_all tb,
594: oe_transaction_types_vl oeh,

Line 4063: cs_transaction_types_vl c

4059: into x_line_type_id,
4060: x_line_category_code
4061: from cs_txn_billing_types a,
4062: CS_TXN_BILLING_OETXN_ALL b,
4063: cs_transaction_types_vl c
4064: where a.txn_billing_type_id = b.txn_billing_type_id
4065: and a.transaction_type_id = c.transaction_type_id
4066: and a.txn_billing_type_id = p_txn_billing_type_id
4067: and b.org_id = p_org_id;