APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_PRC_HDR

Line 273: FROM fv_facts_prc_hdr

269: -- been done for set of books. If not, then write error
270: -- message and exit process.
271: SELECT count(*)
272: INTO l_prc_map_count
273: FROM fv_facts_prc_hdr
274: WHERE set_of_books_id = g_set_of_books_id;
275:
276: IF l_prc_map_count = 0 THEN
277: g_error_code := -1;

Line 4885: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;

4881: WHERE ffp.treasury_symbol_id = g_treasury_symbol_id
4882: AND ffp.set_of_books_id = g_set_of_books_id
4883: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4884:
4885: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4886: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4887: vl_prc_header_id NUMBER;
4888: vl_status VARCHAR2(10);
4889: l_code_type VARCHAR2(1);

Line 4886: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

4882: AND ffp.set_of_books_id = g_set_of_books_id
4883: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4884:
4885: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4886: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4887: vl_prc_header_id NUMBER;
4888: vl_status VARCHAR2(10);
4889: l_code_type VARCHAR2(1);
4890:

Line 4917: FROM fv_facts_prc_hdr ffh

4913: BEGIN
4914: SELECT program_segment,
4915: prc_mapping_flag, prc_header_id
4916: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4917: FROM fv_facts_prc_hdr ffh
4918: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
4919: AND ffh.set_of_books_id = g_set_of_books_id
4920: AND ffh.code_type = l_code_type
4921: AND ffh.fund_value = fund_rec.fund_value;

Line 4931: FROM fv_facts_prc_hdr ffh

4927: BEGIN
4928: SELECT program_segment,
4929: prc_mapping_flag, prc_header_id
4930: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4931: FROM fv_facts_prc_hdr ffh
4932: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
4933: AND ffh.set_of_books_id = g_set_of_books_id
4934: AND ffh.code_type = l_code_type
4935: AND ffh.fund_value = 'ALL-A'

Line 4946: FROM fv_facts_prc_hdr ffh

4942: BEGIN
4943: SELECT program_segment,
4944: prc_mapping_flag, prc_header_id
4945: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4946: FROM fv_facts_prc_hdr ffh
4947: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
4948: AND ffh.set_of_books_id = g_set_of_books_id
4949: AND ffh.code_type = l_code_type
4950: AND ffh.fund_value = 'ALL-B'

Line 4961: FROM fv_facts_prc_hdr ffh

4957: BEGIN
4958: SELECT program_segment,
4959: prc_mapping_flag, prc_header_id
4960: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4961: FROM fv_facts_prc_hdr ffh
4962: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
4963: AND ffh.set_of_books_id = g_set_of_books_id
4964: AND ffh.code_type = l_code_type
4965: AND ffh.fund_value = 'ALL-FUNDS';

Line 4975: FROM fv_facts_prc_hdr ffh

4971: BEGIN
4972: SELECT program_segment,
4973: prc_mapping_flag, prc_header_id
4974: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4975: FROM fv_facts_prc_hdr ffh
4976: WHERE ffh.treasury_symbol_id = -1
4977: AND ffh.set_of_books_id = g_set_of_books_id
4978: AND ffh.code_type = l_code_type
4979: AND ffh.fund_value = 'ALL-A'

Line 4990: FROM fv_facts_prc_hdr ffh

4986: BEGIN
4987: SELECT program_segment,
4988: prc_mapping_flag, prc_header_id
4989: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4990: FROM fv_facts_prc_hdr ffh
4991: WHERE ffh.treasury_symbol_id = -1
4992: AND ffh.set_of_books_id = g_set_of_books_id
4993: AND ffh.code_type = l_code_type
4994: AND ffh.fund_value = 'ALL-B'

Line 5005: FROM fv_facts_prc_hdr ffh

5001: BEGIN
5002: SELECT program_segment,
5003: prc_mapping_flag, prc_header_id
5004: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5005: FROM fv_facts_prc_hdr ffh
5006: WHERE ffh.treasury_symbol_id = -1
5007: AND ffh.set_of_books_id = g_set_of_books_id
5008: AND ffh.code_type = l_code_type
5009: AND ffh.fund_value = 'ALL-FUNDS';