DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on XLA_AE_HEADERS

Line 432: xla_ae_headers xah,

428: xah.accounting_date ACCOUNTING_DATE ,
429: xah.ledger_id,
430: ai.org_id
431: FROM xla_events xe,
432: xla_ae_headers xah,
433: xla_transaction_entities xt,
434: ap_invoices_all ai
435: WHERE xe.application_id = 200
436: AND xah.application_id = 200

Line 806: DELETE from xla_ae_headers_gt;

802: DELETE from psa_bc_xla_events_gt;
803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
804: DELETE from xla_acct_prog_events_gt;
805: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
806: DELETE from xla_ae_headers_gt;
807: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);
808: DELETE from xla_ae_lines_gt;
809: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_lines_gt: ' || SQL%ROWCOUNT);
810: DELETE from xla_validation_lines_gt;

Line 807: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);

803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
804: DELETE from xla_acct_prog_events_gt;
805: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
806: DELETE from xla_ae_headers_gt;
807: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);
808: DELETE from xla_ae_lines_gt;
809: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_lines_gt: ' || SQL%ROWCOUNT);
810: DELETE from xla_validation_lines_gt;
811: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_validation_lines_gt: ' || SQL%ROWCOUNT);