APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST

Line 566: ap_self_assessed_tax_dist satx

562: satx.charge_applicable_to_dist_id,
563: nvl(satx.asset_book_type_code, item.asset_book_type_code),
564: satx.set_of_books_id
565: FROM ap_invoice_distributions_all item,
566: ap_self_assessed_tax_dist satx
567: WHERE satx.accounting_date <= P_acctg_date
568: AND satx.assets_addition_flag = 'U'
569: AND item.assets_tracking_flag = 'Y'
570: AND item.assets_addition_flag IN ('Y', 'U')

Line 1065: ap_self_assessed_tax_dist satx

1061: satx.charge_applicable_to_dist_id,
1062: nvl(satx.asset_book_type_code, item.asset_book_type_code),
1063: satx.set_of_books_id
1064: FROM ap_invoice_distributions_all item,
1065: ap_self_assessed_tax_dist satx
1066: WHERE satx.accounting_date <= P_acctg_date
1067: AND satx.assets_addition_flag = 'U'
1068: AND item.assets_tracking_flag = 'Y'
1069: AND item.assets_addition_flag IN ('Y', 'U')

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,