DBA Data[Home] [Help]

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 3817: from pa_expenditure_items_all where expenditure_item_id=p_expenditure_item_id;

3813: bill_trans_raw_revenue,
3814: bill_trans_currency_code,
3815: /* Added for bug 2820252 */
3816: bill_trans_adjusted_revenue
3817: from pa_expenditure_items_all where expenditure_item_id=p_expenditure_item_id;
3818: /* End of Changes for bug 2668753 */
3819: l_nl_bill_rate NUMBER;
3820: l_nl_adjusted_bill_rate NUMBER;--4038485
3821: l_nl_markup_percentage NUMBER;

Line 4209: FROM pa_expenditure_items_all

4205: /* commented for the bug#2215942, starts here */
4206: /*
4207: SELECT cost_ind_compiled_set_id
4208: INTO l_compiled_set_id
4209: FROM pa_expenditure_items_all
4210: WHERE expenditure_item_id = p_expenditure_item_id(i);
4211: */
4212: /* commented for the bug#2215942, ends here */
4213: /* Changes ends for bug 1729820 */

Line 4269: from pa_expenditure_items_all

4265: into l_rate_schedule_id(i)
4266: from pa_tasks
4267: where task_id in
4268: ( select task_id
4269: from pa_expenditure_items_all
4270: where expenditure_item_id = p_expenditure_item_id(i)
4271: );
4272: /* Get the burden amount from the call to the procedure PA_COST_PLUS.Get_Burden_Amount,
4273: which gets the revision for the given burden schedule, then burden structure,