VIEW: APPS.PERBV_CN_SPEC_INFO_V

Source

View Text - Preformatted

SELECT ffs.id_flex_structure_code, ffs.ID_FLEX_STRUCTURE_NAME, ffs.DESCRIPTION, ppa.person_analysis_id, paf.person_id, paf.full_name, paf.employee_number , paf.business_group_id , ppa.date_from start_date, ppa.date_to end_date, pac.segment1, pac.segment2, pac.segment3, pac.segment4, pac.segment5, pac.segment6, pac.segment7, pac.segment8,pac.segment9,pac.segment10, pac.segment11, pac.segment12,pac.segment13,pac.segment14, pac.segment15, pac.segment16,pac.segment17,pac.segment18,pac.segment19, pac.segment20,pac.segment21,pac.segment22,pac.segment23, pac.segment24,pac.segment25,pac.segment26,pac.segment27, pac.segment28,pac.segment29,pac.segment30 FROM per_person_analyses ppa, per_analysis_criteria pac, per_people_f paf, fnd_id_flex_structures_vl ffs, per_business_groups pbg WHERE ppa.person_id = paf.person_id AND ffs.ID_FLEX_NUM = ppa.id_flex_num AND ppa.date_from BETWEEN paf.effective_start_date AND paf.effective_end_date AND ppa.analysis_criteria_id = pac.analysis_criteria_id AND ppa.business_group_id = pbg.business_group_id WITH READ ONLY

View Text - HTML Formatted

SELECT FFS.ID_FLEX_STRUCTURE_CODE
, FFS.ID_FLEX_STRUCTURE_NAME
, FFS.DESCRIPTION
, PPA.PERSON_ANALYSIS_ID
, PAF.PERSON_ID
, PAF.FULL_NAME
, PAF.EMPLOYEE_NUMBER
, PAF.BUSINESS_GROUP_ID
, PPA.DATE_FROM START_DATE
, PPA.DATE_TO END_DATE
, PAC.SEGMENT1
, PAC.SEGMENT2
, PAC.SEGMENT3
, PAC.SEGMENT4
, PAC.SEGMENT5
, PAC.SEGMENT6
, PAC.SEGMENT7
, PAC.SEGMENT8
, PAC.SEGMENT9
, PAC.SEGMENT10
, PAC.SEGMENT11
, PAC.SEGMENT12
, PAC.SEGMENT13
, PAC.SEGMENT14
, PAC.SEGMENT15
, PAC.SEGMENT16
, PAC.SEGMENT17
, PAC.SEGMENT18
, PAC.SEGMENT19
, PAC.SEGMENT20
, PAC.SEGMENT21
, PAC.SEGMENT22
, PAC.SEGMENT23
, PAC.SEGMENT24
, PAC.SEGMENT25
, PAC.SEGMENT26
, PAC.SEGMENT27
, PAC.SEGMENT28
, PAC.SEGMENT29
, PAC.SEGMENT30
FROM PER_PERSON_ANALYSES PPA
, PER_ANALYSIS_CRITERIA PAC
, PER_PEOPLE_F PAF
, FND_ID_FLEX_STRUCTURES_VL FFS
, PER_BUSINESS_GROUPS PBG
WHERE PPA.PERSON_ID = PAF.PERSON_ID
AND FFS.ID_FLEX_NUM = PPA.ID_FLEX_NUM
AND PPA.DATE_FROM BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPA.ANALYSIS_CRITERIA_ID = PAC.ANALYSIS_CRITERIA_ID
AND PPA.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID WITH READ ONLY