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 528: DELETE FROM ozf_aging_summary_all WHERE org_id = l_org_id;

524: END IF;
525:
526: /*Hbandi Added this code for the Bug Fix #9273717 (+) */
527: l_org_id := MO_GLOBAL.get_current_org_id;
528: DELETE FROM ozf_aging_summary_all WHERE org_id = l_org_id;
529:
530: /*End of hbandi added Code (-) */
531:
532: -- Truncate existing data

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

529:
530: /*End of hbandi added Code (-) */
531:
532: -- Truncate existing data
533: /* TRUNCATE TABLE ozf.ozf_aging_summary_all; */
534: -- DELETE FROM ozf_aging_summary_all; --Hbandi Commented this statement and added in the above code snippet
535:
536: /* TRUNCATE table ozf.ozf_aging_bucket_dates; */
537: DELETE FROM ozf_aging_bucket_dates;

Line 534: -- DELETE FROM ozf_aging_summary_all; --Hbandi Commented this statement and added in the above code snippet

530: /*End of hbandi added Code (-) */
531:
532: -- Truncate existing data
533: /* TRUNCATE TABLE ozf.ozf_aging_summary_all; */
534: -- DELETE FROM ozf_aging_summary_all; --Hbandi Commented this statement and added in the above code snippet
535:
536: /* TRUNCATE table ozf.ozf_aging_bucket_dates; */
537: DELETE FROM ozf_aging_bucket_dates;
538: