APPS.PJM_PROJECT dependencies on PA_PROJECTS_ALL

Line 13: select project_id from pa_projects_all

9: L_seiban NUMBER;
10: L_flag VARCHAR2(10) := 'N';
11:
12: CURSOR p IS
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

Line 50: from pa_projects_all_expend_v

46:
47: BEGIN
48:
49: select project_id into L_proj_id
50: from pa_projects_all_expend_v
51: where project_id = X_project_id
52: and expenditure_org_id = X_org_id;
53:
54: return ('Y');

Line 106: from pa_projects_all

102: ) return varchar2 IS
103: L_project_num varchar2(30);
104: cursor C1 is
105: select segment1
106: from pa_projects_all
107: where project_id = X_project_id
108: union
109: select project_number
110: from pjm_seiban_numbers

Line 134: from pa_projects_all

130: ) return varchar2 IS
131: L_project_name varchar2(30);
132: cursor C1 is
133: select name
134: from pa_projects_all
135: where project_id = X_project_id
136: union
137: select project_name
138: from pjm_seiban_numbers

Line 676: from pa_projects_all p

672: , trunc(p.start_date)
673: , trunc(p.completion_date)
674: , trunc(pp.start_date_active)
675: , trunc(pp.end_date_active)
676: from pa_projects_all p
677: , pjm_project_parameters pp
678: where p.project_id = X_project_id
679: and pp.project_id (+) = p.project_id
680: and pp.organization_id (+) = X_inventory_org_id;