APPS.CSFW_DEBRIEF_PUB dependencies on CSI_INSTANCE_STATUSES

Line 1039: from csi_instance_statuses

1035: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;
1036:
1037: cursor c_status_name(v_partStatusCd varchar2) is
1038: select name
1039: from csi_instance_statuses
1040: where INSTANCE_STATUS_ID = v_partStatusCd;
1041:
1042: cursor c_creation_date(v_incident_id number) is
1043: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;

Line 1833: csi_instance_statuses cis

1829: cs_bus_process_txns cbpt,
1830: cs_business_processes cbp,
1831: csi_txn_sub_types ctst,
1832: csi_txn_types ctt,
1833: csi_instance_statuses cis
1834: where
1835: cttv.transaction_type_id = ctbt.transaction_type_id and
1836: ctbt.transaction_type_id = cbpt.transaction_type_id
1837: and ctbt.transaction_type_id = (select transaction_type_id from CSF_DEBRIEF_MAT_LINES_V where debrief_line_id = b_dbfLineId)

Line 2153: csi_instance_statuses cis

2149: cs_bus_process_txns cbpt,
2150: cs_business_processes cbp,
2151: csi_txn_sub_types ctst,
2152: csi_txn_types ctt,
2153: csi_instance_statuses cis
2154: where
2155: cttv.transaction_type_id = ctbt.transaction_type_id and
2156: ctbt.transaction_type_id = cbpt.transaction_type_id
2157: and ctbt.transaction_type_id = (select transaction_type_id from CSF_DEBRIEF_MAT_LINES_V where debrief_line_id = b_dbfLineId)