APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on DUAL

Line 7345: FROM DUAL;

7341: SELECT pa_resource_asgn_curr_s.nextval
7342: ,l_resource_assignment_id_tbl(i)
7343: ,l_currency_code_tbl(i)
7344: ,NULL
7345: FROM DUAL;
7346: END IF;
7347:
7348: pa_res_asg_currency_pub.maintain_data(
7349: p_fp_cols_rec => l_fp_cols_rec,

Line 7977: FROM DUAL

7973: l_inv_item_id IS NOT NULL THEN
7974: BEGIN
7975: SELECT 'Y'
7976: INTO l_res_rate_based_flag_tbl(i)
7977: FROM DUAL
7978: WHERE NOT EXISTS (select 'Y'
7979: from mtl_system_items_b item,
7980: mtl_units_of_measure meas
7981: where item.inventory_item_id = l_inv_item_id

Line 9041: FROM DUAL;

9037: SELECT pa_resource_asgn_curr_s.nextval
9038: ,l_resource_assignment_id_tbl(i)
9039: ,l_txn_currency_code_tbl(i)
9040: ,'Y'
9041: FROM DUAL;
9042: END IF;
9043:
9044: --Bug 4951422. Validate_Delete_Assignment returns the correct resource assignments that should be deleted.
9045: --Note:

Line 9080: FROM DUAL;

9076: SELECT pa_resource_asgn_curr_s.nextval
9077: ,l_ra_id_in_pra_tbl(i)
9078: -- ,l_txn_currency_code_tbl(i)
9079: ,'Y'
9080: FROM DUAL;
9081: END IF;
9082: End if; --}
9083:
9084: ELSIF p_task_or_res = 'ASSIGNMENT' THEN

Line 9187: FROM DUAL;

9183: SELECT pa_resource_asgn_curr_s.nextval
9184: ,l_resource_assignment_id_tbl(i)
9185: -- ,l_txn_currency_code_tbl(i)
9186: ,'Y'
9187: FROM DUAL;
9188: END IF;
9189:
9190: IF nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' THEN
9191:

Line 9225: FROM DUAL;

9221: SELECT pa_resource_asgn_curr_s.nextval
9222: ,l_ra_id_in_pra_tbl(i)
9223: -- ,l_project_currency_code
9224: ,'Y'
9225: FROM DUAL;
9226: END IF;
9227: END IF; -- IF nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' THEN
9228:
9229: END IF;

Line 9347: FROM DUAL;

9343: SELECT pa_resource_asgn_curr_s.nextval
9344: ,l_resource_assignment_id_tbl(i)
9345: -- ,l_txn_currency_code_tbl(i)
9346: ,'Y'
9347: FROM DUAL;
9348: END IF;
9349: End If; --}
9350:
9351: IF l_debug_mode = 'Y' THEN

Line 9396: FROM DUAL;

9392: SELECT pa_resource_asgn_curr_s.nextval
9393: ,l_ra_id_in_pra_tbl(i)
9394: -- ,l_project_currency_code
9395: ,'Y'
9396: FROM DUAL;
9397: END IF;
9398: End If; --}
9399:
9400:

Line 9449: FROM DUAL

9445:
9446: BEGIN
9447: SELECT 'Y'
9448: INTO l_exists
9449: FROM DUAL
9450: WHERE EXISTS (SELECT 'X'
9451: FROM pa_budget_lines pbl,
9452: pa_resource_assignments pra
9453: WHERE pra.resource_assignment_id=p_resource_assignment_tbl(i)

Line 9564: FROM DUAL;

9560: SELECT pa_resource_asgn_curr_s.nextval
9561: ,l_resource_assignment_id_tbl(i)
9562: ,l_txn_currency_code_tbl(i) -- Bug 5057010
9563: ,'Y'
9564: FROM DUAL;
9565: END IF;
9566:
9567: IF nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' THEN
9568:

Line 9611: FROM DUAL;

9607: SELECT pa_resource_asgn_curr_s.nextval
9608: ,l_ra_id_in_pra_tbl(i)
9609: -- ,l_project_currency_code
9610: ,'Y'
9611: FROM DUAL;
9612: END IF;
9613:
9614: END IF;-- IF nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' THEN
9615:

Line 10102: FROM DUAL

10098: BEGIN -- BLOCK to check if workplan_type is already attched for the passed project_id - Starts
10099:
10100: SELECT 1
10101: INTO l_proj_wp_type_exists
10102: FROM DUAL
10103: WHERE EXISTS(
10104: SELECT 1
10105: FROM pa_proj_fp_options
10106: WHERE fin_plan_type_id = l_wp_type_id

Line 10925: FROM DUAL;

10921: )
10922: SELECT pa_resource_asgn_curr_s.NEXTVAL
10923: ,l_delete_ra_id_tbl(i)
10924: ,'Y'
10925: FROM DUAL;
10926: END IF;
10927: -- END of IPM changes Bug 5003827 Issue 22
10928: */
10929: ----IPM Arch Enhancement Bug 5754758/4865563

Line 11048: FROM DUAL;

11044: )
11045: SELECT pa_resource_asgn_curr_s.NEXTVAL
11046: ,l_delete_ra_id_tbl(i)
11047: ,'Y'
11048: FROM DUAL;
11049: END IF;
11050: -- END of IPM changes Bug 5003827 Issue 22
11051:
11052: