APPS.PA_REP_UTIL_SCREEN dependencies on PA_RESOURCES_DENORM

Line 637: , pa_resources_denorm resdnorm

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'
641: AND lkup.lookup_code = 'EMPLOYEE'

Line 1325: , pa_resources_denorm resdnorm

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

Line 2017: , pa_resources_denorm resdnorm

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

Line 2708: , pa_resources_denorm resdnorm

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

Line 2795: * of EMPLOYEE for all the records now check against pa_resources_denorm

2791: * Bug 1633069
2792: * Now to update the resource_type_code, added through bug 1633069,
2793: * to identify the resources reporting to the select manager who are also
2794: * in turn managers of other resources. The above select put the value of
2795: * of EMPLOYEE for all the records now check against pa_resources_denorm
2796: * to update the resource_type_code to MANAGERS appropriately.
2797: */
2798:
2799: Update PA_REP_UTIL_SCREEN_TMP tmp

Line 2805: from pa_resources_denorm prd

2801: from pa_lookups lkup2
2802: where lkup2.lookup_type='PERSON_TYPE'
2803: and lkup2.lookup_code = 'MANAGER')
2804: Where exists (select prd.Person_id
2805: from pa_resources_denorm prd
2806: where prd.manager_id = tmp.person_id)
2807: ;
2808:
2809: