APPS.CSFW_DEBRIEF_PUB dependencies on CSI_INSTANCE_STATUSES

Line 1723: from csi_instance_statuses

1719: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;
1720:
1721: cursor c_status_name(v_partStatusCd varchar2) is
1722: select name
1723: from csi_instance_statuses
1724: where INSTANCE_STATUS_ID = v_partStatusCd;
1725:
1726: cursor c_creation_date(v_incident_id number) is
1727: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;

Line 2682: csi_instance_statuses cis

2678: cs_bus_process_txns cbpt,
2679: cs_business_processes cbp,
2680: csi_txn_sub_types ctst,
2681: csi_txn_types ctt,
2682: csi_instance_statuses cis
2683: where
2684: cttv.transaction_type_id = ctbt.transaction_type_id and
2685: ctbt.transaction_type_id = cbpt.transaction_type_id
2686: and ctbt.transaction_type_id = (select transaction_type_id from CSF_DEBRIEF_MAT_LINES_V where debrief_line_id = b_dbfLineId)

Line 3002: csi_instance_statuses cis

2998: cs_bus_process_txns cbpt,
2999: cs_business_processes cbp,
3000: csi_txn_sub_types ctst,
3001: csi_txn_types ctt,
3002: csi_instance_statuses cis
3003: where
3004: cttv.transaction_type_id = ctbt.transaction_type_id and
3005: ctbt.transaction_type_id = cbpt.transaction_type_id
3006: and ctbt.transaction_type_id = (select transaction_type_id from CSF_DEBRIEF_MAT_LINES_V where debrief_line_id = b_dbfLineId)