APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_SUBMISSION_S

Line 258: fv_facts_submission.Set_Of_Books_Id ,

254: l_counter NUMBER := 1;
255: l_flag NUMBER;
256: CURSOR facts_record IS
257: SELECT fv_facts_submission.rowid,
258: fv_facts_submission.Set_Of_Books_Id ,
259: fv_facts_submission.Run_Mode,
260: fv_treasury_symbols.Treasury_Symbol,
261: fv_facts_submission.rep_fyr ,
262: fv_facts_submission.rep_period_num,

Line 270: fv_facts_submission.supervisor_name ,

266: fv_facts_submission.phone_ext,
267: fv_facts_submission.email_address,
268: fv_facts_submission.fax_num ,
269: fv_facts_submission.mothers_m_name ,
270: fv_facts_submission.supervisor_name ,
271: fv_facts_submission.supervisor_phone,
272: fv_facts_submission.supervisor_ext ,
273: fv_facts_submission.agency_name_1 ,
274: fv_facts_submission.agency_name_2 ,

Line 271: fv_facts_submission.supervisor_phone,

267: fv_facts_submission.email_address,
268: fv_facts_submission.fax_num ,
269: fv_facts_submission.mothers_m_name ,
270: fv_facts_submission.supervisor_name ,
271: fv_facts_submission.supervisor_phone,
272: fv_facts_submission.supervisor_ext ,
273: fv_facts_submission.agency_name_1 ,
274: fv_facts_submission.agency_name_2 ,
275: fv_facts_submission.address_1 ,

Line 272: fv_facts_submission.supervisor_ext ,

268: fv_facts_submission.fax_num ,
269: fv_facts_submission.mothers_m_name ,
270: fv_facts_submission.supervisor_name ,
271: fv_facts_submission.supervisor_phone,
272: fv_facts_submission.supervisor_ext ,
273: fv_facts_submission.agency_name_1 ,
274: fv_facts_submission.agency_name_2 ,
275: fv_facts_submission.address_1 ,
276: fv_facts_submission.address_2 ,

Line 278: fv_facts_submission.state ,

274: fv_facts_submission.agency_name_2 ,
275: fv_facts_submission.address_1 ,
276: fv_facts_submission.address_2 ,
277: fv_facts_submission.city ,
278: fv_facts_submission.state ,
279: fv_facts_submission.zip ,
280: fv_facts_submission.currency_code,
281: fv_facts_submission.treasury_symbol_id
282: FROM fv_facts_submission ,

Line 286: AND fv_facts_submission.set_of_books_id = sob

282: FROM fv_facts_submission ,
283: fv_treasury_symbols
284: WHERE submit_flag = 'Y'
285: AND fv_treasury_symbols.set_of_books_id = sob
286: AND fv_facts_submission.set_of_books_id = sob
287: AND fv_facts_submission.treasury_symbol_id =
288: fv_treasury_symbols.treasury_symbol_id;
289:
290:

Line 5223: SELECT fv_facts_submission_s.nextval

5219: BEGIN
5220: l_module_name := g_module_name || 'create_bulk_file';
5221: sob := p_ledger_id;
5222: -- get the sequence number
5223: SELECT fv_facts_submission_s.nextval
5224: INTO v3_req_id
5225: FROM DUAL;
5226:
5227: UPDATE fv_facts_submission