APPS.FV_GTAS_TRX_REGISTER dependencies on FV_PYA_FISCALYEAR_SEGMENT

Line 1155: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;

1151: l_c_nc fv_fund_parameters.cust_non_cust%type;
1152: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1153: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1154: l_Financing_Account fv_Treasury_symbols.financing_account%type;
1155: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
1156: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
1157: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
1158: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
1159: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;

Line 1391: FROM fv_pya_fiscalyear_segment

1387:
1388: If l_Financing_Account ='D' Or l_Financing_Account = 'G' Then
1389: SELECT cohort_segment_name
1390: INTO l_cohort_seg_name
1391: FROM fv_pya_fiscalyear_segment
1392: Where Set_Of_Books_Id = g_set_of_books_id;
1393:
1394: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||'
1395: from gl_code_combinations

Line 1537: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;

1533: l_period_year NUMBER(15);
1534: l_cohort_year VARCHAR2(10);
1535:
1536: l_cohort_select VARCHAR2(100) ;
1537: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
1538: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
1539: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;

Line 1697: FROM fv_pya_fiscalyear_segment

1693: Begin
1694:
1695: SELECT application_column_name
1696: INTO l_fyr_segment_name
1697: FROM fv_pya_fiscalyear_segment
1698: WHERE set_of_books_id = g_set_of_books_id;
1699:
1700: log(l_module, 'Fiscal Yr Seg: '||L_FYR_SEGMENT_NAME);
1701:

Line 4803: FROM FV_PYA_FISCALYEAR_SEGMENT fpfs

4799: log(l_module, 'Begin');
4800:
4801: SELECT fpfs.cohort_segment_name
4802: INTO g_cohort_seg_name
4803: FROM FV_PYA_FISCALYEAR_SEGMENT fpfs
4804: WHERE fpfs.set_of_books_id = g_set_of_books_id;
4805:
4806: log(l_module, 'End');
4807:

Line 4815: FV_PYA_FISCALYEAR_SEGMENT fpfs

4811: INTO l_financing_acct,
4812: g_cohort_seg_name
4813: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
4814: FV_TREASURY_SYMBOLS FTS,
4815: FV_PYA_FISCALYEAR_SEGMENT fpfs
4816: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
4817: AND FTS.treasury_symbol_id = g_treasury_symbol_id
4818: AND FTS.set_of_books_id = g_set_of_books_id
4819: AND fpfs.set_of_books_id = g_set_of_books_id