APPS.PJM_SEIBAN_PKG dependencies on PA_PROJECTS

Line 40: from pa_projects_all

36: IS
37:
38: CURSOR c IS
39: select project_id
40: from pa_projects_all
41: where segment1 = X_project_number
42: and ( X_project_id is null or project_id <> X_project_id )
43: union all
44: select project_id

Line 80: from pa_projects_all

76: IS
77:
78: CURSOR c IS
79: select project_id
80: from pa_projects_all
81: where name = X_project_name
82: and ( X_project_id is null or project_id <> X_project_id )
83: union all
84: select project_id

Line 214: from pa_projects_all

210: -- bug 4731449
211: l_resp_id := FND_GLOBAL.Resp_id;
212: l_user_id := FND_GLOBAL.User_id;
213: select org_id into l_org_id
214: from pa_projects_all
215: where project_id = X_project_created_from;
216: select application_id into l_resp_appl_id
217: from fnd_responsibility where responsibility_id = l_resp_id;
218:

Line 403: FROM pa_projects

399: l_wf_status_code varchar2(30);
400:
401: CURSOR get_wf_status (C_project_id IN NUMBER) IS
402: SELECT wf_status_code
403: FROM pa_projects
404: WHERE project_id = C_project_id;
405:
406: BEGIN
407:

Line 468: FROM PA_Projects

464: L_Project_ID := X_Project_ID;
465:
466: SELECT segment1
467: INTO L_Project_Num
468: FROM PA_Projects
469: WHERE Project_ID = L_Project_ID;
470:
471: end if;
472: