DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on PQH_ATTRIBUTES

Line 169: l_mapping_column_name1 pqh_attributes.attribute_name%type;

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:

Line 170: l_mapping_column_name2 pqh_attributes.attribute_name%type;

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;

Line 6285: l_mapping_column_name1 pqh_attributes.attribute_name%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: --

Line 6286: l_mapping_column_name2 pqh_attributes.attribute_name%type;

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: ---------------------------------------------------------------

Line 11615: l_mapping_column_name1 pqh_attributes.attribute_name%type;

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:

Line 11616: l_mapping_column_name2 pqh_attributes.attribute_name%type;

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);