APPS.PA_PLAN_REVENUE dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 333: l_resource_class_flag pa_resource_lists_all_bg.RESOURCE_CLASS_FLAG%TYPE := 'Y'; --CBS

329: l_cost_res_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
330: l_expenditure_org_id NUMBER;
331: l_calculate_mode VARCHAR2(30);
332:
333: l_resource_class_flag pa_resource_lists_all_bg.RESOURCE_CLASS_FLAG%TYPE := 'Y'; --CBS
334: BEGIN
335:
336: -- Initializing return status with success so that if some unexpected error comes
337: -- , we change its status from succes to error so that we can take necessary step to rectify the problem

Line 766: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, pa_resource_lists_all_bg res

762: IF p_budget_version_id IS NOT null
763: then
764: BEGIN
765: SELECT NVL(res.RESOURCE_CLASS_FLAG,'Y') INTO l_resource_class_flag
766: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, pa_resource_lists_all_bg res
767: WHERE BV.BUDGET_VERSION_ID = p_budget_version_id
768: AND OPT.PROJECT_ID = BV.PROJECT_ID
769: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
770: AND OPT.FIN_PLAN_VERSION_ID = p_budget_version_id