DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PER_PERSON_TYPES

Line 2301: FROM PER_PERSON_TYPES p_type,

2297: IF l_proj_person_id(i) IS NOT NULL THEN
2298: BEGIN
2299: SELECT p_type.SYSTEM_PERSON_TYPE
2300: INTO l_person_type_code_tab(i)
2301: FROM PER_PERSON_TYPES p_type,
2302: PER_PERSON_TYPE_USAGES_F p_usg
2303: WHERE p_type.SYSTEM_PERSON_TYPE IN ('EMP', 'CWK')
2304: AND p_type.PERSON_TYPE_ID = p_usg.PERSON_TYPE_ID
2305: AND l_proj_person_id(i) = p_usg.PERSON_ID