APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PER_ALL_ASSIGNMENTS_F

Line 2326: FROM PER_ALL_ASSIGNMENTS_F p_asg

2322: END;
2323: BEGIN
2324: SELECT p_asg.vendor_id
2325: INTO l_vendor_id_tab(i)
2326: FROM PER_ALL_ASSIGNMENTS_F p_asg
2327: WHERE l_proj_person_id(i) = p_asg.PERSON_ID
2328: AND l_proj_start_date(i) BETWEEN p_asg.EFFECTIVE_START_DATE AND p_asg.EFFECTIVE_END_DATE
2329: AND p_asg.PRIMARY_FLAG = 'Y';
2330: EXCEPTION