APPS.FV_SF224_TRANSACTIONS dependencies on FV_SF224_AUDITS

Line 494: FROM fv_sf224_audits

490: IF (l_supplemental_flag(i) IS NULL) THEN
491: BEGIN
492: SELECT MAX(supplemental_flag)
493: INTO l_tmp_supplemental_flag
494: FROM fv_sf224_audits
495: WHERE reported_gl_period = p_gl_period
496: AND set_of_books_id = p_set_of_books_id
497: AND alc_code = l_alc_code(i);
498:

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

520: l_alc_supplemental(l_tot_alc_supplemental).alc_code := l_alc_code(i);
521: WHEN OTHERS THEN
522: p_error_code := g_FAILURE;
523: p_error_desc := SQLERRM;
524: l_location := l_module_name||'select_fv_sf224_audits';
525: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
526: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
527: END;
528: END IF;

Line 779: INSERT INTO fv_sf224_audits

775: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'INSERTING INTO THE AUDITS TABLE.');
776: END IF;
777:
778: BEGIN
779: INSERT INTO fv_sf224_audits
780: (
781: batch_id ,
782: sf224_month_reported,
783: reported_month,

Line 1841: from fv_sf224_audits fvs

1837: JE_FROM_SLA_FLAG
1838: )';
1839:
1840: l_string3 := ' AND not exists (select batch_id
1841: from fv_sf224_audits fvs
1842: where fvs.batch_id = glb.je_batch_id
1843: and fvs.je_header_id = gll.je_header_id
1844: and fvs.je_line_num = gll.je_line_num)';
1845: