DBA Data[Home] [Help]

APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on PO_VENDORS

Line 134: FROM PO_VENDORS PV,

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