APPS.PA_TRX_IMPORT dependencies on PO_VENDORS

Line 781: FROM po_vendors

777: log_message('log_message: ' || pa_debug.G_err_Stage);
778: END IF;
779:
780: SELECT vendor_ID INTO G_vendor_id
781: FROM po_vendors
782: WHERE segment1 = p_vendor_number;
783:
784:
785: IF PG_DEBUG = 'Y' THEN

Line 813: from po_vendors

809: END IF;
810:
811: select vendor_id
812: into g_vendor_id
813: from po_vendors
814: where employee_id = p_person_id
815: and vendor_type_lookup_code = 'EMPLOYEE' ;
816:
817: IF PG_DEBUG = 'Y' THEN

Line 1340: FROM po_vendors vend

1336: l_emp_number Number := Null;
1337:
1338: CURSOR cur_emp IS
1339: SELECT vend.employee_id
1340: FROM po_vendors vend
1341: WHERE vend.vendor_id = p_vendor_id
1342: /* AND p_ei_date BETWEEN nvl(vend.start_date_active,p_ei_date) AND
1343: nvl( vend.end_date_active, trunc(sysdate) ) ; */
1344: -- Bug 11063869 --Added trunc for the dates in the below condition.