APPS.JA_JAINITCL_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
Line 85: CURSOR FETCH_PREPAYMENT_AMT_CUR(CP_LINE_TYPE IN AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE) IS
81:
82: FUNCTION CF_GROSS_INV_AMTFORMULA(INVOICE_ID1 IN NUMBER
83: ,INVOICE_AMOUNT1 IN NUMBER) RETURN NUMBER IS
84: TMP NUMBER := 0; 85: CURSOR FETCH_PREPAYMENT_AMT_CUR(CP_LINE_TYPE IN AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE) IS 86: SELECT
87: SUM(AMOUNT)
88: FROM
89: AP_INVOICE_LINES_ALL