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 116: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent

112: -- Bug 4367064: Instead of checking if pj.project_status_code <> 'CLOSED'
113: -- directly, we make use of the Is_Project_Status_Closed function, which
114: -- returns 'Y' if the project_status_code is equivalent to 'CLOSED'.
115:
116: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent
117: -- program has been modified to make it single org compliant.
118:
119: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||
120: ' pa_fin_plan_types_b pt, pa_project_types_all pta';

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

115:
116: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent
117: -- program has been modified to make it single org compliant.
118:
119: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||
120: ' pa_fin_plan_types_b pt, pa_project_types_all pta';
121: l_where_clause := ' WHERE 1 = 1 AND pj.project_id = opt.project_id' ||
122: ' AND nvl(pj.template_flag,''N'') <> ''Y''' ||
123: ' AND NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed' ||

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

151: -- Replaced SQL literal with a bind variable.
152: IF (p_proj_manager_id IS NOT NULL) THEN
153: l_from_clause := l_from_clause ||', pa_project_parties pp';
154: l_where_clause1 := l_where_clause1 ||' AND pp.project_id = pj.project_id'
155: ||' AND pp.object_type = ''PA_PROJECTS'' AND pp.resource_source_id = '
156: ||' :proj_manager_id';
157: END IF;
158:
159: -- Bug 4367064: Instead of checking if pj.project_status_code <> 'CLOSED'

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

163: --*****p_from_project_no ande p_to_project_no****--
164: IF (p_from_project_no IS NULL) THEN
165: SELECT min(pj.segment1)
166: INTO l_from_proj_no
167: FROM pa_projects pj /* Bug 5657334 */
168: WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';
169:
170: ELSE
171: l_from_proj_no := p_from_project_no;

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

179:
180: IF (p_to_project_no IS NULL) THEN
181: SELECT max(pj.segment1)
182: INTO l_to_proj_no
183: FROM pa_projects pj /* Bug 5657334 */
184: WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';
185: ELSE
186: l_to_proj_no := p_to_project_no;
187: -- hr_utility.trace('l_to_proj_no '||l_to_proj_no);