APPS.CSP_PACKLIST_PVT dependencies on CSP_PACKLIST_SERIAL_LOTS

Line 34: from csp_packlist_serial_lots cpasl,

30: l_quantity_packed NUMBER;
31:
32: cursor c_packed_quantity is
33: select sum(nvl(cpasl.quantity,0))
34: from csp_packlist_serial_lots cpasl,
35: csp_packlist_lines cpal
36: where cpal.picklist_line_id = p_picklist_line_id
37: and cpasl.packlist_line_id = cpal.packlist_line_id
38: and decode(p_serial_number,null,'1',cpasl.serial_number) = decode(p_serial_number,null,'1',p_serial_number)