APPS.CSD_PROCESS_UTIL dependencies on CS_TXN_BILLING_TYPES

Line 82: from cs_txn_billing_types ctbt,

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

Line 591: cs_txn_billing_types tbt,

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

Line 680: from cs_txn_billing_types tbt

676: /*Derive Service activity from SAC-BT combination*/
677: begin
678: select tbt.transaction_type_id
679: into l_transaction_type_id
680: from cs_txn_billing_types tbt
681: where txn_billing_type_id = p_txn_billing_type_id;
682: /* Fixed for bug#5662028
683: and (sysdate) between nvl(tbt.start_date_active,(sysdate))
684: and nvl(tbt.end_date_active,(sysdate));

Line 816: cs_txn_billing_types b

812: cursor c2(p_txn_billing_type_id NUMBER) is
813: select src_return_reqd
814: ,non_src_return_reqd
815: from csi_ib_txn_types a,
816: cs_txn_billing_types b
817: where a.cs_transaction_type_id = b.transaction_type_id
818: and b.txn_billing_type_id = p_txn_billing_type_id;
819:
820: CURSOR repair_line_dtls(p_rep_line_id IN NUMBER) IS

Line 3817: cs_txn_billing_types ctbt

3813: into l_amount
3814: from csd_repair_estimate cre,
3815: csd_repair_estimate_lines crel,
3816: cs_estimate_details ced,
3817: cs_txn_billing_types ctbt
3818: where cre.repair_estimate_id = crel.repair_estimate_id
3819: and crel.estimate_detail_id = ced.estimate_detail_id
3820: and ced.txn_billing_type_id = ctbt.txn_billing_type_id
3821: and cre.repair_line_id = p_repair_line_id

Line 3832: cs_txn_billing_types ctbt

3828: into l_amount
3829: from csd_repair_estimate cre,
3830: csd_repair_estimate_lines crel,
3831: cs_estimate_details ced,
3832: cs_txn_billing_types ctbt
3833: where cre.repair_estimate_id = crel.repair_estimate_id
3834: and crel.estimate_detail_id = ced.estimate_detail_id
3835: and ced.txn_billing_type_id = ctbt.txn_billing_type_id
3836: and cre.repair_line_id = p_repair_line_id

Line 3847: cs_txn_billing_types ctbt

3843: into l_amount
3844: from csd_repair_estimate cre,
3845: csd_repair_estimate_lines crel,
3846: cs_estimate_details ced,
3847: cs_txn_billing_types ctbt
3848: where cre.repair_estimate_id = crel.repair_estimate_id
3849: and crel.estimate_detail_id = ced.estimate_detail_id
3850: and ced.txn_billing_type_id = ctbt.txn_billing_type_id
3851: and cre.repair_line_id = p_repair_line_id

Line 3927: cs_txn_billing_types b

3923: cursor c2(p_txn_billing_type_id NUMBER) is
3924: select SRC_RETURN_REQD
3925: ,NON_SRC_RETURN_REQD
3926: from csi_ib_txn_types a,
3927: cs_txn_billing_types b
3928: where a.cs_transaction_type_id = b.transaction_type_id
3929: and b.txn_billing_type_id = p_txn_billing_type_id;
3930:
3931: l_src_return_reqd varchar2(1); /*Fixed for FP bug#5408047*/

Line 4061: from cs_txn_billing_types a,

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