APPS.PA_FP_CALC_PLAN_PKG dependencies on DUAL

Line 1250: FROM DUAL

1246: l_exists_flag Varchar2(10) := 'N';
1247: BEGIN
1248: SELECT 'Y'
1249: INTO l_exists_flag
1250: FROM DUAL
1251: WHERE EXISTS (select null
1252: from pa_fp_spread_calc_tmp1 tmp1
1253: where tmp1.budget_version_id = p_budget_version_id
1254: );

Line 1746: FROM DUAL

1742: x_return_status OUT NOCOPY varchar2 ) IS
1743:
1744: CURSOR cur_retSts IS
1745: SELECT 'E'
1746: FROM DUAL
1747: WHERE EXISTS (select null
1748: from pa_fp_rollup_tmp tmp
1749: where ( tmp.cost_rejection_code in ('PA_FP_PROJ_NO_TXNCONVRATE'
1750: ,'PA_FP_PRJFUNC_CURR_NULL'

Line 1967: FROM DUAL

1963: ,g_mrc_projfunc_rev_exg_rt_tab(i)
1964: ,g_mrc_projfunc_rev_dt_type_tab(i)
1965: ,g_mrc_projfunc_rev_rt_dt_tab(i)
1966: ,g_mrc_delete_flag_tab(i)
1967: FROM DUAL
1968: WHERE NOT EXISTS (SELECT NULL
1969: FROM PA_FP_ROLLUP_TMP RLTMP1
1970: WHERE rltmp1.budget_line_id = g_mrc_budget_line_id_tab(i)
1971: );

Line 2866: FROM dual

2862: l_act_exists Varchar2(10) := 'N';
2863:
2864: CURSOR cur_act_exists IS
2865: SELECT 'Y'
2866: FROM dual
2867: WHERE EXISTS (select null
2868: from pa_budget_lines bl
2869: Where bl.budget_version_id = p_budget_version_id
2870: AND (nvl(bl.init_quantity,0) <> 0

Line 3604: FROM DUAL

3600:
3601:
3602: CURSOR cur_sp_bl_chk IS
3603: SELECT 'Y'
3604: FROM DUAL
3605: WHERE EXISTS (select null
3606: from pa_budget_lines bl
3607: ,pa_resource_assignments ra
3608: where ra.resource_assignment_id = p_res_ass_id

Line 7043: FROM DUAL;

7039: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
7040: END IF;
7041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7042: SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS') INTO g_session_time
7043: FROM DUAL;
7044: print_msg('RETURN bvid => '||g_budget_version_id||' ,pid => '||g_project_id||' ,sesstime => '||g_session_time);
7045: RETURN;
7046: END;
7047: ELSE

Line 7087: FROM DUAL;

7083: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
7084: END IF;
7085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7086: SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS') INTO g_session_time
7087: FROM DUAL;
7088: print_msg('RETURN bvid => '||g_budget_version_id||' ,pid => '||g_project_id||' ,sesstime => '||g_session_time);
7089: RETURN;
7090: END;
7091: END IF;

Line 7614: from dual

7610: ,x_actual_flag OUT NOCOPY varchar2 ) IS
7611:
7612: cursor getActualBlLines IS
7613: select 'Y'
7614: from dual
7615: where EXISTS
7616: (select null
7617: from pa_budget_lines bl
7618: where bl.resource_assignment_id = p_res_ass_id

Line 10588: FROM dual;

10584: ,'E','E'
10585: ,'U','U'
10586: ,'S','S'),'E')
10587: INTO l_return_status
10588: FROM dual;
10589: x_return_status := l_return_status;
10590: l_entire_return_status := l_return_status;
10591: If P_PA_DEBUG_MODE = 'Y' Then
10592: print_msg('Final Return Status['||x_return_status||']MsgCtinErrStack['||fnd_msg_pub.count_msg||']');

Line 15634: * avoid hitting dual wherever possible */

15630:
15631: --print_msg('Finally set the addl columns to NULL if ithas zeros');
15632: /* set addl columns to NULL if it has zero */
15633: /* Performance bug fix: 4208217
15634: * avoid hitting dual wherever possible */
15635:
15636: IF x_txn_plan_quantity_addl = 0 Then
15637: x_txn_plan_quantity_addl := NULL;
15638: End If;