DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FV_PYA_FISCALYEAR_SEGMENT

Line 854: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%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;
858: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;

Line 1043: FROM fv_pya_fiscalyear_segment

1039: Begin
1040:
1041: SELECT application_column_name
1042: INTO l_fyr_segment_name
1043: FROM fv_pya_fiscalyear_segment
1044: WHERE set_of_books_id = g_set_of_books_id;
1045:
1046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FISCAL YR SEGMENT '||L_FYR_SEGMENT_NAME);

Line 5114: FV_PYA_FISCALYEAR_SEGMENT fpfs

5110: INTO l_financing_acct,
5111: g_cohort_seg_name
5112: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
5113: FV_TREASURY_SYMBOLS FTS,
5114: FV_PYA_FISCALYEAR_SEGMENT fpfs
5115: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
5116: AND FTS.treasury_symbol_id = g_treasury_symbol_id
5117: AND FTS.set_of_books_id = g_set_of_books_id
5118: AND fpfs.set_of_books_id = g_set_of_books_id