DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CSI_IB_TXN_TYPES

Line 3626: FROM CSI_IB_TXN_TYPES

3622: l_action_code varchar2(30);
3623:
3624: Cursor C_SRC_CHANGE_OWNER(p_txn_billing_type_id NUMBER) IS
3625: SELECT src_change_owner
3626: FROM CSI_IB_TXN_TYPES
3627: WHERE cs_transaction_type_id = p_txn_billing_type_id;
3628:
3629: -- Depot Loaner fix - Bug# 4586140
3630: -- Cursor to get depot details

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

7592:
7593: --taklam
7594: IF l_valid_check <> 'Y' THEN
7595: --Check if Service activity has 'change owner flag' set to 'N'
7596: --(See the csi_ib_txn_types table for the flag value)
7597: --'change owner flag'
7598:
7599: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
7600: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

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

7797:
7798: --taklam
7799: IF l_valid_check <> 'Y' THEN
7800: --Check if Service activity has 'change owner flag' set to 'N'
7801: --(See the csi_ib_txn_types table for the flag value)
7802: --'change owner flag'
7803:
7804: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
7805: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

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

8079:
8080: --taklam
8081: IF l_valid_check <> 'Y' THEN
8082: --Check if Service activity has 'change owner flag' set to 'N'
8083: --(See the csi_ib_txn_types table for the flag value)
8084: --'change owner flag'
8085:
8086: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
8087: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

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

8300:
8301: --taklam
8302: IF l_valid_check <> 'Y' THEN
8303: --Check if Service activity has 'change owner flag' set to 'N'
8304: --(See the csi_ib_txn_types table for the flag value)
8305: --'change owner flag'
8306:
8307: OPEN C_SRC_CHANGE_OWNER(p_charges_detail_rec.txn_billing_type_id);
8308: FETCH C_SRC_CHANGE_OWNER INTO l_src_change_owner;

Line 13489: csi_ib_txn_types citt,

13485: tt.line_order_category_code,
13486: ol.meaning line_category_meaning
13487: FROM CS_TRANSACTION_TYPES_VL tt,
13488: CS_BUS_PROCESS_TXNS bt,
13489: csi_ib_txn_types citt,
13490: csi_source_ib_types csit,
13491: CSI_TXN_TYPES ctt,
13492: OE_LOOKUPS ol
13493: WHERE tt.transaction_type_id = p_txn_type_id