APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 377: ,ap_self_assessed_tax_dist_all astd

373: ,G_SRC_TYP_UNACCT_DISTS
374: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
375: from
376: ap_invoices_all ai
377: ,ap_self_assessed_tax_dist_all astd
378: ,ap_org_attributes_gt org_gtt
379: where
380: ai.invoice_id = astd.invoice_id
381: and (astd.accounting_date between g_period_start_date and g_period_end_date )

Line 414: ,ap_self_assessed_tax_dist_all astd

410: ,G_SRC_TYP_UNACCT_DISTS
411: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
412: from
413: ap_invoices_all ai
414: ,ap_self_assessed_tax_dist_all astd
415: ,ap_org_attributes_gt org_gtt
416: where
417: ai.invoice_id = astd.invoice_id
418: and (astd.accounting_date between g_period_start_date and g_period_end_date )

Line 918: ,ap_self_assessed_tax_dist_all astd

914: ,xla_events_unacct(i).entity_code
915: ,G_SRC_TYP_OTHER_EXCPS
916: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
917: FROM ap_invoices_all ai
918: ,ap_self_assessed_tax_dist_all astd
919: ,ap_org_attributes_gt org_gtt
920: WHERE astd.invoice_id = ai.invoice_id(+)
921: AND astd.set_of_books_id = g_ledger_id
922: AND astd.org_id = org_gtt.org_id

Line 2125: UPDATE ap_self_assessed_tax_dist_all astd

2121:
2122: l_dbi_key_value_list.delete;
2123:
2124:
2125: UPDATE ap_self_assessed_tax_dist_all astd
2126: SET accounting_date = g_sweep_to_date,
2127: period_name = g_sweep_to_period,
2128: last_update_date = sysdate,
2129: last_updated_by = 5

Line 2138: debug ('update_ap_acct_date: total records updated in ap_self_assessed_tax_dist_all: '||sql%rowcount);

2134: AND gt.source_table_name = G_SRC_TAB_AP_SELF_TAX_DIST_ALL)
2135: AND astd.posted_flag <> 'Y'
2136: returning invoice_distribution_id bulk collect into ltab_id;
2137:
2138: debug ('update_ap_acct_date: total records updated in ap_self_assessed_tax_dist_all: '||sql%rowcount);
2139:
2140: forall i in ltab_id.first .. ltab_id.last
2141: update /*+index (gt AP_PERIOD_CLOSE_EXCPS_GT_N3)*/ ap_period_close_excps_gt gt --Bug 9045217
2142: set process_status_flag = 'Y'