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