DBA Data[Home] [Help]

APPS.FV_SLA_PO_PROCESSING_PKG dependencies on FV_TREASURY_SYMBOLS

Line 140: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

136: l_account_value VARCHAR2(30);
137: l_bfy_value VARCHAR2(30);
138: l_fund_category fv_fund_parameters.fund_category%TYPE;
139: l_fund_time_frame fv_fund_parameters.fund_time_frame%TYPE;
140: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
142: l_fund_expired_status VARCHAR2(30);
143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;
144: l_unreserv_data_exists BOOLEAN := FALSE;

Line 141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;

137: l_bfy_value VARCHAR2(30);
138: l_fund_category fv_fund_parameters.fund_category%TYPE;
139: l_fund_time_frame fv_fund_parameters.fund_time_frame%TYPE;
140: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
142: l_fund_expired_status VARCHAR2(30);
143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;
144: l_unreserv_data_exists BOOLEAN := FALSE;
145: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;

Line 145: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;

141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
142: l_fund_expired_status VARCHAR2(30);
143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;
144: l_unreserv_data_exists BOOLEAN := FALSE;
145: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
146: l_sign NUMBER;
147:
148: BEGIN
149: l_procedure_name := g_path_name || l_procedure_name;

Line 435: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;

431: l_bfy_value VARCHAR2(30);
432: l_index NUMBER;
433: l_conversion_rate NUMBER;
434: l_sign NUMBER;
435: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;

Line 440: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;

436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;
440: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
441: l_pya_data_exists BOOLEAN := FALSE;
442:
443: BEGIN
444: l_procedure_name := g_path_name || l_procedure_name;