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_SALES_GROUPS

Line 518: ,as_sales_groups asg

514: ORDER BY 3,2;
515: cursor sg_cur (last_name_in in varchar2, email_address_in in varchar2) is
516: select max(ppf.person_id) supervisor_id, max(asg.sales_group_id) sales_group_id
517: from per_people_f ppf
518: ,as_sales_groups asg
519: where ppf.last_name = last_name_in
520: and upper(ppf.email_address) = email_address_in
521: and trunc(nvl(ppf.effective_start_date,sysdate)) <= trunc(sysdate)
522: and trunc(nvl(ppf.effective_end_date,sysdate)) >= trunc(sysdate)