APPS.PO_LINE_LOCATIONS_PKG_S3 dependencies on DUAL

Line 35: FROM DUAL

31: ** both the SCHEDULED and BLANKET types */
32:
33: SELECT 1
34: INTO dummy
35: FROM DUAL
36: WHERE not exists (SELECT 1
37: FROM po_line_locations
38: WHERE po_release_id = X_po_release_id
39: AND shipment_type = X_shipment_type

Line 53: FROM DUAL

49: ** of STANDARD AND PLANNED POS */
50:
51: SELECT 1
52: INTO dummy
53: FROM DUAL
54: WHERE not exists (SELECT 1
55: FROM po_line_locations
56: WHERE po_line_id = X_po_line_id
57: AND shipment_type in ('STANDARD','PLANNED')

Line 70: FROM DUAL

66: */
67:
68: SELECT 1
69: INTO dummy
70: FROM DUAL
71: WHERE not exists (SELECT 1
72: FROM po_line_locations
73: WHERE po_line_id = X_po_line_id
74: AND shipment_type = X_shipment_type

Line 85: FROM DUAL

81: /* This is checking uniques for PRICE BREAKS */
82:
83: SELECT 1
84: INTO dummy
85: FROM DUAL
86: WHERE not exists (SELECT 1
87: FROM po_line_locations
88: WHERE po_line_id = X_po_line_id
89: AND shipment_type = 'PRICE BREAK'

Line 123: FROM DUAL

119: X_progress := '010';
120:
121: SELECT 1
122: INTO dummy
123: FROM DUAL
124: WHERE not exists (SELECT 1
125: FROM po_line_locations
126: WHERE po_line_id = X_po_line_id
127: AND shipment_type = X_shipment_type