DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FV_PYA_FISCALYEAR_MAP

Line 853: l_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;

849: l_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
850: l_cohort_select VARCHAR2(100) ;
851: l_cohort VARCHAR2(2) ;
852: l_cohort_num_year NUMBER;
853: l_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
854: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
855: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
856: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
857: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;

Line 855: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;

851: l_cohort VARCHAR2(2) ;
852: l_cohort_num_year NUMBER;
853: l_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
854: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
855: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
856: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
857: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
858: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
859: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;

Line 2969: FROM fv_pya_fiscalyear_map

2965: AND (l_entered_dr <> 0 OR l_entered_cr <> 0) THEN
2966: BEGIN
2967: SELECT fyr_segment_value
2968: INTO l_fyr_segment_value
2969: FROM fv_pya_fiscalyear_map
2970: WHERE period_year = g_period_year
2971: AND set_of_books_id = g_set_of_books_id;
2972:
2973: EXCEPTION