13: select project_id from pa_projects_all
14: where project_id = X_project_id;
15:
16: CURSOR s IS
17: select project_id from pjm_seiban_numbers
18: where project_id = X_project_id;
19:
20: BEGIN
21:
106: from pa_projects_all
107: where project_id = X_project_id
108: union
109: select project_number
110: from pjm_seiban_numbers
111: where project_id = X_project_id;
112:
113: begin
114:
134: from pa_projects_all
135: where project_id = X_project_id
136: union
137: select project_name
138: from pjm_seiban_numbers
139: where project_id = X_project_id;
140:
141: begin
142:
686: , to_date(null)
687: , to_date(null)
688: , trunc(pp.start_date_active)
689: , trunc(pp.end_date_active)
690: from pjm_seiban_numbers sn
691: , pjm_project_parameters pp
692: where sn.project_id = X_project_id
693: and pp.organization_id (+) = X_inventory_org_id
694: and pp.project_id (+) = sn.project_id;