APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PER_PERSON_TYPES

Line 2313: FROM PER_PERSON_TYPES p_type,

2309: IF l_proj_person_id(i) IS NOT NULL THEN
2310: BEGIN
2311: SELECT p_type.SYSTEM_PERSON_TYPE
2312: INTO l_person_type_code_tab(i)
2313: FROM PER_PERSON_TYPES p_type,
2314: PER_PERSON_TYPE_USAGES_F p_usg
2315: WHERE p_type.SYSTEM_PERSON_TYPE IN ('EMP', 'CWK')
2316: AND p_type.PERSON_TYPE_ID = p_usg.PERSON_TYPE_ID
2317: AND l_proj_person_id(i) = p_usg.PERSON_ID