APPS.CSF_DEBRIEF_PVT dependencies on CS_TRANSACTION_TYPES_VL

Line 1011: cs_transaction_types_vl cttv

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

Line 1029: from cs_transaction_types_vl cttv,

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

Line 1038: from cs_transaction_types_vl cttv,

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

Line 1837: cs_transaction_types_vl cttv

1833:
1834: cursor c_cp_status(p_transaction_type_id number) is
1835: select ctst.src_status_id
1836: from csi_txn_sub_types ctst ,
1837: cs_transaction_types_vl cttv
1838: where ctst.cs_transaction_type_id = cttv.transaction_type_id
1839: and cttv.transaction_type_id = p_transaction_type_id;
1840:
1841: cursor c_cp_status_notnull (p_cp_status varchar2) is

Line 2711: from cs_transaction_types vl

2707: IS
2708: l_dummy number;
2709: cursor get_transaction_type_id is
2710: select 1
2711: from cs_transaction_types vl
2712: where transaction_type_id=P_Transaction_type_id;
2713: BEGIN
2714: -- Initialize message list if p_init_msg_list is set to TRUE.
2715: IF FND_API.to_Boolean( p_init_msg_list )