DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CSI_IB_TXN_TYPES

Line 3830: FROM CSI_IB_TXN_TYPES

3826: l_credit_status boolean := TRUE;--Credit Card 9358401
3827: L_CURR_IN_CONVERSION_LIST VARCHAR2(1); --12.1.3 Charges Logistic Multi Currency , vpremach
3828: Cursor C_SRC_CHANGE_OWNER(p_txn_billing_type_id NUMBER) IS
3829: SELECT src_change_owner
3830: FROM CSI_IB_TXN_TYPES
3831: WHERE cs_transaction_type_id = p_txn_billing_type_id;
3832:
3833: -- Depot Loaner fix - Bug# 4586140
3834: -- Cursor to get depot details

Line 7890: --(See the csi_ib_txn_types table for the flag value)

7886:
7887: --taklam
7888: IF l_valid_check <> 'Y' THEN
7889: --Check if Service activity has 'change owner flag' set to 'N'
7890: --(See the csi_ib_txn_types table for the flag value)
7891: --'change owner flag'
7892:
7893: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
7894: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

Line 8139: --(See the csi_ib_txn_types table for the flag value)

8135:
8136: --taklam
8137: IF l_valid_check <> 'Y' THEN
8138: --Check if Service activity has 'change owner flag' set to 'N'
8139: --(See the csi_ib_txn_types table for the flag value)
8140: --'change owner flag'
8141:
8142: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
8143: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

Line 8421: --(See the csi_ib_txn_types table for the flag value)

8417:
8418: --taklam
8419: IF l_valid_check <> 'Y' THEN
8420: --Check if Service activity has 'change owner flag' set to 'N'
8421: --(See the csi_ib_txn_types table for the flag value)
8422: --'change owner flag'
8423:
8424: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
8425: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

Line 8643: --(See the csi_ib_txn_types table for the flag value)

8639:
8640: --taklam
8641: IF l_valid_check <> 'Y' THEN
8642: --Check if Service activity has 'change owner flag' set to 'N'
8643: --(See the csi_ib_txn_types table for the flag value)
8644: --'change owner flag'
8645:
8646: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
8647: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

Line 15026: csi_ib_txn_types citt,

15022: tt.line_order_category_code,
15023: ol.meaning line_category_meaning
15024: FROM CS_TRANSACTION_TYPES_VL tt,
15025: CS_BUS_PROCESS_TXNS bt,
15026: csi_ib_txn_types citt,
15027: csi_source_ib_types csit,
15028: CSI_TXN_TYPES ctt,
15029: OE_LOOKUPS ol
15030: WHERE tt.transaction_type_id = p_txn_type_id