APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on PER_POS_STRUCTURE_VERSIONS

Line 6269: PER_POS_STRUCTURE_VERSIONS pov

6265: --
6266: cursor c_get_mapping_name(p_id in number,p_date in date) is
6267: select pos.NAME name
6268: from PER_POSITION_STRUCTURES pos,
6269: PER_POS_STRUCTURE_VERSIONS pov
6270: where pos.business_group_id = p_business_group_id
6271: and POS_STRUCTURE_VERSION_ID = p_id
6272: and pos.POSITION_STRUCTURE_ID = pov.POSITION_STRUCTURE_ID
6273: and p_date between nvl(POV.DATE_FROM, p_date)

Line 6279: from per_pos_structure_versions

6275: --
6276:
6277: cursor c_pos_structure_start_date(c_pos_structure_version_id number) is
6278: select date_from
6279: from per_pos_structure_versions
6280: where pos_structure_version_id = c_pos_structure_version_id;
6281:
6282: l_pos_structure_start_date per_pos_structure_versions.date_from%type;
6283: l_mapping_id number;

Line 6282: l_pos_structure_start_date per_pos_structure_versions.date_from%type;

6278: select date_from
6279: from per_pos_structure_versions
6280: where pos_structure_version_id = c_pos_structure_version_id;
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;