APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on PO_VENDORS

Line 737: po_vendors pvn,

733: okl_cnsld_ar_strms_b st,
734: okc_k_party_roles_b pty,
735: okc_rules_b rul,
736: okc_k_headers_b CHR,
737: po_vendors pvn,
738: po_vendor_sites_all pvs
739: WHERE st.id = xls.lsm_id
740: AND st.receivables_invoice_id = ps.customer_trx_id
741: AND ps.class IN('INV', 'CM')

Line 775: po_vendors pvn

771: okl_cnsld_ar_strms_b st,
772: okc_k_party_roles_b pty,
773: okc_rules_b rul,
774: okc_k_headers_all_b CHR,
775: po_vendors pvn
776: WHERE st.id = xls.lsm_id
777: AND st.receivables_invoice_id = ps.customer_trx_id
778: AND ps.class IN('INV', 'CM')
779: AND arapp.applied_payment_schedule_id = ps.payment_schedule_id

Line 2932: po_vendors pov,

2928: is select crh.refund_header_number
2929: ,crh.disbursement_amount
2930: ,pov.vendor_name
2931: from okl_cure_refund_headers_b crh,
2932: po_vendors pov,
2933: po_vendor_sites_All povs
2934: where crh.vendor_site_id =povs.vendor_site_id
2935: and pov.vendor_id =povs.vendor_id
2936: and crh.cure_refund_header_id =p_refund_header_id;

Line 2941: l_vendor_name po_vendors.vendor_name%TYPE;

2937:
2938: l_refund_amount okl_cure_refund_headers_b.disbursement_amount%TYPE;
2939: l_refund_number okl_cure_refund_headers_b.refund_header_number%TYPE;
2940:
2941: l_vendor_name po_vendors.vendor_name%TYPE;
2942: l_notification_agent varchar2(100) := 'SYSADMIN';
2943:
2944: cursor c_get_agent(p_user_id IN NUMBER) is
2945: select wfr.name