143: )
144: ORDER BY from_time;
145:
146: CURSOR qty_c3 IS 147: SELECT assigned_qty FROM cr_rsrc_dtl 148: WHERE resource_id = p_resource_id;
149:
150: c INTEGER := 0;
151: u INTEGER ;
Line 697: FROM cr_rsrc_dtl
693: undetermined_calendar EXCEPTION ;
694:
695: CURSOR plant_cur is
696: SELECT organization_id, calendar_code 697: FROM cr_rsrc_dtl 698: WHERE resource_id = p_resource_id
699: AND delete_mark = 0
700: AND inactive_ind = 0 ;
701: