APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on PO_VENDOR_SITES

Line 738: po_vendor_sites_all pvs

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')
742: AND arapp.applied_payment_schedule_id = ps.payment_schedule_id

Line 2786: l_email po_vendor_sites.email_address%TYPE;

2782: l_api_name CONSTANT VARCHAR2(50) := 'GET_ROLE';
2783: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'||l_api_name ;
2784:
2785:
2786: l_email po_vendor_sites.email_address%TYPE;
2787: l_role_prefix VARCHAR2(10) := 'OKLVENDOR_';
2788: l_role_name VARCHAR2(30);
2789: l_role_display_name po_vendor_sites.vendor_site_code%TYPE;
2790: l_role_exists NUMBER;

Line 2789: l_role_display_name po_vendor_sites.vendor_site_code%TYPE;

2785:
2786: l_email po_vendor_sites.email_address%TYPE;
2787: l_role_prefix VARCHAR2(10) := 'OKLVENDOR_';
2788: l_role_name VARCHAR2(30);
2789: l_role_display_name po_vendor_sites.vendor_site_code%TYPE;
2790: l_role_exists NUMBER;
2791:
2792:
2793: /*

Line 2805: from po_vendor_sites pos,

2801: select pos.vendor_site_id,
2802: pos.vendor_site_code,
2803: pos.email_address,
2804: crh.cure_refund_header_id
2805: from po_vendor_sites pos,
2806: okl_cure_refund_headers_b crh,
2807: okl_cure_refunds crl
2808: where crh.vendor_site_id =pos.vendor_site_id
2809: and crh.cure_refund_header_id=p_refund_header_id

Line 2933: po_vendor_sites_All povs

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;
2937: