APPS.PA_REP_UTIL_SCREEN dependencies on PA_LOOKUPS

Line 638: , pa_lookups lkup

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'
642: AND NVL(resdnorm.manager_id,-1) = NVL(p_manager_id,NVL(resdnorm.manager_id,-1))

Line 1327: , pa_lookups lkup

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'
1330: AND lkup.lookup_code = 'EMPLOYEE'
1331: AND NVL(resdnorm.manager_id,-1) = NVL(p_manager_id,NVL(resdnorm.manager_id,-1))

Line 2019: , pa_lookups lkup

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'
2022: AND lkup.lookup_code = 'EMPLOYEE'
2023: AND NVL(resdnorm.manager_id,-1) = NVL(p_manager_id,NVL(resdnorm.manager_id,-1))

Line 2710: , pa_lookups lkup

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'
2713: AND lkup.lookup_code = 'EMPLOYEE'
2714: AND NVL(resdnorm.manager_id,-1) = NVL(p_manager_id,NVL(resdnorm.manager_id,-1))

Line 2801: from pa_lookups lkup2

2797: */
2798:
2799: Update PA_REP_UTIL_SCREEN_TMP tmp
2800: Set (resource_type,resource_type_code) = (select lkup2.meaning,lkup2.lookup_code
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