DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_FOOTNOTE_LINES

Line 3217: fv_facts_footnote_lines ffl

3213: LOOP
3214: SELECT count(*)
3215: INTO footnote_count
3216: FROM fv_facts_footnote_hdr ffh,
3217: fv_facts_footnote_lines ffl
3218: WHERE ffh.treasury_symbol_id = footnote_rec.treasury_symbol_id
3219: AND ffh.sgl_acct_number = footnote_rec.sgl_acct_number
3220: AND ffh.footnote_header_id = ffl.footnote_header_id ;
3221: IF footnote_count = 0 THEN

Line 3237: INSERT INTO fv_facts_footnote_lines

3233: (fv_facts_footnote_hdr_s.nextval,
3234: footnote_rec.treasury_symbol_id,
3235: footnote_rec.sgl_acct_number);
3236:
3237: INSERT INTO fv_facts_footnote_lines
3238: (footnote_header_id,
3239: footnote_line_id,
3240: footnote_seq_number,
3241: footnote_text)

Line 3244: fv_facts_footnote_lines_s.nextval,

3240: footnote_seq_number,
3241: footnote_text)
3242: VALUES
3243: (fv_facts_footnote_hdr_s.currval,
3244: fv_facts_footnote_lines_s.nextval,
3245: 1,
3246: 'Footnotes should be entered in FACTS II '||
3247: 'Online system');
3248: END IF;