APPS.CSF_DEBRIEF_PVT dependencies on CSI_TXN_SUB_TYPES

Line 1010: from csi_txn_sub_types ctst ,

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

Line 1836: from csi_txn_sub_types ctst ,

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