eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on PA_PROJECT_STUS_UTILS

Line 143: ' AND NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed' ||

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' ||
144: '(pj.project_status_code),''N'') <> ''Y''' ||
145: ' AND opt.FIN_PLAN_OPTION_LEVEL_CODE = ''PLAN_TYPE''' ||
146: 'AND (pj.project_type = pta.project_type AND pta.org_project_flag <> ''Y'')';
147: l_where_clause0:= ' AND pt.fin_plan_type_id = opt.fin_plan_type_id';

Line 188: WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';

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;
192: -- hr_utility.trace('l_from_proj_no '||l_from_proj_no);

Line 204: WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';

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);
208: END IF;