APPS.FV_SF224_TRANSACTIONS dependencies on FV_SF224_AUDITS

Line 484: FROM fv_sf224_audits

480: IF (l_supplemental_flag(i) IS NULL) THEN
481: BEGIN
482: SELECT MAX(supplemental_flag)
483: INTO l_tmp_supplemental_flag
484: FROM fv_sf224_audits
485: WHERE reported_gl_period = p_gl_period
486: AND set_of_books_id = p_set_of_books_id
487: AND alc_code = l_alc_code(i);
488:

Line 514: l_location := l_module_name||'select_fv_sf224_audits';

510: l_alc_supplemental(l_tot_alc_supplemental).alc_code := l_alc_code(i);
511: WHEN OTHERS THEN
512: p_error_code := g_FAILURE;
513: p_error_desc := SQLERRM;
514: l_location := l_module_name||'select_fv_sf224_audits';
515: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
516: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
517: END;
518: END IF;

Line 763: INSERT INTO fv_sf224_audits

759: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'INSERTING INTO THE AUDITS TABLE.');
760: END IF;
761:
762: BEGIN
763: INSERT INTO fv_sf224_audits
764: (
765: batch_id ,
766: sf224_month_reported,
767: reported_month,

Line 1818: from fv_sf224_audits fvs

1814: JE_FROM_SLA_FLAG
1815: )';
1816:
1817: l_string3 := ' AND not exists (select batch_id
1818: from fv_sf224_audits fvs
1819: where fvs.batch_id = glb.je_batch_id
1820: and fvs.je_header_id = gll.je_header_id
1821: and fvs.je_line_num = gll.je_line_num)';
1822: