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 123: ' AND NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed' ||

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' ||
124: '(pj.project_status_code),''N'') <> ''Y''' ||
125: ' AND opt.FIN_PLAN_OPTION_LEVEL_CODE = ''PLAN_TYPE''' ||
126: 'AND (pj.project_type = pta.project_type AND pta.org_project_flag <> ''Y'')';
127: l_where_clause0:= ' AND pt.fin_plan_type_id = opt.fin_plan_type_id';

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

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

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

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