APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PER_PEOPLE_F

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

344: END IF;
345:
346: d_position := 20;
347:
348: -- bug 5454379: add hint to use index PER_PEOPLE_F_PK
349: -- which is more selective
350: FORALL i IN INDICES OF l_index_tbl
351: INSERT INTO po_validation_results_gt
352: (result_set_id,

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

369: p_deliver_to_person_id_tbl(i)
370: FROM DUAL
371: WHERE NOT EXISTS(
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)

Line 375: FROM PER_PEOPLE_F P,

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