APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 128: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

124: l_request_id pa_budget_versions.request_id%TYPE;
125:
126: -- variables for default settings
127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
128: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
129: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevsep
130: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevtog
131: l_version_type pa_budget_versions.version_type%TYPE;
132: l_display_quantity VARCHAR2(1);

Line 129: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevsep

125:
126: -- variables for default settings
127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
128: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
129: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevsep
130: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevtog
131: l_version_type pa_budget_versions.version_type%TYPE;
132: l_display_quantity VARCHAR2(1);
133: l_display_rawcost VARCHAR2(1);

Line 130: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevtog

126: -- variables for default settings
127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
128: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
129: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevsep
130: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevtog
131: l_version_type pa_budget_versions.version_type%TYPE;
132: l_display_quantity VARCHAR2(1);
133: l_display_rawcost VARCHAR2(1);
134: l_display_burdcost VARCHAR2(1);

Line 304: from pa_fin_plan_amount_sets

300: l_display_burdcost,
301: l_display_revenue,
302: l_display_margin,
303: l_display_marginpct
304: from pa_fin_plan_amount_sets
305: where fin_plan_amount_set_id = l_cost_amount_set_id;
306:
307: elsif l_plan_pref_code = 'REVENUE_ONLY' then
308: select nvl(revenue_qty_flag, 'N'),

Line 320: from pa_fin_plan_amount_sets

316: l_display_burdcost,
317: l_display_revenue,
318: l_display_margin,
319: l_display_marginpct
320: from pa_fin_plan_amount_sets
321: where fin_plan_amount_set_id = l_rev_amount_set_id;
322:
323: elsif l_plan_pref_code = 'COST_AND_REV_SAME' then
324: select nvl(all_qty_flag, 'N'),

Line 336: from pa_fin_plan_amount_sets

332: l_display_burdcost,
333: l_display_revenue,
334: l_display_margin,
335: l_display_marginpct
336: from pa_fin_plan_amount_sets
337: where fin_plan_amount_set_id = l_all_amount_set_id;
338:
339: else
340: select DECODE(cost_as.cost_qty_flag,

Line 356: from pa_fin_plan_amount_sets cost_as,

352: l_display_burdcost,
353: l_display_revenue,
354: l_display_margin,
355: l_display_marginpct
356: from pa_fin_plan_amount_sets cost_as,
357: pa_fin_plan_amount_sets rev_as
358: where cost_as.fin_plan_amount_set_id = l_cost_amount_set_id and
359: rev_as.fin_plan_amount_set_id = l_rev_amount_set_id;
360: end if;

Line 357: pa_fin_plan_amount_sets rev_as

353: l_display_revenue,
354: l_display_margin,
355: l_display_marginpct
356: from pa_fin_plan_amount_sets cost_as,
357: pa_fin_plan_amount_sets rev_as
358: where cost_as.fin_plan_amount_set_id = l_cost_amount_set_id and
359: rev_as.fin_plan_amount_set_id = l_rev_amount_set_id;
360: end if;
361:

Line 1127: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1123: l_cur_start_period VARCHAR2(30);
1124: l_cur_end_period VARCHAR2(30);
1125:
1126: -- variables for default settings
1127: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1128: l_version_type pa_budget_versions.version_type%TYPE;
1129: l_display_quantity VARCHAR2(1);
1130: l_display_rawcost VARCHAR2(1);
1131: l_display_burdcost VARCHAR2(1);

Line 1741: from pa_fin_plan_amount_sets

1737: l_display_burdcost,
1738: l_display_revenue,
1739: l_display_margin,
1740: l_display_marginpct
1741: from pa_fin_plan_amount_sets
1742: where fin_plan_amount_set_id = l_amount_set_id;
1743: pa_fp_view_plans_pub.G_DISPLAY_FLAG_QUANTITY := l_display_quantity;
1744: pa_fp_view_plans_pub.G_DISPLAY_FLAG_RAWCOST := l_display_rawcost;
1745: pa_fp_view_plans_pub.G_DISPLAY_FLAG_BURDCOST := l_display_burdcost;