664: NULL,
665: NULL)
666: )
667: ) , 0 ) requested_quantity
668: FROM wsh_deliverables_v a
669: WHERE a.source_line_id = p_line_id
670: AND a.released_status = 'B';
671:
672: l_last_day_of_period DATE;