DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_FOOTNOTE_LINES

Line 3264: fv_facts_footnote_lines ffl

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 ;
3268: IF footnote_count = 0 THEN

Line 3284: INSERT INTO fv_facts_footnote_lines

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
3285: (footnote_header_id,
3286: footnote_line_id,
3287: footnote_seq_number,
3288: footnote_text)

Line 3291: fv_facts_footnote_lines_s.nextval,

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');
3295: END IF;