APPS.PJM_SEIBAN_PUB dependencies on PA_PROJECTS_ALL

Line 25: SELECT project_id , segment1 FROM pa_projects_all ) s

21: CURSOR v1 IS
22: SELECT s.project_id
23: FROM ( SELECT project_id , project_number FROM pjm_seiban_numbers
24: UNION ALL
25: SELECT project_id , segment1 FROM pa_projects_all ) s
26: WHERE s.project_number = P_seiban_number;
27:
28: CURSOR v2 IS
29: SELECT s.project_id

Line 32: SELECT project_id , name FROM pa_projects_all ) s

28: CURSOR v2 IS
29: SELECT s.project_id
30: FROM ( SELECT project_id , project_name FROM pjm_seiban_numbers
31: UNION ALL
32: SELECT project_id , name FROM pa_projects_all ) s
33: WHERE s.project_name = P_seiban_name;
34:
35: CURSOR v3 IS
36: SELECT meaning