APPS.PA_PLAN_REVENUE dependencies on DUAL

Line 1614: FROM dual;

1610: SELECT p_revenue_override_rate b_rate,
1611: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((p_revenue_override_rate * p_quantity), p_override_currency_code) r_revenue,
1612: p_override_currency_code
1613: INTO l_txn_bill_rate,l_raw_revenue,l_txn_curr_code
1614: FROM dual;
1615: l_txn_raw_revenue:=l_raw_revenue;
1616:
1617: END IF;/* End of check for p_revenue_override_rate */
1618: /* If in the above case the Raw Revenue is null then go for calling

Line 2109: FROM dual;

2105: ,DECODE(p_uom,l_class_org_uom,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(l_class_org_rate * NVL(p_cost_rate_multiplier,1)
2106: * p_quantity, l_class_org_rate_curr_code),null)
2107: ) r_cost,
2108: l_class_org_rate_curr_code rate_currency_code
2109: FROM dual;
2110:
2111:
2112: BEGIN
2113: -- Opening cursor and fetching row

Line 2453: FROM dual;

2449: )
2450: ) r_revenue,
2451: DECODE(p_uom,'DOLLARS',l_inter_txn_curr_code,DECODE(p_uom,l_class_org_uom,decode(l_class_org_rate,null,l_inter_txn_curr_code,l_class_org_rate_curr_code),l_inter_txn_curr_code) ) rate_currency_code,
2452: DECODE (p_uom,'DOLLARS',l_class_org_markup,DECODE(p_uom,l_class_org_uom,decode(l_class_org_rate,null,l_class_org_markup,NULL),l_class_org_markup)) markup
2453: FROM dual;
2454: BEGIN
2455: -- Opening cursor and fetching row
2456: OPEN C_std_res_class_sch_rev;
2457: -- Assigning the Calculated raw revenue/adjusted to the local variable

Line 2908: FROM dual;

2904: SELECT p_revenue_override_rate b_rate,
2905: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((p_revenue_override_rate * p_quantity), p_override_currency_code) r_revenue,
2906: p_override_currency_code
2907: INTO l_txn_bill_rate,l_raw_revenue,l_txn_curr_code
2908: FROM dual;
2909:
2910:
2911: l_txn_raw_revenue :=l_raw_revenue;
2912: