DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on CSI_TXN_SUB_TYPES

Line 1012: from csi_txn_sub_types ctst ,

1008: AND jtsb.task_status_id = jta.assignment_status_id;
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:

Line 1889: from csi_txn_sub_types ctst ,

1885:
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: