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.PATC dependencies on PO_VENDORS

Line 469: FROM po_vendors_ap_v

465:
466: /* bug # 2426506 */
467: SELECT count(*)
468: INTO dummy2
469: FROM po_vendors_ap_v
470: WHERE vendor_id = x_vendor_id
471: AND vendor_type_lookup_code = 'EMPLOYEE'
472: AND employee_id is NULL ;
473:

Line 476: FROM po_vendors_ap_v

472: AND employee_id is NULL ;
473:
474: SELECT count(*)
475: INTO dummy
476: FROM po_vendors_ap_v
477: WHERE vendor_id = x_vendor_id
478: AND employee_id is NULL ;
479:
480: /* bug # 2426506, added if condition */

Line 508: FROM po_vendors vend

504: l_return_number Number := NULL;
505: l_emp_number Number := Null;
506: CURSOR cur_emp IS
507: SELECT vend.employee_id
508: FROM po_vendors vend
509: WHERE vend.vendor_id = p_vendor_id
510: AND p_ei_date BETWEEN nvl(vend.start_date_active,p_ei_date) AND
511: nvl( vend.end_date_active, trunc(sysdate) ) ;
512: