eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_PREPAY_APP_DISTS

Line 293: DELETE FROM AP_Prepay_App_Dists

289: (SELECT Event_ID
290: FROM XLA_Events_GT
291: WHERE Entity_Code = 'AP_PAYMENTS');
292:
293: DELETE FROM AP_Prepay_App_Dists
294: WHERE Accounting_Event_ID IN
295: (SELECT Event_ID
296: FROM XLA_Events_GT
297: WHERE Event_Type_Code IN ('PREPAYMENT APPLICATION ADJ'));

Line 459: FROM AP_Prepay_App_Dists APAD

455:
456:
457: SELECT SUM(APAD.Amount)
458: INTO l_prepay_sum
459: FROM AP_Prepay_App_Dists APAD
460: WHERE APAD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
461: AND APAD.Prepay_App_Distribution_ID = P_Prepay_App_Dist_ID
462: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
463: 'PREPAY APPL NONREC TAX', 'AWT',

Line 495: FROM AP_Prepay_App_Dists APAD

491:
492:
493: SELECT SUM(APAD.Amount)
494: INTO l_tax_diff_sum
495: FROM AP_Prepay_App_Dists APAD
496: WHERE APAD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
497: AND APAD.Prepay_App_Distribution_ID = P_Prepay_App_Dist_ID
498: AND APAD.Prepay_Dist_Lookup_Code IN ('TAX DIFF');
499:

Line 745: FROM AP_Prepay_App_Dists APAD

741:
742:
743: SELECT SUM(APAD.Amount)
744: INTO l_prepay_sum
745: FROM AP_Prepay_App_Dists APAD
746: WHERE APAD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
747: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
748: 'PREPAY APPL NONREC TAX', 'AWT',
749: 'EXCHANGE RATE VARIANCE');

Line 898: /* Get the total prepaid amount from the ap_prepay_app_dists table */

894:
895: END IF;
896:
897:
898: /* Get the total prepaid amount from the ap_prepay_app_dists table */
899: SELECT SUM(APAD.Amount)
900: INTO l_prepaid_acctd_amt
901: FROM AP_Prepay_App_Dists APAD,
902: AP_Invoice_Distributions_All AID

Line 901: FROM AP_Prepay_App_Dists APAD,

897:
898: /* Get the total prepaid amount from the ap_prepay_app_dists table */
899: SELECT SUM(APAD.Amount)
900: INTO l_prepaid_acctd_amt
901: FROM AP_Prepay_App_Dists APAD,
902: AP_Invoice_Distributions_All AID
903: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
904: AND AID.Invoice_Distribution_ID = APAD.Invoice_Distribution_ID
905: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',