APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 327: ,ap_self_assessed_tax_dist_all astd

323: ,G_SRC_TYP_UNACCT_DISTS
324: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
325: from
326: ap_invoices_all ai
327: ,ap_self_assessed_tax_dist_all astd
328: ,ap_org_attributes_gt org_gtt
329: where
330: ai.invoice_id = astd.invoice_id
331: -- bug 7311486 UTR report must run even if dates and period is not specified

Line 388: ,ap_self_assessed_tax_dist_all astd

384: ,G_SRC_TYP_UNACCT_DISTS
385: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
386: from
387: ap_invoices_all ai
388: ,ap_self_assessed_tax_dist_all astd
389: ,ap_org_attributes_gt org_gtt
390: where
391: ai.invoice_id = astd.invoice_id
392: -- bug 7311486 UTR report must run even if dates and period is not specified

Line 844: FROM ap_self_assessed_tax_dist_all aid

840: FROM ap_invoice_distributions_all aid
841: WHERE aid.bc_event_id = xe.event_id)
842: AND NOT EXISTS
843: (SELECT 1
844: FROM ap_self_assessed_tax_dist_all aid
845: WHERE aid.accounting_event_id = xe.event_id)
846: AND NOT EXISTS
847: (SELECT 1
848: FROM ap_self_assessed_tax_dist_all aid

Line 848: FROM ap_self_assessed_tax_dist_all aid

844: FROM ap_self_assessed_tax_dist_all aid
845: WHERE aid.accounting_event_id = xe.event_id)
846: AND NOT EXISTS
847: (SELECT 1
848: FROM ap_self_assessed_tax_dist_all aid
849: WHERE aid.bc_event_id = xe.event_id)
850: AND NOT EXISTS
851: (SELECT 1
852: FROM ap_prepay_history_all apph

Line 1843: UPDATE ap_self_assessed_tax_dist_all astd

1839:
1840: l_dbi_key_value_list.delete;
1841:
1842:
1843: UPDATE ap_self_assessed_tax_dist_all astd
1844: SET accounting_date = g_sweep_to_date,
1845: period_name = g_sweep_to_period,
1846: last_update_date = sysdate,
1847: last_updated_by = 5

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

1851: AND gt.source_table_name = G_SRC_TAB_AP_SELF_TAX_DIST_ALL)
1852: AND astd.posted_flag <> 'Y'
1853: returning invoice_distribution_id bulk collect into ltab_id;
1854:
1855: debug ('update_ap_acct_date: total records updated in ap_self_assessed_tax_dist_all: '||sql%rowcount);
1856:
1857: forall i in ltab_id.first .. ltab_id.last
1858: update ap_period_close_excps_gt gt
1859: set process_status_flag = 'Y'

Line 2040: FROM ap_self_assessed_tax_dist_all aid

2036: FROM ap_invoice_distributions_all aid
2037: WHERE aid.bc_event_id = xe.event_id)
2038: AND NOT EXISTS
2039: (SELECT 1
2040: FROM ap_self_assessed_tax_dist_all aid
2041: WHERE aid.accounting_event_id = xe.event_id)
2042: AND NOT EXISTS
2043: (SELECT 1
2044: FROM ap_self_assessed_tax_dist_all aid

Line 2044: FROM ap_self_assessed_tax_dist_all aid

2040: FROM ap_self_assessed_tax_dist_all aid
2041: WHERE aid.accounting_event_id = xe.event_id)
2042: AND NOT EXISTS
2043: (SELECT 1
2044: FROM ap_self_assessed_tax_dist_all aid
2045: WHERE aid.bc_event_id = xe.event_id)
2046: AND NOT EXISTS
2047: (SELECT 1
2048: FROM ap_prepay_history_all apph