DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PER_ALL_ASSIGNMENTS_F

Line 2314: FROM PER_ALL_ASSIGNMENTS_F p_asg

2310: END;
2311: BEGIN
2312: SELECT p_asg.vendor_id
2313: INTO l_vendor_id_tab(i)
2314: FROM PER_ALL_ASSIGNMENTS_F p_asg
2315: WHERE l_proj_person_id(i) = p_asg.PERSON_ID
2316: AND l_proj_start_date(i) BETWEEN p_asg.EFFECTIVE_START_DATE AND p_asg.EFFECTIVE_END_DATE
2317: AND p_asg.PRIMARY_FLAG = 'Y';
2318: EXCEPTION