95: pde.SEGMENT1
96: INTO
97: g_project_number
98: FROM
99: PO_DISTRIBUTIONS_ALL pd,
100: PA_PROJECTS_ALL pde
101: WHERE
102: pd.PO_DISTRIBUTION_ID = l_distribution_id
103: AND pde.PROJECT_ID = pd.PROJECT_ID;
111: pte.TASK_NUMBER
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;
137: DISTINCT(pde.SEGMENT1)
138: INTO
139: g_project_number
140: FROM
141: PO_DISTRIBUTIONS_ALL pd,
142: PA_PROJECTS_ALL pde
143: WHERE
144: pd.LINE_LOCATION_ID = l_line_location_id
145: AND pde.PROJECT_ID = pd.PROJECT_ID;
156: DISTINCT(pte.TASK_NUMBER)
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;