APPS.INV_LABEL_PVT3 dependencies on PER_PEOPLE_F

Line 357: per_people_f ppf

353: , mcch.cycle_count_header_name
354: , ppf.full_name requestor
355: FROM mtl_cycle_count_headers mcch,
356: mtl_cycle_count_entries mcce,
357: per_people_f ppf
358: WHERE cycle_count_entry_id= p_transaction_id
359: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
360: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
361: /* End of fix for Bug 4891916 */

Line 372: per_people_f ppf,

368: SELECT mcch.cycle_count_header_name,
369: ppf.full_name requestor
370: FROM mtl_cycle_count_headers mcch,
371: mtl_cycle_count_entries mcce,
372: per_people_f ppf,
373: mtl_material_transactions_temp mmtt
374: WHERE mmtt.transaction_temp_id= p_transaction_id
375: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
376: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 512: l_requestor per_people_f.full_name%TYPE;

508: -- a list of columns that are selected for format
509: l_column_name_list LONG;
510:
511: --Bug 4891916. Added the following local variables to store the counter and cycle count name.
512: l_requestor per_people_f.full_name%TYPE;
513: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
514:
515: l_patch_level NUMBER;
516: l_count NUMBER;