APPS.CSF_DEBRIEF_PVT dependencies on CSI_INSTANCE_STATUSES

Line 1017: from csi_instance_statuses

1013: and cttv.transaction_type_id = p_transaction_type_id;
1014:
1015: cursor c_cp_status_notnull (p_cp_status varchar2) is
1016: select instance_status_id
1017: from csi_instance_statuses
1018: where name = p_cp_status;
1019:
1020: cursor labor_uom(p_inventory_item_id number) is
1021: select primary_uom_code

Line 1843: from csi_instance_statuses

1839: and cttv.transaction_type_id = p_transaction_type_id;
1840:
1841: cursor c_cp_status_notnull (p_cp_status varchar2) is
1842: select instance_status_id
1843: from csi_instance_statuses
1844: where name = p_cp_status;
1845:
1846:
1847: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief_line';