DBA Data[Home] [Help]

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