APPS.FV_GTAS_TRX_REGISTER dependencies on FV_PYA_FISCALYEAR_MAP

Line 1156: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%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;
1160: select_stmt VARCHAR2(10000);

Line 1418: FROM fv_pya_fiscalyear_map

1414: If l_New_or_Bal_flag = 'Y' THEN
1415: BEGIN
1416: SELECT fyr_segment_value
1417: INTO vl_fyr_segment_value
1418: FROM fv_pya_fiscalyear_map
1419: Where Period_Year = g_period_year
1420: AND set_of_books_id = g_set_of_books_id;
1421: EXCEPTION
1422: WHEN NO_DATA_FOUND THEN

Line 1538: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;

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;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;