APPS.PA_PLAN_REVENUE dependencies on PA_BUDGET_VERSIONS

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

Line 3679: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT

3675: --13.02
3676: IF l_cost_rate IS NULL THEN
3677: begin
3678: SELECT default_raw_cost, DEF_RAW_COST_CURRENCY_CODE INTO l_cost_rate, l_txn_curr_code
3679: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT
3680: WHERE BV.BUDGET_VERSION_ID = p_budget_version_id
3681: AND OPT.PROJECT_ID = BV.PROJECT_ID
3682: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
3683: AND OPT.FIN_PLAN_VERSION_ID = p_budget_version_id

Line 3693: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT

3689: END;
3690: ELSE
3691: begin
3692: SELECT DEF_RAW_COST_CURRENCY_CODE INTO l_txn_curr_code
3693: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT
3694: WHERE BV.BUDGET_VERSION_ID = p_budget_version_id
3695: AND OPT.PROJECT_ID = BV.PROJECT_ID
3696: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
3697: AND OPT.FIN_PLAN_VERSION_ID = p_budget_version_id

Line 3864: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT

3860: then
3861: BEGIN
3862: SELECT DEFAULT_BILL_RATE, DEF_BILL_RATE_CURRENCY_CODE,DEF_MARKUP_PERCENTAGE
3863: INTO l_bill_rate, l_bill_txn_curr_code, l_markup
3864: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT
3865: WHERE BV.BUDGET_VERSION_ID = p_budget_version_id
3866: AND OPT.PROJECT_ID = BV.PROJECT_ID
3867: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
3868: AND OPT.FIN_PLAN_VERSION_ID = p_budget_version_id

Line 3880: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT

3876: ELSE
3877: BEGIN
3878: SELECT DEF_BILL_RATE_CURRENCY_CODE,DEF_MARKUP_PERCENTAGE
3879: INTO l_bill_txn_curr_code, l_markup
3880: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT
3881: WHERE BV.BUDGET_VERSION_ID = p_budget_version_id
3882: AND OPT.PROJECT_ID = BV.PROJECT_ID
3883: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
3884: AND OPT.FIN_PLAN_VERSION_ID = p_budget_version_id