APPS.FA_ASSET_VAL_PVT dependencies on GL_LEDGERS

Line 6955: l_bal_seg_col_name gl_ledgers.bal_seg_column_name%type;

6951: p_ledger_id IN NUMBER,
6952: p_validation_date IN DATE,
6953: p_calling_fn IN VARCHAR2,
6954: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6955: l_bal_seg_col_name gl_ledgers.bal_seg_column_name%type;
6956: l_bal_seg_value_option_code gl_ledgers.bal_seg_value_option_code%type;
6957: query_str VARCHAR2(1000);
6958: l_valid varchar2(1) := 'N';
6959: l_validation_date DATE;

Line 6956: l_bal_seg_value_option_code gl_ledgers.bal_seg_value_option_code%type;

6952: p_validation_date IN DATE,
6953: p_calling_fn IN VARCHAR2,
6954: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6955: l_bal_seg_col_name gl_ledgers.bal_seg_column_name%type;
6956: l_bal_seg_value_option_code gl_ledgers.bal_seg_value_option_code%type;
6957: query_str VARCHAR2(1000);
6958: l_valid varchar2(1) := 'N';
6959: l_validation_date DATE;
6960: BEGIN

Line 6963: FROM gl_ledgers

6959: l_validation_date DATE;
6960: BEGIN
6961: SELECT bal_seg_value_option_code,bal_seg_column_name
6962: INTO l_bal_seg_value_option_code,l_bal_seg_col_name
6963: FROM gl_ledgers
6964: WHERE ledger_id = p_ledger_id;
6965:
6966: if ( nvl(l_bal_seg_value_option_code,'A') <> 'A' ) then
6967: if p_validation_date is null then