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.PJI_FM_XBS_ACCUM_UTILS dependencies on DUAL

Line 544: from dual

540: IF p_calling_context='P' THEN
541: begin
542: select 'Y'
543: into l_summ_hasrun
544: from dual
545: where exists (select 1 from pji_fp_xbs_accum_f
546: where project_id=p_project_ids(i)
547: and plan_version_id=-1
548: and rownum=1);

Line 2249: SELECT 'TXN' curr_type FROM DUAL

2245: decode ( cc_src.curr_type, 'POU',1,0) POU_MASK
2246: from
2247: pji_fp_xbs_accum_f fact,
2248: (
2249: SELECT 'TXN' curr_type FROM DUAL
2250: UNION ALL
2251: SELECT 'PRJ' curr_type FROM DUAL
2252: UNION ALL
2253: SELECT 'POU' curr_type FROM DUAL

Line 2251: SELECT 'PRJ' curr_type FROM DUAL

2247: pji_fp_xbs_accum_f fact,
2248: (
2249: SELECT 'TXN' curr_type FROM DUAL
2250: UNION ALL
2251: SELECT 'PRJ' curr_type FROM DUAL
2252: UNION ALL
2253: SELECT 'POU' curr_type FROM DUAL
2254: ) cc_src
2255: where 1=1

Line 2253: SELECT 'POU' curr_type FROM DUAL

2249: SELECT 'TXN' curr_type FROM DUAL
2250: UNION ALL
2251: SELECT 'PRJ' curr_type FROM DUAL
2252: UNION ALL
2253: SELECT 'POU' curr_type FROM DUAL
2254: ) cc_src
2255: where 1=1
2256: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
2257: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id, 8), 8, 'a'), 'b') = 'a'

Line 2473: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual );

2469:
2470: UPDATE pji_plan_extr_tmp TMP
2471: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID,BASE_STRUCT_VER_ID,BASE_PLAN_VER_ID,
2472: WK_STRUCT_VER_ID,WK_PLAN_VER_ID)=
2473: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual );
2474:
2475: END IF;
2476:
2477: PRINT_TIME ( ' populate_workplan_data 0003.6 ' ) ;

Line 3187: SELECT 'TXN' curr_type FROM DUAL

3183: decode ( cc_src.curr_type, 'POU',1,0) POU_MASK
3184: FROM
3185: pji_fp_xbs_accum_f fact,
3186: (
3187: SELECT 'TXN' curr_type FROM DUAL
3188: UNION ALL
3189: SELECT 'PRJ' curr_type FROM DUAL
3190: UNION ALL
3191: SELECT 'POU' curr_type FROM DUAL

Line 3189: SELECT 'PRJ' curr_type FROM DUAL

3185: pji_fp_xbs_accum_f fact,
3186: (
3187: SELECT 'TXN' curr_type FROM DUAL
3188: UNION ALL
3189: SELECT 'PRJ' curr_type FROM DUAL
3190: UNION ALL
3191: SELECT 'POU' curr_type FROM DUAL
3192: ) cc_src
3193: WHERE 1=1

Line 3191: SELECT 'POU' curr_type FROM DUAL

3187: SELECT 'TXN' curr_type FROM DUAL
3188: UNION ALL
3189: SELECT 'PRJ' curr_type FROM DUAL
3190: UNION ALL
3191: SELECT 'POU' curr_type FROM DUAL
3192: ) cc_src
3193: WHERE 1=1
3194: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
3195: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id , 8), 8, 'a'), 'b') = 'a'

Line 3301: dual;

3297: sysdate START_DATE,
3298: null END_DATE,
3299: null COMPLETION_TEXT
3300: from
3301: dual;
3302:
3303: insert into PJI_PJP_PROJ_BATCH_MAP
3304: (
3305: WORKER_ID,

Line 3350: FROM DUAL;

3346: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 004 ' ) ;
3347:
3348: SELECT PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') , PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG')
3349: INTO l_pa_period_flag, l_gl_period_flag
3350: FROM DUAL;
3351:
3352: if (l_pa_period_flag = 'N') then
3353: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3354: 'PA_CALENDAR_FLAG',