APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PER_ASSIGNMENTS_F

Line 376: PER_ASSIGNMENTS_F A

372: SELECT
373: /*+ INDEX(P PER_PEOPLE_F_PK) */
374: 1
375: FROM PER_PEOPLE_F P,
376: PER_ASSIGNMENTS_F A
377: WHERE P.person_id = p_deliver_to_person_id_tbl(i)
378: AND A.person_id = P.person_id
379: AND A.primary_flag = 'Y'
380: AND TRUNC(SYSDATE) BETWEEN P.effective_start_date AND P.effective_end_date