APPS.OZF_CLAIM_AGING_PVT dependencies on OZF_AGING_SUMMARY_ALL

Line 362: FROM ozf_aging_summary_all

358: , aging_bucket_line_id aging_bucket_line_id
359: , bucket_sequence_num bucket_sequence_num
360: , org_id
361: , SUM(amount) amount
362: FROM ozf_aging_summary_all
363: GROUP BY aging_bucket_id
364: , aging_bucket_line_id
365: , bucket_sequence_num
366: , org_id;

Line 380: INSERT INTO ozf_aging_summary_all (

376: FETCH aging_summary_csr INTO l_aging_summary_rec;
377: EXIT WHEN aging_summary_csr%NOTFOUND
378: OR aging_summary_csr%NOTFOUND IS NULL;
379: IF l_aging_summary_rec.amount IS NOT NULL THEN
380: INSERT INTO ozf_aging_summary_all (
381: cust_account_id,
382: aging_bucket_id,
383: aging_bucket_line_id,
384: bucket_sequence_num,

Line 404: INSERT INTO ozf_aging_summary_all (

400: LOOP
401: FETCH aging_col_total_csr INTO l_aging_col_total_rec;
402: EXIT WHEN aging_col_total_csr%NOTFOUND
403: OR aging_col_total_csr%NOTFOUND IS NULL;
404: INSERT INTO ozf_aging_summary_all (
405: cust_account_id,
406: aging_bucket_id,
407: aging_bucket_line_id,
408: bucket_sequence_num,

Line 525: /* TRUNCATE TABLE ozf.ozf_aging_summary_all; */

521: RAISE FND_API.g_exc_error;
522: END IF;
523:
524: -- Truncate existing data
525: /* TRUNCATE TABLE ozf.ozf_aging_summary_all; */
526: DELETE FROM ozf_aging_summary_all;
527: /* TRUNCATE table ozf.ozf_aging_bucket_dates; */
528: DELETE FROM ozf_aging_bucket_dates;
529:

Line 526: DELETE FROM ozf_aging_summary_all;

522: END IF;
523:
524: -- Truncate existing data
525: /* TRUNCATE TABLE ozf.ozf_aging_summary_all; */
526: DELETE FROM ozf_aging_summary_all;
527: /* TRUNCATE table ozf.ozf_aging_bucket_dates; */
528: DELETE FROM ozf_aging_bucket_dates;
529:
530: FOR i IN 1..l_bucket_lines_tbl.count LOOP