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 2031: , pa_lookups lkup

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

Line 2731: , pa_lookups lkup

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

Line 2824: from pa_lookups lkup2

2820: */
2821:
2822: Update PA_REP_UTIL_SCREEN_TMP tmp
2823: Set (resource_type,resource_type_code) = (select lkup2.meaning,lkup2.lookup_code
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