APPS.PATC dependencies on PO_VENDORS

Line 503: FROM po_vendors_ap_v

499:
500: /* bug # 2426506 */
501: SELECT count(*)
502: INTO dummy2
503: FROM po_vendors_ap_v
504: WHERE vendor_id = x_vendor_id
505: AND vendor_type_lookup_code = 'EMPLOYEE'
506: AND employee_id is NULL ;
507:

Line 510: FROM po_vendors_ap_v

506: AND employee_id is NULL ;
507:
508: SELECT count(*)
509: INTO dummy
510: FROM po_vendors_ap_v
511: WHERE vendor_id = x_vendor_id
512: AND employee_id is NULL ;
513: /* Start Code Change for Bug 16451280 */
514: select COUNT(*)

Line 519: PO_VENDORS_AP_V POAPV

515: into DUMMY3
516: from PER_PEOPLE_F PPL,
517: PER_ASSIGNMENTS_F ASGN ,
518: PER_PERSON_TYPES PTYPE ,
519: PO_VENDORS_AP_V POAPV
520: where
521: POAPV.VENDOR_ID = X_VENDOR_ID
522: and POAPV.VENDOR_ID = ASGN.VENDOR_ID
523: and PPL.PERSON_ID = ASGN.PERSON_ID

Line 561: FROM po_vendors vend

557: l_return_number Number := NULL;
558: l_emp_number Number := Null;
559: CURSOR cur_emp IS
560: SELECT vend.employee_id
561: FROM po_vendors vend
562: WHERE vend.vendor_id = p_vendor_id
563: AND p_ei_date BETWEEN nvl(vend.start_date_active,p_ei_date) AND
564: nvl( vend.end_date_active, trunc(sysdate) ) ;
565: