130: cursor c_get_vendor_pan_tan(cp_vendor_id number , cp_vendor_site_id number) is
131: SELECT JATVH.PAN_NO PAN_NO,
132: JATOTV.ORG_TAN_NUM TAN_NO,
133: JATVH.CONFIRM_PAN_FLAG CONFIRM_PAN_FLAG -- added by zhiwei.xin for bug 13792748 on 08-Mar-2012
134: FROM PO_VENDORS PV,
135: PO_VENDOR_SITES_ALL PVSA,
136: JAI_AP_TDS_VENDOR_HDRS JATVH,
137: JAI_AP_TDS_ORG_TAN_V JATOTV
138: WHERE PV.VENDOR_ID = PVSA.VENDOR_ID