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 301: from pa_fin_plan_amount_sets

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

Line 317: from pa_fin_plan_amount_sets

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

Line 333: from pa_fin_plan_amount_sets

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

Line 353: from pa_fin_plan_amount_sets cost_as,

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

Line 354: pa_fin_plan_amount_sets rev_as

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

Line 1031: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1027: l_cur_start_period VARCHAR2(30);
1028: l_cur_end_period VARCHAR2(30);
1029:
1030: -- variables for default settings
1031: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1032: l_version_type pa_budget_versions.version_type%TYPE;
1033: l_display_quantity VARCHAR2(1);
1034: l_display_rawcost VARCHAR2(1);
1035: l_display_burdcost VARCHAR2(1);

Line 1645: from pa_fin_plan_amount_sets

1641: l_display_burdcost,
1642: l_display_revenue,
1643: l_display_margin,
1644: l_display_marginpct
1645: from pa_fin_plan_amount_sets
1646: where fin_plan_amount_set_id = l_amount_set_id;
1647: pa_fp_view_plans_pub.G_DISPLAY_FLAG_QUANTITY := l_display_quantity;
1648: pa_fp_view_plans_pub.G_DISPLAY_FLAG_RAWCOST := l_display_rawcost;
1649: pa_fp_view_plans_pub.G_DISPLAY_FLAG_BURDCOST := l_display_burdcost;