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 2028: , PA_Objects paobj

2024: , p_Period_Quarter) --Bug 8528649 End changes for Quarter
2025: ) AS FORECAST_CAP_OR_TOT_HRS
2026: from
2027: PA_Summ_Balances summbal
2028: , PA_Objects paobj
2029: , pa_resources_denorm resdnorm
2030: , gl_periods glprd
2031: , pa_lookups lkup
2032: where

Line 2728: , PA_Objects paobj

2724: , p_period_year)
2725: ) AS FORECAST_CAP_OR_TOT_HRS
2726: from
2727: PA_Summ_Balances summbal
2728: , PA_Objects paobj
2729: , pa_resources_denorm resdnorm
2730: , gl_periods glprd
2731: , pa_lookups lkup
2732: where

Line 2891: , PA_Objects paobj2

2887: summbal2.amount_type_id AS amount_type_id
2888: , sum(summbal2.period_balance) AS period_balance
2889: from
2890: PA_Summ_Balances summbal2
2891: , PA_Objects paobj2
2892: where
2893: paobj2.Balance_Type_Code = p_Balance_Type_Code
2894: AND paobj2.expenditure_org_id = p_ORG_ID
2895: AND summbal2.version_id = p_Version_ID

Line 2920: , PA_Objects paobj2

2916: summbal2.amount_type_id AS amount_type_id
2917: , sum(summbal2.period_balance) AS period_balance
2918: from
2919: PA_Summ_Balances summbal2
2920: , PA_Objects paobj2
2921: where
2922: paobj2.Balance_Type_Code = p_Balance_Type_Code
2923: AND paobj2.expenditure_org_id = p_ORG_ID
2924: AND summbal2.version_id = p_Version_ID

Line 2948: , PA_Objects paobj2

2944: summbal2.amount_type_id AS amount_type_id
2945: , sum(summbal2.period_balance) AS period_balance
2946: from
2947: PA_Summ_Balances summbal2
2948: , PA_Objects paobj2
2949: where
2950: paobj2.Balance_Type_Code = p_Balance_Type_Code
2951: AND paobj2.expenditure_org_id = p_ORG_ID
2952: AND summbal2.version_id = p_Version_ID