eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_OSI_LEAD_PUB dependencies on AS_SALESFORCE

Line 501: as_salesforce as1

497: ndx binary_integer := 0;
498: cursor nam_cur (supervisor_id_in in number, sales_group_id_in in number) is
499: select ppf.person_id person_id, max(ppf.email_address) email_address, max(ppf.last_name)
500: from per_people_f ppf,
501: as_salesforce as1
502: where as1.sales_group_id = sales_group_id_in
503: and as1.employee_person_id is not null
504: and as1.employee_person_id = ppf.person_id
505: and sysdate between ppf.effective_start_date and ppf.effective_end_date