APPS.FV_GTAS_INTERFACE dependencies on FV_PYA_FISCALYEAR_SEGMENT

Line 712: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;

708: l_c_nc fv_fund_parameters.cust_non_cust%type;
709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
710: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
711: l_Financing_Account fv_Treasury_symbols.financing_account%type;
712: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
713: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
714: select_stmt VARCHAR2(10000);
715: Vl_Cursor Integer;
716: Vl_Prc_Val Varchar2(4);

Line 1241: FROM fv_pya_fiscalyear_segment

1237:
1238: If l_Financing_Account ='D' Or l_Financing_Account = 'G' Then
1239: SELECT cohort_segment_name
1240: INTO l_cohort_seg_name
1241: FROM fv_pya_fiscalyear_segment
1242: Where Set_Of_Books_Id = Gbl_Set_Of_Books_Id;
1243:
1244: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||
1245: ' from gl_code_combinations where code_combination_id=' || p_ccid;