APPS.PA_PLAN_REVENUE dependencies on DUAL

Line 1527: FROM dual;

1523: SELECT p_revenue_override_rate b_rate,
1524: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((p_revenue_override_rate * p_quantity), p_override_currency_code) r_revenue,
1525: p_override_currency_code
1526: INTO l_txn_bill_rate,l_raw_revenue,l_txn_curr_code
1527: FROM dual;
1528: l_txn_raw_revenue:=l_raw_revenue;
1529:
1530: END IF;/* End of check for p_revenue_override_rate */
1531: /* If in the above case the Raw Revenue is null then go for calling

Line 2022: FROM dual;

2018: ,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)
2019: * p_quantity, l_class_org_rate_curr_code),null)
2020: ) r_cost,
2021: l_class_org_rate_curr_code rate_currency_code
2022: FROM dual;
2023:
2024:
2025: BEGIN
2026: -- Opening cursor and fetching row

Line 2363: FROM dual;

2359: )
2360: ) r_revenue,
2361: 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,
2362: 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
2363: FROM dual;
2364: BEGIN
2365: -- Opening cursor and fetching row
2366: OPEN C_std_res_class_sch_rev;
2367: -- Assigning the Calculated raw revenue/adjusted to the local variable

Line 2800: FROM dual;

2796: SELECT p_revenue_override_rate b_rate,
2797: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((p_revenue_override_rate * p_quantity), p_override_currency_code) r_revenue,
2798: p_override_currency_code
2799: INTO l_txn_bill_rate,l_raw_revenue,l_txn_curr_code
2800: FROM dual;
2801:
2802:
2803: l_txn_raw_revenue :=l_raw_revenue;
2804: