DBA Data[Home] [Help]

APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS

Line 314: FROM JAI_AP_TDS_THHOLD_GRPS

310: SELECT (NVL(TOTAL_INVOICE_AMOUNT, 0) +
311: NVL(TOTAL_INVOICE_UNAPPLY_AMOUNT, 0) -
312: NVL(TOTAL_INVOICE_APPLY_AMOUNT, 0) -
313: NVL(TOTAL_INVOICE_CANCEL_AMOUNT, 0)) EFFECTIVE_AMOUNT
314: FROM JAI_AP_TDS_THHOLD_GRPS
315: WHERE VENDOR_ID = cp_vendor_id
316: AND VENDOR_PAN_NUM = cp_pan_num
317: AND ORG_TAN_NUM = cp_tan_num
318: AND SECTION_CODE = cp_sec_code