APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 1440: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL AID

1436: /* Modified the query for performance bug8983726 */
1437: -- bug 8690407: add end
1438:
1439: -- bug 7215835: add start : update self assessed table also
1440: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL AID
1441: SET AID.assets_addition_flag = 'N'
1442: WHERE AID.invoice_distribution_id IN
1443: (SELECT APIDG.invoice_distribution_id
1444: FROM ap_invoice_distributions_gt APIDG)

Line 2086: UPDATE ap_self_assessed_tax_dist_all APID

2082: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'No of Records Updated: ' ||TO_CHAR(l_count));
2083: END IF;
2084: --
2085: -- bug 7215835: add start : update self assessed table also
2086: UPDATE ap_self_assessed_tax_dist_all APID
2087: SET APID.assets_addition_flag = 'N',
2088: APID.program_update_date = SYSDATE,
2089: APID.program_application_id = FND_GLOBAL.prog_appl_id,
2090: APID.program_id = FND_GLOBAL.conc_program_id,

Line 2325: from ap_self_assessed_tax_dist_all astx

2321: from ap_invoice_distributions_all aid
2322: Where aid.invoice_distribution_id = i.invoice_distribution_id
2323: UNION
2324: Select distinct astx.invoice_id "INVOICE_ID"
2325: from ap_self_assessed_tax_dist_all astx
2326: Where astx.invoice_distribution_id = i.invoice_distribution_id);
2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN

Line 2363: MERGE INTO ap_self_assessed_tax_dist_all apid

2359: --
2360: l_count := SQL%ROWCOUNT;
2361: --
2362:
2363: MERGE INTO ap_self_assessed_tax_dist_all apid
2364: USING fa_mass_additions_gt fmag
2365: ON (apid.invoice_distribution_id = fmag.invoice_distribution_id
2366: AND fmag.line_status = 'PROCESSED'
2367: AND fmag.ledger_id = l_ledger_id

Line 2401: UPDATE ap_self_assessed_tax_dist_all APID

2397: AND APID.assets_addition_flag = 'U';
2398: --
2399: l_count := SQL%ROWCOUNT;
2400: --
2401: UPDATE ap_self_assessed_tax_dist_all APID
2402: SET APID.assets_addition_flag = 'N',
2403: APID.program_update_date = SYSDATE,
2404: APID.program_application_id = FND_GLOBAL.prog_appl_id,
2405: APID.program_id = FND_GLOBAL.conc_program_id,