APPS.CSF_DEBRIEF_PVT dependencies on CS_TRANSACTION_TYPES_VL

Line 1013: cs_transaction_types_vl cttv

1009:
1010: cursor c_cp_status(p_transaction_type_id number) is
1011: select ctst.src_status_id
1012: from csi_txn_sub_types ctst ,
1013: cs_transaction_types_vl cttv
1014: where ctst.cs_transaction_type_id = cttv.transaction_type_id
1015: AND cttv.transaction_type_id = p_transaction_type_id;
1016:
1017: cursor c_cp_status_notnull (p_cp_status varchar2) is

Line 1031: from cs_transaction_types_vl cttv,

1027: cursor c_txn_billing_type_id (p_txn_billing_type_id number) is
1028: select ctbt.billing_type,
1029: cttv.line_order_category_code,
1030: cttv.transaction_type_id
1031: from cs_transaction_types_vl cttv,
1032: cs_txn_billing_types ctbt
1033: where ctbt.txn_billing_type_id = p_txn_billing_type_id
1034: and ctbt.transaction_type_id = cttv.transaction_type_id;
1035:

Line 1040: from cs_transaction_types_vl cttv,

1036: cursor c_transaction_type_id (p_transaction_type_id number,
1037: p_inventory_item_id number) is
1038: select ctbt.billing_type,
1039: cttv.line_order_category_code
1040: from cs_transaction_types_vl cttv,
1041: cs_txn_billing_types ctbt,
1042: mtl_system_items_b_kfv msibk
1043: where cttv.transaction_type_id = p_transaction_type_id
1044: and cttv.transaction_type_id = ctbt.transaction_type_id

Line 1890: cs_transaction_types_vl cttv

1886:
1887: cursor c_cp_status(p_transaction_type_id number) is
1888: select ctst.src_status_id
1889: from csi_txn_sub_types ctst ,
1890: cs_transaction_types_vl cttv
1891: where ctst.cs_transaction_type_id = cttv.transaction_type_id
1892: and cttv.transaction_type_id = p_transaction_type_id;
1893:
1894: cursor c_cp_status_notnull (p_cp_status varchar2) is

Line 2779: from cs_transaction_types vl

2775: IS
2776: l_dummy number;
2777: cursor get_transaction_type_id is
2778: select 1
2779: from cs_transaction_types vl
2780: where transaction_type_id=P_Transaction_type_id;
2781: BEGIN
2782: -- Initialize message list if p_init_msg_list is set to TRUE.
2783: IF FND_API.to_Boolean( p_init_msg_list )