APPS.AS_OSI_LEAD_PUB dependencies on PER_PEOPLE_F

Line 500: from per_people_f ppf,

496: l_supervisor_id number;
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

Line 510: from per_people_f ppf

506: and as1.status_code = 'A'
507: group by ppf.person_id
508: UNION
509: select ppf.person_id person_id, max(ppf.email_address) email_address, max(ppf.last_name)
510: from per_people_f ppf
511: where ppf.person_id = supervisor_id_in
512: and sysdate between ppf.effective_start_date and ppf.effective_end_date
513: group by ppf.person_id
514: ORDER BY 3,2;

Line 517: from per_people_f ppf

513: group by ppf.person_id
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)