APPS.FV_GTAS_TRX_REGISTER dependencies on FV_FACTS_PRC_DTL

Line 16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;

12: g_cust_non_cust Fv_gtas_Attributes.Cust_Non_Cust1%type;
13: g_DIRECT_OR_REIMB_CODE Fv_gtas_Attributes.Dir_Reimb_Code1%type;
14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;
15: g_APPOR_CAT_B_CODE VARCHAR2(4);
16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;
17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;
18: g_BORR_SRC_CODE Fv_gtas_Attributes.Borrowing_Source1%type;
19: g_NEW_BAL_CODE VARCHAR2(3);
20: g_CUR_SUBSEQUENT_CODE Fv_gtas_Attributes.Cur_Sub_Code1%type;

Line 533: l_prg_val FV_FACTS_PRC_DTL.PROGRAM_VALUE%TYPE;

529:
530: IS
531: Select_Stmt varchar2(100);
532: l_module VARCHAR2(200) := g_module||'Get_Prc_Map_Val';
533: l_prg_val FV_FACTS_PRC_DTL.PROGRAM_VALUE%TYPE;
534: Begin
535:
536: Select_Stmt := 'SELECT ' || p_Segment_Name ||
537: ' from gl_code_combinations

Line 547: From Fv_Facts_Prc_Dtl

543:
544: begin
545: SELECT reporting_code
546: INTO p_prc_val
547: From Fv_Facts_Prc_Dtl
548: WHERE prc_header_id = P_Prc_Header_Id
549: And Program_Value = l_prg_val
550: And Set_Of_Books_Id = G_Set_Of_Books_Id;
551:

Line 559: FROM fv_facts_prc_dtl

555:
556: begin
557: SELECT reporting_code
558: INTO p_prc_val
559: FROM fv_facts_prc_dtl
560: WHERE prc_header_id = P_Prc_Header_Id
561: And Program_Value = 'ALL'
562: And Set_Of_Books_Id = G_Set_Of_Books_Id;
563: exception