APPS.PA_FP_UPGRADE_PKG dependencies on PA_BUDGET_TYPES

Line 100: ,pa_budget_types bt

96: ,c_budget_types IN VARCHAR2 ) IS
97: SELECT pt.fin_plan_type_id fin_plan_type_id
98: ,bt.budget_Type_code budget_Type_code
99: FROM pa_fin_plan_types_b pt /* Bug# 2661650 - Replaced _vl by _b for performance reasons */
100: ,pa_budget_types bt
101: WHERE DECODE(c_budget_types,'ALL','Y', bt.upgrade_budget_type_flag) = 'Y'
102: AND bt.budget_type_code = pt.migrated_frm_bdgt_typ_code
103: AND NVL(bt.plan_type,'BUDGET') = 'BUDGET'
104: AND not exists

Line 134: pa_budget_types bt

130: , bt.budget_type_code
131: , bv.resource_list_id /* bug 3673111, 07-JUN-4, jwhite: New Column */
132: , bv.budget_status_code -- Bug# 7187487
133: FROM pa_budget_versions bv,
134: pa_budget_types bt
135: WHERE bv.project_id = c_project_id
136: AND bt.budget_type_code = bv.budget_type_code
137: AND bv.budget_type_code IS NOT NULL
138: AND DECODE(c_budget_types,'ALL','Y',bt.upgrade_budget_type_flag) = 'Y'

Line 506: FROM pa_budget_types

502:
503: SELECT DECODE(budget_amount_code,PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_C,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY
504: ,PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_R,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY)
505: INTO x_upgrade_elements_rec.curr_option_preference_code
506: FROM pa_budget_types
507: WHERE budget_type_code = p_budget_type_code;
508:
509: EXCEPTION
510: WHEN OTHERS THEN

Line 646: FROM pa_budget_types

642:
643: SELECT DECODE(budget_amount_code,PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_C,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY
644: ,PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_R,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY)
645: INTO x_upgrade_elements_rec.curr_option_preference_code
646: FROM pa_budget_types
647: WHERE budget_type_code = p_budget_type_code;
648:
649: EXCEPTION
650: WHEN OTHERS THEN

Line 1377: FROM pa_budget_types bt

1373: ,attribute12
1374: ,attribute13
1375: ,attribute14
1376: ,attribute15
1377: FROM pa_budget_types bt
1378: WHERE DECODE(c_budget_types, 'ALL' ,'Y', upgrade_budget_type_flag) = 'Y'
1379: AND not exists
1380: (SELECT 1
1381: FROM pa_fin_plan_types_b pt /* Bug# 2661650 - Replaced _vl by _b for performance reasons */

Line 2924: FROM pa_budget_types bt

2920: CURSOR attached_budget_types_cur(
2921: c_project_id IN pa_projects.project_id%TYPE
2922: ,c_budget_types IN VARCHAR2 ) IS
2923: SELECT bt.budget_type_code budget_type_code
2924: FROM pa_budget_types bt
2925: WHERE DECODE(c_budget_types,'ALL','Y', bt.upgrade_budget_type_flag) = 'Y'
2926: AND NVL(bt.plan_type,'BUDGET') = 'BUDGET'
2927: AND NOT EXISTS
2928: (SELECT 1