168: l_mapping_id number;
169: l_mapping_name varchar2(600);
170: l_mapping_id1 number;
171: l_mapping_name1 varchar2(600);
172: l_mapping_column_name1 pqh_attributes.attribute_name%type;
173: l_mapping_column_name2 pqh_attributes.attribute_name%type;
174:
175: l_input_value_name pay_input_values_f.name%type;
176:
169: l_mapping_name varchar2(600);
170: l_mapping_id1 number;
171: l_mapping_name1 varchar2(600);
172: l_mapping_column_name1 pqh_attributes.attribute_name%type;
173: l_mapping_column_name2 pqh_attributes.attribute_name%type;
174:
175: l_input_value_name pay_input_values_f.name%type;
176:
177: l_abr_acty_base_rt_esd ben_acty_base_rt_f.effective_start_date%type;
4255: and pdb.defined_balance_id = p_defined_balance_id ;
4256: --
4257: l_mapping_defined_balance_id number;
4258: l_mapping_defined_balance_name varchar2(600);
4259: l_mapping_column_name1 pqh_attributes.attribute_name%type;
4260: l_mapping_column_name2 pqh_attributes.attribute_name%type;
4261: l_information172 varchar2(300);
4262: --
4263: /*
4256: --
4257: l_mapping_defined_balance_id number;
4258: l_mapping_defined_balance_name varchar2(600);
4259: l_mapping_column_name1 pqh_attributes.attribute_name%type;
4260: l_mapping_column_name2 pqh_attributes.attribute_name%type;
4261: l_information172 varchar2(300);
4262: --
4263: /*
4264: -- added by sgoyal
5709: l_mapping_id number;
5710: l_mapping_name varchar2(600);
5711: l_mapping_id1 number;
5712: l_mapping_name1 varchar2(600);
5713: l_mapping_column_name1 pqh_attributes.attribute_name%type;
5714: l_mapping_column_name2 pqh_attributes.attribute_name%type;
5715:
5716: ---------------------------------------------------------------
5717: -- START OF BEN_VRBL_RT_PRFL_F ----------------------
5710: l_mapping_name varchar2(600);
5711: l_mapping_id1 number;
5712: l_mapping_name1 varchar2(600);
5713: l_mapping_column_name1 pqh_attributes.attribute_name%type;
5714: l_mapping_column_name2 pqh_attributes.attribute_name%type;
5715:
5716: ---------------------------------------------------------------
5717: -- START OF BEN_VRBL_RT_PRFL_F ----------------------
5718: ---------------------------------------------------------------