APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PER_PEOPLE_F

Line 360: -- bug 5454379: add hint to use index PER_PEOPLE_F_PK

356: END IF;
357:
358: d_position := 20;
359:
360: -- bug 5454379: add hint to use index PER_PEOPLE_F_PK
361: -- which is more selective
362: FORALL i IN INDICES OF l_index_tbl
363: INSERT INTO po_validation_results_gt
364: (result_set_id,

Line 385: /*+ INDEX(P PER_PEOPLE_F_PK) */

381: p_deliver_to_person_id_tbl(i)
382: FROM DUAL
383: WHERE NOT EXISTS(
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)

Line 387: FROM PER_PEOPLE_F P,

383: WHERE NOT EXISTS(
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'