APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_BUDGET_LINES

Line 823: from pa_budget_lines bl

819:
820: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
821: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
822: into l_return_value
823: from pa_budget_lines bl
824: where bl.resource_assignment_id = p_resource_assignment_id
825: and bl.budget_version_id = p_budget_version_id
826: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date1();
827:

Line 833: from pa_budget_lines bl

829:
830: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
831: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
832: into l_return_value
833: from pa_budget_lines bl
834: where bl.resource_assignment_id = p_resource_assignment_id
835: and bl.budget_version_id = p_budget_version_id
836: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date2();
837:

Line 843: from pa_budget_lines bl

839:
840: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
841: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
842: into l_return_value
843: from pa_budget_lines bl
844: where bl.resource_assignment_id = p_resource_assignment_id
845: and bl.budget_version_id = p_budget_version_id
846: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date3();
847:

Line 853: from pa_budget_lines bl

849:
850: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
851: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
852: into l_return_value
853: from pa_budget_lines bl
854: where bl.resource_assignment_id = p_resource_assignment_id
855: and bl.budget_version_id = p_budget_version_id
856: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date4();
857:

Line 863: from pa_budget_lines bl

859:
860: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
861: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
862: into l_return_value
863: from pa_budget_lines bl
864: where bl.resource_assignment_id = p_resource_assignment_id
865: and bl.budget_version_id = p_budget_version_id
866: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date5();
867:

Line 873: from pa_budget_lines bl

869:
870: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
871: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
872: into l_return_value
873: from pa_budget_lines bl
874: where bl.resource_assignment_id = p_resource_assignment_id
875: and bl.budget_version_id = p_budget_version_id
876: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date6();
877:

Line 883: from pa_budget_lines bl

879:
880: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
881: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
882: into l_return_value
883: from pa_budget_lines bl
884: where bl.resource_assignment_id = p_resource_assignment_id
885: and bl.budget_version_id = p_budget_version_id
886: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date7();
887:

Line 893: from pa_budget_lines bl

889:
890: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
891: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
892: into l_return_value
893: from pa_budget_lines bl
894: where bl.resource_assignment_id = p_resource_assignment_id
895: and bl.budget_version_id = p_budget_version_id
896: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date8();
897:

Line 903: from pa_budget_lines bl

899:
900: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
901: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
902: into l_return_value
903: from pa_budget_lines bl
904: where bl.resource_assignment_id = p_resource_assignment_id
905: and bl.budget_version_id = p_budget_version_id
906: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date9();
907:

Line 913: from pa_budget_lines bl

909:
910: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
911: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
912: into l_return_value
913: from pa_budget_lines bl
914: where bl.resource_assignment_id = p_resource_assignment_id
915: and bl.budget_version_id = p_budget_version_id
916: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date10();
917:

Line 923: from pa_budget_lines bl

919:
920: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
921: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
922: into l_return_value
923: from pa_budget_lines bl
924: where bl.resource_assignment_id = p_resource_assignment_id
925: and bl.budget_version_id = p_budget_version_id
926: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date11();
927:

Line 933: from pa_budget_lines bl

929:
930: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
931: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
932: into l_return_value
933: from pa_budget_lines bl
934: where bl.resource_assignment_id = p_resource_assignment_id
935: and bl.budget_version_id = p_budget_version_id
936: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date12();
937:

Line 943: from pa_budget_lines bl

939:
940: select sum(decode(p_amount_type_id, 215, bl.quantity, 160, decode(p_project_currency_type, 'PROJECT', bl.project_raw_cost, bl.raw_cost),
941: 165, decode(p_project_currency_type, 'PROJECT', bl.project_burdened_cost, bl.burdened_cost), 100, bl.revenue, null))
942: into l_return_value
943: from pa_budget_lines bl
944: where bl.resource_assignment_id = p_resource_assignment_id
945: and bl.budget_version_id = p_budget_version_id
946: and trunc(bl.start_date) = pa_fp_view_plans_pub.Get_Period_Start_Date13();
947: end if;

Line 4964: from pa_budget_lines

4960: select SUM(nvl(quantity,0)),
4961: SUM(nvl(revenue,0))
4962: into l_line_quantity_total,
4963: l_line_costrev_total
4964: from pa_budget_lines
4965: where resource_assignment_id = l_ra_rec.resource_assignment_id
4966: group by resource_assignment_id;
4967: update pa_resource_assignments
4968: set total_plan_revenue = l_line_costrev_total,

Line 4982: from pa_budget_lines

4978: select SUM(nvl(quantity,0)),
4979: SUM(nvl(burdened_cost,0))
4980: into l_line_quantity_total,
4981: l_line_costrev_total
4982: from pa_budget_lines
4983: where resource_assignment_id = l_ra_rec.resource_assignment_id
4984: group by resource_assignment_id;
4985: update pa_resource_assignments
4986: set total_plan_burdened_cost = l_line_costrev_total,