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 165: FROM dual

161: ,p_budget_version_id Number) RETURN varchar2 IS
162:
163: CURSOR cur_check IS
164: SELECT 'Y'
165: FROM dual
166: WHERE EXISTS ( select null
167: from pa_budget_lines bl
168: where bl.budget_version_id = p_budget_version_id
169: and bl.resource_assignment_id = p_resAsgnId

Line 3554: FROM dual

3550: ORDER BY tmp.resource_assignment_id,tmp.txn_currency_code;
3551:
3552: Cursor cur_bl_chk(p_ra_id Number,p_txn_cur_code Varchar2) IS
3553: SELECT 'Y'
3554: FROM dual
3555: WHERE EXISTS (select null
3556: from pa_budget_lines bl
3557: ,pa_resource_assignments ra
3558: where ra.resource_assignment_id = p_ra_id

Line 3567: FROM dual

3563: );
3564:
3565: Cursor cur_tmp_chk(p_ra_id Number,p_txn_cur_code Varchar2) IS
3566: SELECT 'Y'
3567: FROM dual
3568: WHERE EXISTS (select null
3569: from pa_fp_spread_calc_tmp bl
3570: where bl.resource_assignment_id = p_ra_id
3571: /* Bug fix:4083873 and bl.txn_currency_code = p_txn_cur_code */

Line 5206: FROM dual

5202: ,'SP'
5203: ,'SP'
5204: ,'SP'
5205: ,'SP'
5206: FROM dual
5207: WHERE NVL(l_quantity_tab(i),0) <> 0;
5208:
5209: If p_rollup_required_flag = 'Y' Then
5210: FOR i IN l_budget_line_id_tab.FIRST .. l_budget_line_id_tab.LAST LOOP

Line 5803: FROM dual

5799: ,decode(tmp.NEW_SP_FIX_DATE,NULL,'N'
5800: ,decode(tmp.OLD_SP_FIX_DATE,tmp.NEW_SP_FIX_DATE,'N','Y')))
5801: ,tmp.MFC_COST_CHANGE_FLAG = decode(NVL(tmp.OLD_MFC_COST_TYPE_ID,-999),NVL(tmp.NEW_MFC_COST_TYPE_ID,-999),'N','Y')
5802: ,tmp.SYSTEM_REFERENCE_VAR1 = (SELECT 'Y'
5803: FROM dual
5804: WHERE EXISTS ( select null
5805: from pa_budget_lines bl
5806: where bl.budget_version_id = tmp.budget_version_id
5807: and bl.resource_assignment_id = tmp.resource_assignment_id

Line 5866: from dual

5862: and g_source_context = 'RESOURCE_ASSIGNMENT' ) Then --{
5863: /* Bug #5031939: remove budget_version id joins in the sub query */
5864: UPDATE pa_fp_spread_calc_tmp tmp
5865: SET tmp.SP_CURVE_CHANGE_FLAG = (select 'Y'
5866: from dual
5867: where exists (select null
5868: from pa_fp_spread_calc_tmp tmp1
5869: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5870: and tmp1.sp_curve_change_flag = 'Y' ))

Line 5872: from dual

5868: from pa_fp_spread_calc_tmp tmp1
5869: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5870: and tmp1.sp_curve_change_flag = 'Y' ))
5871: ,tmp.PLAN_DATES_CHANGE_FLAG = (select 'Y'
5872: from dual
5873: where exists (select null
5874: from pa_fp_spread_calc_tmp tmp1
5875: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5876: and tmp1.plan_dates_change_flag = 'Y' ))

Line 5878: from dual

5874: from pa_fp_spread_calc_tmp tmp1
5875: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5876: and tmp1.plan_dates_change_flag = 'Y' ))
5877: ,tmp.SP_FIX_DATE_CHANGE_FLAG = (select 'Y'
5878: from dual
5879: where exists (select null
5880: from pa_fp_spread_calc_tmp tmp1
5881: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5882: and tmp1.sp_fix_date_change_flag = 'Y' ))

Line 5884: from dual

5880: from pa_fp_spread_calc_tmp tmp1
5881: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5882: and tmp1.sp_fix_date_change_flag = 'Y' ))
5883: ,tmp.MFC_COST_CHANGE_FLAG = (select 'Y'
5884: from dual
5885: where exists (select null
5886: from pa_fp_spread_calc_tmp tmp1
5887: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5888: and tmp1.mfc_cost_change_flag = 'Y' ))

Line 5890: from dual

5886: from pa_fp_spread_calc_tmp tmp1
5887: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5888: and tmp1.mfc_cost_change_flag = 'Y' ))
5889: ,tmp.PLAN_START_DATE_SHRUNK_FLAG = (select 'Y'
5890: from dual
5891: where exists (select null
5892: from pa_fp_spread_calc_tmp tmp1
5893: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5894: and tmp1.plan_start_date_shrunk_flag = 'Y'))

Line 5896: from dual

5892: from pa_fp_spread_calc_tmp tmp1
5893: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5894: and tmp1.plan_start_date_shrunk_flag = 'Y'))
5895: ,tmp.PLAN_END_DATE_SHRUNK_FLAG = (select 'Y'
5896: from dual
5897: where exists (select null
5898: from pa_fp_spread_calc_tmp tmp1
5899: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5900: and tmp1.plan_end_date_shrunk_flag = 'Y'))

Line 5902: from dual

5898: from pa_fp_spread_calc_tmp tmp1
5899: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5900: and tmp1.plan_end_date_shrunk_flag = 'Y'))
5901: ,tmp.RLM_ID_CHANGE_FLAG = (select 'Y'
5902: from dual
5903: where exists (select null
5904: from pa_fp_spread_calc_tmp tmp1
5905: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5906: and tmp1.rlm_id_change_flag = 'Y'))

Line 6106: FROM DUAL

6102:
6103:
6104: CURSOR cur_MultipleAdjustments_chk IS
6105: SELECT 'Y'
6106: FROM DUAL
6107: WHERE EXISTS (SELECT 'MultipleLAdjustments'
6108: FROM pa_fp_spread_calc_tmp tmp
6109: WHERE tmp.budget_version_id = p_budget_version_id
6110: AND ((decode(tmp.OLD_PLAN_START_DATE,NULL,'N'

Line 6193: FROM DUAL

6189: l_return_flg Varchar2(1) := 'N';
6190: BEGIN
6191: SELECT 'Y'
6192: INTO l_return_flg
6193: FROM DUAL
6194: WHERE EXISTS (Select null
6195: from pa_fp_spread_calc_tmp tmp
6196: where ( NVL(tmp.sp_curve_change_flag,'N') = 'Y'
6197: OR NVL(tmp.plan_dates_change_flag,'N') = 'Y'

Line 8831: FROM DUAL

8827: ,p_err_revenue_rejection_tab(i)
8828: ,p_err_burden_rejection_tab(i)
8829: ,p_err_pfc_cur_rejection_tab(i)
8830: ,p_err_pc_cur_rejection_tab(i)
8831: FROM DUAL
8832: WHERE p_err_error_code_tab(i) = 1 ;
8833: print_msg('Number of rows inserted ['||sql%rowcount||']');
8834: print_msg('Leaving populate spread calc tmp1 API with retSts['||x_return_status||']');
8835: