APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on PA_PROJECTS

Line 61: l_struct_sharing_code pa_projects_all.structure_sharing_code%type;

57: l_etc_fp_ver_name VARCHAR2(60);
58: l_fp_options_id number;
59: l_project_name VARCHAR2(200);
60: l_plan_type_name pa_fin_plan_types_tl.name%type;
61: l_struct_sharing_code pa_projects_all.structure_sharing_code%type;
62: l_return_status varchar2(10);
63: l_msg_count number;
64: l_msg_data varchar2(2000);
65: l_msg_data_in varchar2(2000);

Line 136: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent

132: -- Bug 4367064: Instead of checking if pj.project_status_code <> 'CLOSED'
133: -- directly, we make use of the Is_Project_Status_Closed function, which
134: -- returns 'Y' if the project_status_code is equivalent to 'CLOSED'.
135:
136: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent
137: -- program has been modified to make it single org compliant.
138:
139: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||
140: ' pa_fin_plan_types_b pt, pa_project_types_all pta';

Line 139: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||

135:
136: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent
137: -- program has been modified to make it single org compliant.
138:
139: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||
140: ' pa_fin_plan_types_b pt, pa_project_types_all pta';
141: l_where_clause := ' WHERE 1 = 1 AND pj.project_id = opt.project_id' ||
142: ' AND nvl(pj.template_flag,''N'') <> ''Y''' ||
143: ' AND NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed' ||

Line 175: ||' AND pp.object_type = ''PA_PROJECTS'' AND pp.resource_source_id = '

171: -- Replaced SQL literal with a bind variable.
172: IF (p_proj_manager_id IS NOT NULL) THEN
173: l_from_clause := l_from_clause ||', pa_project_parties pp';
174: l_where_clause1 := l_where_clause1 ||' AND pp.project_id = pj.project_id'
175: ||' AND pp.object_type = ''PA_PROJECTS'' AND pp.resource_source_id = '
176: ||' :proj_manager_id';
177: END IF;
178:
179: -- Bug 4367064: Instead of checking if pj.project_status_code <> 'CLOSED'

Line 187: FROM pa_projects pj /* Bug 5657334 */

183: --*****p_from_project_no ande p_to_project_no****--
184: IF (p_from_project_no IS NULL) THEN
185: SELECT min(pj.segment1)
186: INTO l_from_proj_no
187: FROM pa_projects pj /* Bug 5657334 */
188: WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';
189:
190: ELSE
191: l_from_proj_no := p_from_project_no;

Line 203: FROM pa_projects pj /* Bug 5657334 */

199:
200: IF (p_to_project_no IS NULL) THEN
201: SELECT max(pj.segment1)
202: INTO l_to_proj_no
203: FROM pa_projects pj /* Bug 5657334 */
204: WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';
205: ELSE
206: l_to_proj_no := p_to_project_no;
207: -- hr_utility.trace('l_to_proj_no '||l_to_proj_no);