165: and p_effective_date between effective_start_date and effective_end_date;
166:
167: l_mapping_id number;
168: l_mapping_name varchar2(600);
169: l_mapping_column_name1 pqh_attributes.attribute_name%type;
170: l_mapping_column_name2 pqh_attributes.attribute_name%type;
171:
172: -- Mapping end for CWB
173:
166:
167: l_mapping_id number;
168: l_mapping_name varchar2(600);
169: l_mapping_column_name1 pqh_attributes.attribute_name%type;
170: l_mapping_column_name2 pqh_attributes.attribute_name%type;
171:
172: -- Mapping end for CWB
173:
174: l_pln_esd ben_pl_f.effective_start_date%type;
6281:
6282: l_pos_structure_start_date per_pos_structure_versions.date_from%type;
6283: l_mapping_id number;
6284: l_mapping_name varchar2(600);
6285: l_mapping_column_name1 pqh_attributes.attribute_name%type;
6286: l_mapping_column_name2 pqh_attributes.attribute_name%type;
6287: l_information172 varchar2(600);
6288: l_out_enp_result_id number(15);
6289: --
6282: l_pos_structure_start_date per_pos_structure_versions.date_from%type;
6283: l_mapping_id number;
6284: l_mapping_name varchar2(600);
6285: l_mapping_column_name1 pqh_attributes.attribute_name%type;
6286: l_mapping_column_name2 pqh_attributes.attribute_name%type;
6287: l_information172 varchar2(600);
6288: l_out_enp_result_id number(15);
6289: --
6290: ---------------------------------------------------------------
11611: and p_effective_date between effective_start_date and effective_end_date;
11612:
11613: l_mapping_id number;
11614: l_mapping_name varchar2(600);
11615: l_mapping_column_name1 pqh_attributes.attribute_name%type;
11616: l_mapping_column_name2 pqh_attributes.attribute_name%type;
11617:
11618: -- Mapping end for CWB
11619:
11612:
11613: l_mapping_id number;
11614: l_mapping_name varchar2(600);
11615: l_mapping_column_name1 pqh_attributes.attribute_name%type;
11616: l_mapping_column_name2 pqh_attributes.attribute_name%type;
11617:
11618: -- Mapping end for CWB
11619:
11620: l_opt_id number(15);