DBA Data[Home] [Help]

APPS.PA_REP_UTIL_SCREEN dependencies on PA_OBJECTS

Line 636: , PA_Objects paobj

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
640: lkup.lookup_type = 'PERSON_TYPE'

Line 1324: , PA_Objects paobj

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
1328: where

Line 2016: , PA_Objects paobj

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
2020: where

Line 2707: , PA_Objects paobj

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
2711: where

Line 2868: , PA_Objects paobj2

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
2872: AND summbal2.version_id = p_Version_ID

Line 2897: , PA_Objects paobj2

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
2901: AND summbal2.version_id = p_Version_ID

Line 2925: , PA_Objects paobj2

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
2929: AND summbal2.version_id = p_Version_ID