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

Line 732: FROM po_vendors

728:
729: pa_cc_utils.set_curr_function('GetVendorId');
730:
731: SELECT vendor_ID INTO G_vendor_id
732: FROM po_vendors
733: WHERE segment1 = p_vendor_number;
734:
735: pa_cc_utils.reset_curr_function;
736:

Line 753: from po_vendors

749: pa_cc_utils.set_curr_function('GetVendorId for an employee (person_id):'||p_person_id);
750:
751: select vendor_id
752: into g_vendor_id
753: from po_vendors
754: where employee_id = p_person_id
755: and vendor_type_lookup_code = 'EMPLOYEE' ;
756:
757: pa_cc_utils.reset_curr_function;

Line 1249: FROM po_vendors vend

1245: l_emp_number Number := Null;
1246:
1247: CURSOR cur_emp IS
1248: SELECT vend.employee_id
1249: FROM po_vendors vend
1250: WHERE vend.vendor_id = p_vendor_id
1251: AND p_ei_date BETWEEN nvl(vend.start_date_active,p_ei_date) AND
1252: nvl( vend.end_date_active, trunc(sysdate) ) ;
1253: