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 667: FROM cr_rsrc_dtl
663: undetermined_calendar EXCEPTION ;
664:
665: CURSOR plant_cur is
666: SELECT organization_id, calendar_code 667: FROM cr_rsrc_dtl 668: WHERE resource_id = p_resource_id
669: AND delete_mark = 0
670: AND inactive_ind = 0 ;
671: