DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FV_PYA_FISCALYEAR_SEGMENT

Line 822: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;

818: l_cohort_select VARCHAR2(100) ;
819: l_cohort VARCHAR2(2) ;
820: l_cohort_num_year NUMBER;
821: l_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
822: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
823: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
824: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
825: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
826: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;

Line 1001: FROM fv_pya_fiscalyear_segment

997: Begin
998:
999: SELECT application_column_name
1000: INTO l_fyr_segment_name
1001: FROM fv_pya_fiscalyear_segment
1002: WHERE set_of_books_id = g_set_of_books_id;
1003:
1004: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1005: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FISCAL YR SEGMENT '||L_FYR_SEGMENT_NAME);