APPS.PJI_PA_DEL_MAIN dependencies on PA_PROJECTS_ALL

Line 35: from pa_projects_all

31: l_to_project_id number(20);
32:
33: cursor proj is
34: select project_id
35: from pa_projects_all
36: where segment1 between l_from_project_num and l_to_project_num;
37:
38: begin
39:

Line 75: from pa_projects_all

71:
72: IF p_from_project is not null or p_to_project is not null then
73: select min(segment1) ,max(segment1)
74: into l_from_project_num, l_to_project_num
75: from pa_projects_all
76: where segment1 between nvl(p_from_project,segment1) and nvl(p_to_project,segment1)
77: and decode(p_operating_unit,NULL,org_id,p_operating_unit) = org_id; /* Added for bug 9072943 */
78: END if;
79:

Line 170: from pa_projects_all pa, pa_proj_elem_ver_structure wp

166: l_temp_plan_name varchar2(100);
167:
168: cursor proj_wp(p_from_proj varchar2,p_to_proj varchar2) is
169: select pa.segment1 num,wp.name wp_name
170: from pa_projects_all pa, pa_proj_elem_ver_structure wp
171: where pa.segment1 between p_from_proj and p_to_proj
172: and pa.project_id = wp.project_id
173: and wp.purged_flag = 'Y'
174: and wp.conc_request_id = FND_GLOBAL.CONC_REQUEST_ID; /* Modified for bug 9049425 */

Line 178: from pa_projects_all pa, pa_budget_versions fp

174: and wp.conc_request_id = FND_GLOBAL.CONC_REQUEST_ID; /* Modified for bug 9049425 */
175:
176: cursor proj_fp(p_from_proj varchar2,p_to_proj varchar2) is
177: select pa.segment1 num,fp.version_name fp_name
178: from pa_projects_all pa, pa_budget_versions fp
179: where pa.segment1 between p_from_proj and p_to_proj
180: and pa.project_id = fp.project_id
181: and fp.purged_flag = 'Y'
182: and fp.fin_plan_type_id <> 10