APPS.CSP_PACKLIST_PVT dependencies on CSP_PACKLIST_LINES

Line 14: from csp_packlist_lines cpal

10: l_quantity_packed NUMBER;
11:
12: cursor c_packed_quantity is
13: select sum(nvl(cpal.quantity_packed,0))
14: from csp_packlist_lines cpal
15: where cpal.picklist_line_id = p_picklist_line_id;
16:
17: BEGIN
18: open c_packed_quantity;

Line 35: csp_packlist_lines cpal

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)
39: and decode(p_lot_number,null,'1',cpasl.lot_number) = decode(p_lot_number,null,'1',p_lot_number);