APPS.AP_XLA_UPGRADE_PKG dependencies on AP_PREPAY_APP_DISTS

Line 511: 'Insert into AP_Prepay_App_Dists');

507: AND APH.RNum = 1;
508:
509: IF g_level_procedure >= g_current_runtime_level THEN
510: FND_LOG.STRING(g_level_procedure,'AP_XLA_UPGRADE_PKG.CREATE_PREPAY_DIST_LINKS',
511: 'Insert into AP_Prepay_App_Dists');
512: END IF;
513:
514: INSERT INTO AP_Prepay_App_Dists
515: (PREPAY_APP_DIST_ID,

Line 514: INSERT INTO AP_Prepay_App_Dists

510: FND_LOG.STRING(g_level_procedure,'AP_XLA_UPGRADE_PKG.CREATE_PREPAY_DIST_LINKS',
511: 'Insert into AP_Prepay_App_Dists');
512: END IF;
513:
514: INSERT INTO AP_Prepay_App_Dists
515: (PREPAY_APP_DIST_ID,
516: PREPAY_DIST_LOOKUP_CODE,
517: INVOICE_DISTRIBUTION_ID,
518: PREPAY_APP_DISTRIBUTION_ID,

Line 529: SELECT AP_Prepay_App_Dists_S.Nextval,

525: LAST_UPDATE_DATE,
526: LAST_UPDATE_LOGIN,
527: CREATED_BY,
528: CREATION_DATE)
529: SELECT AP_Prepay_App_Dists_S.Nextval,
530: Prepay_Dist_Lookup_Code,
531: Invoice_Distribution_ID,
532: Prepay_App_Distribution_ID,
533: Accounting_Event_ID,

Line 677: use_nl_with_index (apad, ap_prepay_app_dists_n3)

673: EVENT_CLASS_CODE,
674: EVENT_TYPE_CODE)
675: SELECT /*+ ordered index (ai, ap_invoices_u1) swap_join_inputs (upg)
676: use_nl_with_index (aae, ap_accounting_events_n1)
677: use_nl_with_index (apad, ap_prepay_app_dists_n3)
678: use_nl_with_index (aid, ap_invoice_distributions_u2)
679: use_nl_with_index (aeh, xla_ae_headers_n2)
680: use_nl_with_index (ael, xla_ae_lines_u1) */
681: 200 Application_ID,

Line 723: AP_Prepay_App_Dists APAD,

719: 'INVOICES_ALL' Event_Type_Code
720: FROM AP_Invoices_All AI,
721: XLA_Upgrade_Dates UPG,
722: AP_Accounting_Events_All AAE,
723: AP_Prepay_App_Dists APAD,
724: AP_Invoice_Distributions_All AID,
725: XLA_AE_Headers AEH,
726: XLA_AE_Lines AEL
727: WHERE AI.Invoice_ID BETWEEN p_start_id AND p_end_id