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 2029: , pa_resources_denorm resdnorm

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

Line 2729: , pa_resources_denorm resdnorm

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

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

2814: * Bug 1633069
2815: * Now to update the resource_type_code, added through bug 1633069,
2816: * to identify the resources reporting to the select manager who are also
2817: * in turn managers of other resources. The above select put the value of
2818: * of EMPLOYEE for all the records now check against pa_resources_denorm
2819: * to update the resource_type_code to MANAGERS appropriately.
2820: */
2821:
2822: Update PA_REP_UTIL_SCREEN_TMP tmp

Line 2828: from pa_resources_denorm prd

2824: from pa_lookups lkup2
2825: where lkup2.lookup_type='PERSON_TYPE'
2826: and lkup2.lookup_code = 'MANAGER')
2827: Where exists (select prd.Person_id
2828: from pa_resources_denorm prd
2829: where prd.manager_id = tmp.person_id)
2830: ;
2831:
2832: