DBA Data[Home] [Help]

APPS.PA_REP_UTIL_SCREEN dependencies on PA_SUMM_BALANCES

Line 635: PA_Summ_Balances summbal

631: , 10
632: , p_Show_Percentage_By)
633: ) AS FORECAST_CAP_OR_TOT_HRS
634: from
635: PA_Summ_Balances summbal
636: , PA_Objects paobj
637: , pa_resources_denorm resdnorm
638: , pa_lookups lkup
639: where

Line 1323: PA_Summ_Balances summbal

1319: , 10
1320: , p_Show_Percentage_By)
1321: ) AS FORECAST_CAP_OR_TOT_HRS
1322: from
1323: PA_Summ_Balances summbal
1324: , PA_Objects paobj
1325: , pa_resources_denorm resdnorm
1326: , gl_periods glprd
1327: , pa_lookups lkup

Line 2015: PA_Summ_Balances summbal

2011: , 10
2012: , p_Show_Percentage_By)
2013: ) AS FORECAST_CAP_OR_TOT_HRS
2014: from
2015: PA_Summ_Balances summbal
2016: , PA_Objects paobj
2017: , pa_resources_denorm resdnorm
2018: , gl_periods glprd
2019: , pa_lookups lkup

Line 2706: PA_Summ_Balances summbal

2702: , 10
2703: , p_Show_Percentage_By)
2704: ) AS FORECAST_CAP_OR_TOT_HRS
2705: from
2706: PA_Summ_Balances summbal
2707: , PA_Objects paobj
2708: , pa_resources_denorm resdnorm
2709: , gl_periods glprd
2710: , pa_lookups lkup

Line 2867: PA_Summ_Balances summbal2

2863: select
2864: summbal2.amount_type_id AS amount_type_id
2865: , sum(summbal2.period_balance) AS period_balance
2866: from
2867: PA_Summ_Balances summbal2
2868: , PA_Objects paobj2
2869: where
2870: paobj2.Balance_Type_Code = p_Balance_Type_Code
2871: AND paobj2.expenditure_org_id = p_ORG_ID

Line 2896: PA_Summ_Balances summbal2

2892: select
2893: summbal2.amount_type_id AS amount_type_id
2894: , sum(summbal2.period_balance) AS period_balance
2895: from
2896: PA_Summ_Balances summbal2
2897: , PA_Objects paobj2
2898: where
2899: paobj2.Balance_Type_Code = p_Balance_Type_Code
2900: AND paobj2.expenditure_org_id = p_ORG_ID

Line 2924: PA_Summ_Balances summbal2

2920: select
2921: summbal2.amount_type_id AS amount_type_id
2922: , sum(summbal2.period_balance) AS period_balance
2923: from
2924: PA_Summ_Balances summbal2
2925: , PA_Objects paobj2
2926: where
2927: paobj2.Balance_Type_Code = p_Balance_Type_Code
2928: AND paobj2.expenditure_org_id = p_ORG_ID