APPS.POA_EDW_SPEND_PKG dependencies on PO_ASL_STATUS_RULES

Line 388: po_asl_status_rules pasr,

384: FROM po_distributions_all pod,
385: po_line_locations_all pll,
386: po_lines_all pol,
387: po_headers_all poh,
388: po_asl_status_rules pasr,
389: po_asl_statuses pas,
390: po_approved_supplier_list pasl
391: WHERE pod.po_header_id = poh.po_header_id
392: and pod.po_line_id = pol.po_line_id

Line 450: from po_asl_status_rules pasr,

446: BEGIN
447:
448: select decode(max('Y'), 'Y', 'Y', 'N')
449: into v_supp_approved
450: from po_asl_status_rules pasr,
451: po_asl_statuses pas,
452: po_approved_supplier_list pasl
453: where pasl.vendor_id = p_vendor_id
454: and (pasl.vendor_site_id is null or