APPS.PA_CC_TRANSFER_PRICE dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 847: from pa_expenditure_items_all where expenditure_item_id=p_expenditure_item_id;

843:
844: cursor PROJ_VALUES (p_expenditure_item_id IN NUMBER) IS
845: select project_raw_cost,
846: project_currency_code
847: from pa_expenditure_items_all where expenditure_item_id=p_expenditure_item_id;
848: /* bug#3115422 end */
849:
850: unexpected_result exception;
851:

Line 3721: from pa_expenditure_items_all where expenditure_item_id=p_expenditure_item_id;

3717: bill_trans_raw_revenue,
3718: bill_trans_currency_code,
3719: /* Added for bug 2820252 */
3720: bill_trans_adjusted_revenue
3721: from pa_expenditure_items_all where expenditure_item_id=p_expenditure_item_id;
3722: /* End of Changes for bug 2668753 */
3723: l_nl_bill_rate NUMBER;
3724: l_nl_adjusted_bill_rate NUMBER;--4038485
3725: l_nl_markup_percentage NUMBER;

Line 4113: FROM pa_expenditure_items_all

4109: /* commented for the bug#2215942, starts here */
4110: /*
4111: SELECT cost_ind_compiled_set_id
4112: INTO l_compiled_set_id
4113: FROM pa_expenditure_items_all
4114: WHERE expenditure_item_id = p_expenditure_item_id(i);
4115: */
4116: /* commented for the bug#2215942, ends here */
4117: /* Changes ends for bug 1729820 */

Line 4173: from pa_expenditure_items_all

4169: into l_rate_schedule_id(i)
4170: from pa_tasks
4171: where task_id in
4172: ( select task_id
4173: from pa_expenditure_items_all
4174: where expenditure_item_id = p_expenditure_item_id(i)
4175: );
4176: /* Get the burden amount from the call to the procedure PA_COST_PLUS.Get_Burden_Amount,
4177: which gets the revision for the given burden schedule, then burden structure,