APPS.PA_FP_CALC_PLAN_PKG dependencies on DUAL

Line 1220: FROM DUAL

1216: l_exists_flag Varchar2(10) := 'N';
1217: BEGIN
1218: SELECT 'Y'
1219: INTO l_exists_flag
1220: FROM DUAL
1221: WHERE EXISTS (select null
1222: from pa_fp_spread_calc_tmp1 tmp1
1223: where tmp1.budget_version_id = p_budget_version_id
1224: );

Line 1716: FROM DUAL

1712: x_return_status OUT NOCOPY varchar2 ) IS
1713:
1714: CURSOR cur_retSts IS
1715: SELECT 'E'
1716: FROM DUAL
1717: WHERE EXISTS (select null
1718: from pa_fp_rollup_tmp tmp
1719: where ( tmp.cost_rejection_code in ('PA_FP_PROJ_NO_TXNCONVRATE'
1720: ,'PA_FP_PRJFUNC_CURR_NULL'

Line 1937: FROM DUAL

1933: ,g_mrc_projfunc_rev_exg_rt_tab(i)
1934: ,g_mrc_projfunc_rev_dt_type_tab(i)
1935: ,g_mrc_projfunc_rev_rt_dt_tab(i)
1936: ,g_mrc_delete_flag_tab(i)
1937: FROM DUAL
1938: WHERE NOT EXISTS (SELECT NULL
1939: FROM PA_FP_ROLLUP_TMP RLTMP1
1940: WHERE rltmp1.budget_line_id = g_mrc_budget_line_id_tab(i)
1941: );

Line 2836: FROM dual

2832: l_act_exists Varchar2(10) := 'N';
2833:
2834: CURSOR cur_act_exists IS
2835: SELECT 'Y'
2836: FROM dual
2837: WHERE EXISTS (select null
2838: from pa_budget_lines bl
2839: Where bl.budget_version_id = p_budget_version_id
2840: AND (nvl(bl.init_quantity,0) <> 0

Line 3572: FROM DUAL

3568:
3569:
3570: CURSOR cur_sp_bl_chk IS
3571: SELECT 'Y'
3572: FROM DUAL
3573: WHERE EXISTS (select null
3574: from pa_budget_lines bl
3575: ,pa_resource_assignments ra
3576: where ra.resource_assignment_id = p_res_ass_id

Line 6953: FROM DUAL;

6949: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
6950: END IF;
6951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6952: SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS') INTO g_session_time
6953: FROM DUAL;
6954: print_msg('RETURN bvid => '||g_budget_version_id||' ,pid => '||g_project_id||' ,sesstime => '||g_session_time);
6955: RETURN;
6956: END;
6957: ELSE

Line 6997: FROM DUAL;

6993: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
6994: END IF;
6995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6996: SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS') INTO g_session_time
6997: FROM DUAL;
6998: print_msg('RETURN bvid => '||g_budget_version_id||' ,pid => '||g_project_id||' ,sesstime => '||g_session_time);
6999: RETURN;
7000: END;
7001: END IF;

Line 7524: from dual

7520: ,x_actual_flag OUT NOCOPY varchar2 ) IS
7521:
7522: cursor getActualBlLines IS
7523: select 'Y'
7524: from dual
7525: where EXISTS
7526: (select null
7527: from pa_budget_lines bl
7528: where bl.resource_assignment_id = p_res_ass_id

Line 10481: FROM dual;

10477: ,'E','E'
10478: ,'U','U'
10479: ,'S','S'),'E')
10480: INTO l_return_status
10481: FROM dual;
10482: x_return_status := l_return_status;
10483: l_entire_return_status := l_return_status;
10484: If P_PA_DEBUG_MODE = 'Y' Then
10485: print_msg('Final Return Status['||x_return_status||']MsgCtinErrStack['||fnd_msg_pub.count_msg||']');

Line 15422: * avoid hitting dual wherever possible */

15418:
15419: --print_msg('Finally set the addl columns to NULL if ithas zeros');
15420: /* set addl columns to NULL if it has zero */
15421: /* Performance bug fix: 4208217
15422: * avoid hitting dual wherever possible */
15423:
15424: IF x_txn_plan_quantity_addl = 0 Then
15425: x_txn_plan_quantity_addl := NULL;
15426: End If;