DBA Data[Home] [Help]

APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on PO_VENDOR_SITES_ALL

Line 135: PO_VENDOR_SITES_ALL PVSA,

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
139: AND PVSA.VENDOR_ID = JATVH.VENDOR_ID

Line 291: cp_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,

287:
288: -- cursor to fetch JAI_AP_TDS_TH_VSITE_V
289: cursor c_tds_th_vsite_v (cp_tds_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
290: cp_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,
291: cp_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
292: cp_tds_sec_code JAI_AP_TDS_THHOLD_HDRS.SECTION_CODE%TYPE)
293: is
294: SELECT THRESHOLD_HDR_ID,
295: NVL(EXCEPTION_SETUP_FLAG,'N'),