DBA Data[Home] [Help]

APPS.PON_AUCTION_APPROVAL_PKG dependencies on PER_ALL_PEOPLE_F

Line 752: per_all_people_f emp,

748: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);
749:
750: /* Get the creator's full name */
751: select emp.full_name into l_creator_full_name from
752: per_all_people_f emp,
753: fnd_user fnd
754: where fnd.employee_id=emp.person_id and
755: fnd.user_id = l_creator_user_id and
756: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;