DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on CSI_INSTANCE_STATUSES

Line 1019: from csi_instance_statuses

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

Line 1896: from csi_instance_statuses

1892: and cttv.transaction_type_id = p_transaction_type_id;
1893:
1894: cursor c_cp_status_notnull (p_cp_status varchar2) is
1895: select instance_status_id
1896: from csi_instance_statuses
1897: where name = p_cp_status;
1898:
1899:
1900: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief_line';