112: INTO
113: g_task_number
114: FROM
115: PO_DISTRIBUTIONS_ALL pd,
116: PA_TASKS pte
117: WHERE
118: pd.PO_DISTRIBUTION_ID = l_distribution_id
119: AND pte.TASK_ID = pd.TASK_ID;
120:
157: INTO
158: g_task_number
159: FROM
160: PO_DISTRIBUTIONS_ALL pd,
161: PA_TASKS pte
162: WHERE
163: pd.LINE_LOCATION_ID = l_line_location_id
164: AND pte.TASK_ID = pd.TASK_ID;
165: