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

Line 172: FROM dual

168: ,p_budget_version_id Number) RETURN varchar2 IS
169:
170: CURSOR cur_check IS
171: SELECT 'Y'
172: FROM dual
173: WHERE EXISTS ( select null
174: from pa_budget_lines bl
175: where bl.budget_version_id = p_budget_version_id
176: and bl.resource_assignment_id = p_resAsgnId

Line 3582: FROM dual

3578: ORDER BY tmp.resource_assignment_id,tmp.txn_currency_code;
3579:
3580: Cursor cur_bl_chk(p_ra_id Number,p_txn_cur_code Varchar2) IS
3581: SELECT 'Y'
3582: FROM dual
3583: WHERE EXISTS (select null
3584: from pa_budget_lines bl
3585: ,pa_resource_assignments ra
3586: where ra.resource_assignment_id = p_ra_id

Line 3595: FROM dual

3591: );
3592:
3593: Cursor cur_tmp_chk(p_ra_id Number,p_txn_cur_code Varchar2) IS
3594: SELECT 'Y'
3595: FROM dual
3596: WHERE EXISTS (select null
3597: from pa_fp_spread_calc_tmp bl
3598: where bl.resource_assignment_id = p_ra_id
3599: /* Bug fix:4083873 and bl.txn_currency_code = p_txn_cur_code */

Line 5235: FROM dual

5231: ,'SP'
5232: ,'SP'
5233: ,'SP'
5234: ,'SP'
5235: FROM dual
5236: WHERE NVL(l_quantity_tab(i),0) <> 0;
5237:
5238: If p_rollup_required_flag = 'Y' Then
5239: FOR i IN l_budget_line_id_tab.FIRST .. l_budget_line_id_tab.LAST LOOP

Line 5832: FROM dual

5828: ,decode(tmp.NEW_SP_FIX_DATE,NULL,'N'
5829: ,decode(tmp.OLD_SP_FIX_DATE,tmp.NEW_SP_FIX_DATE,'N','Y')))
5830: ,tmp.MFC_COST_CHANGE_FLAG = decode(NVL(tmp.OLD_MFC_COST_TYPE_ID,-999),NVL(tmp.NEW_MFC_COST_TYPE_ID,-999),'N','Y')
5831: ,tmp.SYSTEM_REFERENCE_VAR1 = (SELECT 'Y'
5832: FROM dual
5833: WHERE EXISTS ( select null
5834: from pa_budget_lines bl
5835: where bl.budget_version_id = tmp.budget_version_id
5836: and bl.resource_assignment_id = tmp.resource_assignment_id

Line 5895: from dual

5891: and g_source_context = 'RESOURCE_ASSIGNMENT' ) Then --{
5892: /* Bug #5031939: remove budget_version id joins in the sub query */
5893: UPDATE pa_fp_spread_calc_tmp tmp
5894: SET tmp.SP_CURVE_CHANGE_FLAG = (select 'Y'
5895: from dual
5896: where exists (select null
5897: from pa_fp_spread_calc_tmp tmp1
5898: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5899: and tmp1.sp_curve_change_flag = 'Y' ))

Line 5901: from dual

5897: from pa_fp_spread_calc_tmp tmp1
5898: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5899: and tmp1.sp_curve_change_flag = 'Y' ))
5900: ,tmp.PLAN_DATES_CHANGE_FLAG = (select 'Y'
5901: from dual
5902: where exists (select null
5903: from pa_fp_spread_calc_tmp tmp1
5904: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5905: and tmp1.plan_dates_change_flag = 'Y' ))

Line 5907: from dual

5903: from pa_fp_spread_calc_tmp tmp1
5904: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5905: and tmp1.plan_dates_change_flag = 'Y' ))
5906: ,tmp.SP_FIX_DATE_CHANGE_FLAG = (select 'Y'
5907: from dual
5908: where exists (select null
5909: from pa_fp_spread_calc_tmp tmp1
5910: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5911: and tmp1.sp_fix_date_change_flag = 'Y' ))

Line 5913: from dual

5909: from pa_fp_spread_calc_tmp tmp1
5910: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5911: and tmp1.sp_fix_date_change_flag = 'Y' ))
5912: ,tmp.MFC_COST_CHANGE_FLAG = (select 'Y'
5913: from dual
5914: where exists (select null
5915: from pa_fp_spread_calc_tmp tmp1
5916: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5917: and tmp1.mfc_cost_change_flag = 'Y' ))

Line 5919: from dual

5915: from pa_fp_spread_calc_tmp tmp1
5916: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5917: and tmp1.mfc_cost_change_flag = 'Y' ))
5918: ,tmp.PLAN_START_DATE_SHRUNK_FLAG = (select 'Y'
5919: from dual
5920: where exists (select null
5921: from pa_fp_spread_calc_tmp tmp1
5922: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5923: and tmp1.plan_start_date_shrunk_flag = 'Y'))

Line 5925: from dual

5921: from pa_fp_spread_calc_tmp tmp1
5922: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5923: and tmp1.plan_start_date_shrunk_flag = 'Y'))
5924: ,tmp.PLAN_END_DATE_SHRUNK_FLAG = (select 'Y'
5925: from dual
5926: where exists (select null
5927: from pa_fp_spread_calc_tmp tmp1
5928: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5929: and tmp1.plan_end_date_shrunk_flag = 'Y'))

Line 5931: from dual

5927: from pa_fp_spread_calc_tmp tmp1
5928: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5929: and tmp1.plan_end_date_shrunk_flag = 'Y'))
5930: ,tmp.RLM_ID_CHANGE_FLAG = (select 'Y'
5931: from dual
5932: where exists (select null
5933: from pa_fp_spread_calc_tmp tmp1
5934: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5935: and tmp1.rlm_id_change_flag = 'Y'))

Line 6135: FROM DUAL

6131:
6132:
6133: CURSOR cur_MultipleAdjustments_chk IS
6134: SELECT 'Y'
6135: FROM DUAL
6136: WHERE EXISTS (SELECT 'MultipleLAdjustments'
6137: FROM pa_fp_spread_calc_tmp tmp
6138: WHERE tmp.budget_version_id = p_budget_version_id
6139: AND ((decode(tmp.OLD_PLAN_START_DATE,NULL,'N'

Line 6222: FROM DUAL

6218: l_return_flg Varchar2(1) := 'N';
6219: BEGIN
6220: SELECT 'Y'
6221: INTO l_return_flg
6222: FROM DUAL
6223: WHERE EXISTS (Select null
6224: from pa_fp_spread_calc_tmp tmp
6225: where ( NVL(tmp.sp_curve_change_flag,'N') = 'Y'
6226: OR NVL(tmp.plan_dates_change_flag,'N') = 'Y'

Line 9063: FROM DUAL

9059: ,p_err_revenue_rejection_tab(i)
9060: ,p_err_burden_rejection_tab(i)
9061: ,p_err_pfc_cur_rejection_tab(i)
9062: ,p_err_pc_cur_rejection_tab(i)
9063: FROM DUAL
9064: WHERE p_err_error_code_tab(i) = 1 ;
9065: print_msg('Number of rows inserted ['||sql%rowcount||']');
9066: print_msg('Leaving populate spread calc tmp1 API with retSts['||x_return_status||']');
9067: