APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_FOOTNOTE_HDR

Line 3216: FROM fv_facts_footnote_hdr ffh,

3212: FOR footnote_rec IN footnote_select(v_treasury_symbol_id)
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 ;

Line 3228: INSERT INTO fv_facts_footnote_hdr

3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3225: l_module_name,
3226: 'Creating Footnote Records.....');
3227: END IF;
3228: INSERT INTO fv_facts_footnote_hdr
3229: (footnote_header_id,
3230: treasury_symbol_id,
3231: sgl_acct_number)
3232: VALUES

Line 3233: (fv_facts_footnote_hdr_s.nextval,

3229: (footnote_header_id,
3230: treasury_symbol_id,
3231: sgl_acct_number)
3232: VALUES
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

Line 3243: (fv_facts_footnote_hdr_s.currval,

3239: footnote_line_id,
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');