[Home] [Help]
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);
549: exception when no_data_found then
2496: decode ( cc_src.curr_type, 'TXN',1,0) TXN_MASK,
2497: decode ( cc_src.curr_type, 'PRJ',1,0) PRJ_MASK,
2498: decode ( cc_src.curr_type, 'POU',1,0) POU_MASK
2499: from
2500: pji_fp_xbs_accum_f fact,
2501: /* (
2502: SELECT 'TXN' curr_type FROM DUAL
2503: UNION ALL
2504: SELECT 'PRJ' curr_type FROM DUAL
4300: decode ( cc_src.curr_type, 'TXN',1,0) TXN_MASK,
4301: decode ( cc_src.curr_type, 'PRJ',1,0) PRJ_MASK,
4302: decode ( cc_src.curr_type, 'POU',1,0) POU_MASK
4303: FROM
4304: pji_fp_xbs_accum_f fact,
4305: /* (
4306: SELECT 'TXN' curr_type FROM DUAL
4307: UNION ALL
4308: SELECT 'PRJ' curr_type FROM DUAL