APPS.JL_JLZZPSSR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 346: AP_INVOICE_DISTRIBUTIONS_ALL AID

342: SELECT
343: SUM(NVL(AID.PREPAY_AMOUNT_REMAINING
344: ,AID.AMOUNT)) * - 1
345: FROM
346: AP_INVOICE_DISTRIBUTIONS_ALL AID
347: WHERE AID.INVOICE_ID = V_INVOICE_ID
348: AND AID.LINE_TYPE_LOOKUP_CODE = 'ITEM'
349: AND AID.POSTED_FLAG = 'Y';
350: CURSOR C_INVOICE IS

Line 358: AP_INVOICE_DISTRIBUTIONS_ALL AID

354: NVL(SUM(NVL(AID.BASE_AMOUNT
355: ,AID.AMOUNT))
356: ,0) * - 1
357: FROM
358: AP_INVOICE_DISTRIBUTIONS_ALL AID
359: WHERE AID.INVOICE_ID = V_INVOICE_ID
360: AND ( AID.LINE_TYPE_LOOKUP_CODE = 'AWT'
361: OR AID.LINE_TYPE_LOOKUP_CODE = 'PREPAY' )
362: AND AID.POSTED_FLAG = 'Y';

Line 651: LP_AP_INVOICE_DISTRIBUTIONS := 'AP_INVOICE_DISTRIBUTIONS_ALL';

647: END IF;
648: /*SRW.MESSAGE('125'
649: ,'pass param')*/NULL;
650: LP_AP_INVOICES := 'AP_INVOICES_ALL';
651: LP_AP_INVOICE_DISTRIBUTIONS := 'AP_INVOICE_DISTRIBUTIONS_ALL';
652: LP_AP_INVOICE_PAYMENTS := 'AP_INVOICE_PAYMENTS_ALL';
653: /*SRW.MESSAGE('126'
654: ,'pass param 2')*/NULL;
655: RETURN (TRUE);