APPS.CSD_PROCESS_UTIL dependencies on CS_TXN_BILLING_TYPES

Line 90: from cs_txn_billing_types ctbt,

86: BEGIN
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;

Line 599: cs_txn_billing_types tbt,

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,
603: oe_transaction_types_vl oel

Line 688: from cs_txn_billing_types tbt

684: /*Derive Service activity from SAC-BT combination*/
685: begin
686: select tbt.transaction_type_id
687: into l_transaction_type_id
688: from cs_txn_billing_types tbt
689: where txn_billing_type_id = p_txn_billing_type_id;
690: /* Fixed for bug#5662028
691: and (sysdate) between nvl(tbt.start_date_active,(sysdate))
692: and nvl(tbt.end_date_active,(sysdate));

Line 828: cs_txn_billing_types b

824: cursor c2(p_txn_billing_type_id NUMBER) is
825: select src_return_reqd
826: ,non_src_return_reqd
827: from csi_ib_txn_types a,
828: cs_txn_billing_types b
829: where a.cs_transaction_type_id = b.transaction_type_id
830: and b.txn_billing_type_id = p_txn_billing_type_id;
831:
832: CURSOR repair_line_dtls(p_rep_line_id IN NUMBER) IS

Line 4048: cs_txn_billing_types ctbt

4044: into l_amount
4045: from csd_repair_estimate cre,
4046: csd_repair_estimate_lines crel,
4047: cs_estimate_details ced,
4048: cs_txn_billing_types ctbt
4049: where cre.repair_estimate_id = crel.repair_estimate_id
4050: and crel.estimate_detail_id = ced.estimate_detail_id
4051: and ced.txn_billing_type_id = ctbt.txn_billing_type_id
4052: and cre.repair_line_id = p_repair_line_id

Line 4063: cs_txn_billing_types ctbt

4059: into l_amount
4060: from csd_repair_estimate cre,
4061: csd_repair_estimate_lines crel,
4062: cs_estimate_details ced,
4063: cs_txn_billing_types ctbt
4064: where cre.repair_estimate_id = crel.repair_estimate_id
4065: and crel.estimate_detail_id = ced.estimate_detail_id
4066: and ced.txn_billing_type_id = ctbt.txn_billing_type_id
4067: and cre.repair_line_id = p_repair_line_id

Line 4078: cs_txn_billing_types ctbt

4074: into l_amount
4075: from csd_repair_estimate cre,
4076: csd_repair_estimate_lines crel,
4077: cs_estimate_details ced,
4078: cs_txn_billing_types ctbt
4079: where cre.repair_estimate_id = crel.repair_estimate_id
4080: and crel.estimate_detail_id = ced.estimate_detail_id
4081: and ced.txn_billing_type_id = ctbt.txn_billing_type_id
4082: and cre.repair_line_id = p_repair_line_id

Line 4158: cs_txn_billing_types b

4154: cursor c2(p_txn_billing_type_id NUMBER) is
4155: select SRC_RETURN_REQD
4156: ,NON_SRC_RETURN_REQD
4157: from csi_ib_txn_types a,
4158: cs_txn_billing_types b
4159: where a.cs_transaction_type_id = b.transaction_type_id
4160: and b.txn_billing_type_id = p_txn_billing_type_id;
4161:
4162: l_src_return_reqd varchar2(1); /*Fixed for FP bug#5408047*/

Line 4319: from cs_txn_billing_types a,

4315: select b.line_type_id,
4316: c.line_order_category_code
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