APPS.PJI_LAUNCH_UPP_MAIN dependencies on PA_FIN_PLAN_TYPES_B

Line 1751: FROM pa_fin_plan_types_b

1747: and ver.project_id = ppa.project_id
1748: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1749: AND ver.current_flag = 'Y'
1750: AND ver.fin_plan_type_id IN (SELECT fin_plan_type_id
1751: FROM pa_fin_plan_types_b
1752: WHERE approved_cost_plan_type_flag ='Y')
1753: group by ver.project_id) budgets
1754: LEFT OUTER JOIN
1755: (SELECT f.project_id, p.project_status_code,

Line 1767: FROM pa_fin_plan_types_b

1763: AND calendar_type = 'A'
1764: AND time_id = -1
1765: AND project_element_id = apps.pa_project_structure_utils.Get_fin_structure_id(f.project_id)
1766: AND plan_type_id IN (SELECT fin_plan_type_id
1767: FROM pa_fin_plan_types_b
1768: WHERE approved_cost_plan_type_flag = 'Y')
1769: AND f.currency_code = p.projfunc_currency_code
1770: AND f.project_id = p.project_id
1771: GROUP BY f.project_id, p.project_status_code) reporting

Line 1796: FROM pa_fin_plan_types_b

1792: and ver.project_id = ppa.project_id
1793: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1794: AND ver.current_flag = 'Y'
1795: AND ver.fin_plan_type_id IN (SELECT fin_plan_type_id
1796: FROM pa_fin_plan_types_b
1797: WHERE approved_rev_plan_type_flag ='Y')
1798: group by ver.project_id) budgets
1799: LEFT OUTER JOIN
1800: (SELECT f.project_id, p.project_status_code,

Line 1812: FROM pa_fin_plan_types_b

1808: AND calendar_type = 'A'
1809: AND time_id = -1
1810: AND project_element_id = apps.pa_project_structure_utils.Get_fin_structure_id(f.project_id)
1811: AND plan_type_id IN (SELECT fin_plan_type_id
1812: FROM pa_fin_plan_types_b
1813: WHERE approved_rev_plan_type_flag = 'Y')
1814: AND f.currency_code = p.projfunc_currency_code
1815: AND f.project_id = p.project_id
1816: group by f.project_id, p.project_status_code) reporting

Line 1934: FROM pa_fin_plan_types_b

1930: Sum(Nvl(act_raw_cost,0)) act_raw_cost,
1931: Sum(Nvl(act_brdn_cost,0)) act_brdn_cost
1932: FROM pji_fp_xbs_accum_f f
1933: WHERE plan_type_id IN (SELECT fin_plan_type_id
1934: FROM pa_fin_plan_types_b
1935: WHERE primary_cost_forecast_flag = 'Y')
1936: AND plan_version_id = -3
1937: AND rbs_version_id = -1 AND time_id = -1
1938: AND rbs_aggr_level = 'T' AND wbs_rollup_flag = 'Y' AND prg_rollup_flag = 'N'

Line 1954: FROM pa_fin_plan_types_b

1950: WHERE bv.project_id = res.project_id
1951: AND budget_status_code = 'B'
1952: AND current_flag = 'Y'
1953: AND fin_plan_type_id IN (SELECT fin_plan_type_id
1954: FROM pa_fin_plan_types_b
1955: WHERE primary_cost_forecast_flag = 'Y'))
1956: AND bl.budget_version_id = res.budget_version_id
1957: AND bl.resource_assignment_id = res.resource_assignment_id
1958: GROUP BY res.project_id) base