DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PER_PERSON_TYPE_USAGES_F

Line 2314: PER_PERSON_TYPE_USAGES_F p_usg

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
2318: AND l_proj_start_date(i) BETWEEN p_usg.EFFECTIVE_START_DATE AND p_usg.EFFECTIVE_END_DATE;