APPS.PA_FIN_PLAN_VIEW_GLOBAL dependencies on PA_FP_SUM_PV_V

Line 8368: from pa_fp_sum_pv_v

8364: begin
8365:
8366: select period1,period2,period3,period4,period5,period6
8367: into l_rev1_pl,l_rev2_pl,l_rev3_pl,l_rev4_pl,l_rev5_pl,l_rev6_pl
8368: from pa_fp_sum_pv_v
8369: where resource_assignment_id = l_ra_id_pl
8370: and AMOUNT_TYPE_CODE = 'REVENUE';
8371:
8372: /*

Line 8438: from pa_fp_sum_pv_v

8434:
8435:
8436: select period1,period2,period3,period4,period5,period6
8437: into l_cost1_pl,l_cost2_pl,l_cost3_pl,l_cost4_pl,l_cost5_pl,l_cost6_pl
8438: from pa_fp_sum_pv_v
8439: where resource_assignment_id = l_ra_id_pl
8440: and AMOUNT_TYPE_CODE = 'COST';
8441:
8442: /*

Line 8639: from pa_fp_sum_pv_v

8635: begin
8636:
8637: select period1,period2,period3,period4,period5,period6
8638: into l_rev1_tl,l_rev2_tl,l_rev3_tl,l_rev4_tl,l_rev5_tl,l_rev6_tl
8639: from pa_fp_sum_pv_v
8640: where resource_assignment_id = l_ra_id_pl
8641: and AMOUNT_TYPE_CODE = 'REVENUE';
8642:
8643: /*

Line 8711: from pa_fp_sum_pv_v

8707: begin
8708:
8709: select period1,period2,period3,period4,period5,period6
8710: into l_cost1_tl,l_cost2_tl,l_cost3_tl,l_cost4_tl,l_cost5_tl,l_cost6_tl
8711: from pa_fp_sum_pv_v
8712: where resource_assignment_id = l_ra_id_pl
8713: and AMOUNT_TYPE_CODE = 'COST';
8714:
8715: /*

Line 9652: from pa_fp_sum_pv_v

9648: select period1,period2,period3,period4,period5,period6,period7,
9649: period8,period9,period10,period11,period12,period13
9650: into l_rev1_pl,l_rev2_pl,l_rev3_pl,l_rev4_pl,l_rev5_pl,l_rev6_pl,
9651: l_rev7_pl,l_rev8_pl,l_rev9_pl,l_rev10_pl,l_rev11_pl,l_rev12_pl,l_rev13_pl
9652: from pa_fp_sum_pv_v
9653: where resource_assignment_id = l_ra_id_pl
9654: and AMOUNT_TYPE_CODE = 'REVENUE';
9655:
9656: /*

Line 9746: from pa_fp_sum_pv_v

9742: select period1,period2,period3,period4,period5,period6,period7,
9743: period8,period9,period10,period11,period12,period13
9744: into l_cost1_pl,l_cost2_pl,l_cost3_pl,l_cost4_pl,l_cost5_pl,l_cost6_pl,
9745: l_cost7_pl,l_cost8_pl,l_cost9_pl,l_cost10_pl,l_cost11_pl,l_cost12_pl,l_cost13_pl
9746: from pa_fp_sum_pv_v
9747: where resource_assignment_id = l_ra_id_pl
9748: and AMOUNT_TYPE_CODE = 'COST';
9749:
9750: /*

Line 10047: from pa_fp_sum_pv_v

10043: select period1,period2,period3,period4,period5,period6,period7,
10044: period8,period9,period10,period11,period12,period13
10045: into l_rev1_tl,l_rev2_tl,l_rev3_tl,l_rev4_tl,l_rev5_tl,l_rev6_tl,
10046: l_rev7_tl,l_rev8_tl,l_rev9_tl,l_rev10_tl,l_rev11_tl,l_rev12_tl,l_rev13_tl
10047: from pa_fp_sum_pv_v
10048: where resource_assignment_id = l_ra_id_pl
10049: and AMOUNT_TYPE_CODE = 'REVENUE';
10050:
10051: /*

Line 10144: from pa_fp_sum_pv_v

10140: select period1,period2,period3,period4,period5,period6,period7,
10141: period8,period9,period10,period11,period12,period13
10142: into l_cost1_tl,l_cost2_tl,l_cost3_tl,l_cost4_tl,l_cost5_tl,l_cost6_tl,
10143: l_cost7_tl,l_cost8_tl,l_cost9_tl,l_cost10_tl,l_cost11_tl,l_cost12_tl,l_cost13_tl
10144: from pa_fp_sum_pv_v
10145: where resource_assignment_id = l_ra_id_pl
10146: and AMOUNT_TYPE_CODE = 'COST';
10147:
10148: /*