APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_FOOTNOTE_HDR

Line 3263: FROM fv_facts_footnote_hdr ffh,

3259: FOR footnote_rec IN footnote_select(v_treasury_symbol_id)
3260: LOOP
3261: SELECT count(*)
3262: INTO footnote_count
3263: FROM fv_facts_footnote_hdr ffh,
3264: fv_facts_footnote_lines ffl
3265: WHERE ffh.treasury_symbol_id = footnote_rec.treasury_symbol_id
3266: AND ffh.sgl_acct_number = footnote_rec.sgl_acct_number
3267: AND ffh.footnote_header_id = ffl.footnote_header_id ;

Line 3275: INSERT INTO fv_facts_footnote_hdr

3271: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3272: l_module_name,
3273: 'Creating Footnote Records.....');
3274: END IF;
3275: INSERT INTO fv_facts_footnote_hdr
3276: (footnote_header_id,
3277: treasury_symbol_id,
3278: sgl_acct_number)
3279: VALUES

Line 3280: (fv_facts_footnote_hdr_s.nextval,

3276: (footnote_header_id,
3277: treasury_symbol_id,
3278: sgl_acct_number)
3279: VALUES
3280: (fv_facts_footnote_hdr_s.nextval,
3281: footnote_rec.treasury_symbol_id,
3282: footnote_rec.sgl_acct_number);
3283:
3284: INSERT INTO fv_facts_footnote_lines

Line 3290: (fv_facts_footnote_hdr_s.currval,

3286: footnote_line_id,
3287: footnote_seq_number,
3288: footnote_text)
3289: VALUES
3290: (fv_facts_footnote_hdr_s.currval,
3291: fv_facts_footnote_lines_s.nextval,
3292: 1,
3293: 'Footnotes should be entered in FACTS II '||
3294: 'Online system');