APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PER_ASSIGNMENTS_F

Line 388: PER_ASSIGNMENTS_F A

384: SELECT
385: /*+ INDEX(P PER_PEOPLE_F_PK) */
386: 1
387: FROM PER_PEOPLE_F P,
388: PER_ASSIGNMENTS_F A
389: WHERE P.person_id = p_deliver_to_person_id_tbl(i)
390: AND A.person_id = P.person_id
391: AND A.primary_flag = 'Y'
392: AND TRUNC(SYSDATE) BETWEEN P.effective_start_date AND P.effective_end_date