[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
2243: decode ( cc_src.curr_type, 'TXN',1,0) TXN_MASK,
2244: decode ( cc_src.curr_type, 'PRJ',1,0) PRJ_MASK,
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
3181: decode ( cc_src.curr_type, 'TXN',1,0) TXN_MASK,
3182: decode ( cc_src.curr_type, 'PRJ',1,0) PRJ_MASK,
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