APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_PRC_HDR

Line 287: FROM fv_facts_prc_hdr

283: -- been done for set of books. If not, then write error
284: -- message and exit process.
285: SELECT count(*)
286: INTO l_prc_map_count
287: FROM fv_facts_prc_hdr
288: WHERE set_of_books_id = g_set_of_books_id;
289:
290: IF l_prc_map_count = 0 THEN
291: g_error_code := -1;

Line 5164: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;

5160: WHERE ffp.treasury_symbol_id = g_treasury_symbol_id
5161: AND ffp.set_of_books_id = g_set_of_books_id
5162: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
5163:
5164: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
5165: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
5166: vl_prc_header_id NUMBER;
5167: vl_status VARCHAR2(10);
5168: l_code_type VARCHAR2(1);

Line 5165: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

5161: AND ffp.set_of_books_id = g_set_of_books_id
5162: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
5163:
5164: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
5165: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
5166: vl_prc_header_id NUMBER;
5167: vl_status VARCHAR2(10);
5168: l_code_type VARCHAR2(1);
5169:

Line 5196: FROM fv_facts_prc_hdr ffh

5192: BEGIN
5193: SELECT program_segment,
5194: prc_mapping_flag, prc_header_id
5195: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5196: FROM fv_facts_prc_hdr ffh
5197: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
5198: AND ffh.set_of_books_id = g_set_of_books_id
5199: AND ffh.code_type = l_code_type
5200: AND ffh.fund_value = fund_rec.fund_value;

Line 5210: FROM fv_facts_prc_hdr ffh

5206: BEGIN
5207: SELECT program_segment,
5208: prc_mapping_flag, prc_header_id
5209: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5210: FROM fv_facts_prc_hdr ffh
5211: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
5212: AND ffh.set_of_books_id = g_set_of_books_id
5213: AND ffh.code_type = l_code_type
5214: AND ffh.fund_value = 'ALL-A'

Line 5225: FROM fv_facts_prc_hdr ffh

5221: BEGIN
5222: SELECT program_segment,
5223: prc_mapping_flag, prc_header_id
5224: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5225: FROM fv_facts_prc_hdr ffh
5226: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
5227: AND ffh.set_of_books_id = g_set_of_books_id
5228: AND ffh.code_type = l_code_type
5229: AND ffh.fund_value = 'ALL-B'

Line 5240: FROM fv_facts_prc_hdr ffh

5236: BEGIN
5237: SELECT program_segment,
5238: prc_mapping_flag, prc_header_id
5239: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5240: FROM fv_facts_prc_hdr ffh
5241: WHERE ffh.treasury_symbol_id = g_treasury_symbol_id
5242: AND ffh.set_of_books_id = g_set_of_books_id
5243: AND ffh.code_type = l_code_type
5244: AND ffh.fund_value = 'ALL-FUNDS';

Line 5254: FROM fv_facts_prc_hdr ffh

5250: BEGIN
5251: SELECT program_segment,
5252: prc_mapping_flag, prc_header_id
5253: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5254: FROM fv_facts_prc_hdr ffh
5255: WHERE ffh.treasury_symbol_id = -1
5256: AND ffh.set_of_books_id = g_set_of_books_id
5257: AND ffh.code_type = l_code_type
5258: AND ffh.fund_value = 'ALL-A'

Line 5269: FROM fv_facts_prc_hdr ffh

5265: BEGIN
5266: SELECT program_segment,
5267: prc_mapping_flag, prc_header_id
5268: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5269: FROM fv_facts_prc_hdr ffh
5270: WHERE ffh.treasury_symbol_id = -1
5271: AND ffh.set_of_books_id = g_set_of_books_id
5272: AND ffh.code_type = l_code_type
5273: AND ffh.fund_value = 'ALL-B'

Line 5284: FROM fv_facts_prc_hdr ffh

5280: BEGIN
5281: SELECT program_segment,
5282: prc_mapping_flag, prc_header_id
5283: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5284: FROM fv_facts_prc_hdr ffh
5285: WHERE ffh.treasury_symbol_id = -1
5286: AND ffh.set_of_books_id = g_set_of_books_id
5287: AND ffh.code_type = l_code_type
5288: AND ffh.fund_value = 'ALL-FUNDS';