APPS.PON_AUCTION_APPROVAL_PKG dependencies on PER_ALL_PEOPLE_F

Line 563: per_all_people_f emp,

559: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);
560:
561: /* Get the creator's full name */
562: select emp.full_name into l_creator_full_name from
563: per_all_people_f emp,
564: fnd_user fnd
565: where fnd.employee_id=emp.person_id and
566: fnd.user_id = l_creator_user_id and
567: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;