APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_SUBMISSION_S

Line 268: fv_facts_submission.Set_Of_Books_Id ,

264:
265: -- CGAC: Report only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is I or II or both
266: CURSOR facts_record IS
267: SELECT fv_facts_submission.rowid,
268: fv_facts_submission.Set_Of_Books_Id ,
269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,

Line 280: fv_facts_submission.supervisor_name ,

276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,

Line 281: fv_facts_submission.supervisor_phone,

277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,

Line 282: fv_facts_submission.supervisor_ext ,

278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,

Line 288: fv_facts_submission.state ,

284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,

Line 296: AND fv_facts_submission.set_of_books_id = sob

292: FROM fv_facts_submission ,
293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =
298: fv_treasury_symbols.treasury_symbol_id
299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR
300: fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'I and II');

Line 5299: SELECT fv_facts_submission_s.nextval

5295: BEGIN
5296: l_module_name := g_module_name || 'create_bulk_file';
5297: sob := p_ledger_id;
5298: -- get the sequence number
5299: SELECT fv_facts_submission_s.nextval
5300: INTO v3_req_id
5301: FROM DUAL;
5302:
5303: UPDATE fv_facts_submission