Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PER.TEMPLATE_ID
, PER.TEMPLATE_NAME
, PER.PERSON_ID
, PER.EFFECTIVE_START_DATE
, PER.SET_OF_BOOKS_ID
, GL.NAME
, PER.BUSINESS_GROUP_ID
, HOU.NAME
, PER.EFFECTIVE_END_DATE
, PER.BEGIN_DATE
, PER.PROJECT_TYPE_CLASS_CODE
, PER.PROJECT_TYPE
, PER.END_DATE
, PER.AWARD_TYPE
, PER.FUNDING_SOURCE_ID
, '_LA:ENABLE_WORKFLOW_FLAG:PSP_LOOKUPS:PSP_ENABLE_WORKFLOW_FLAG:MEANING'
, '_LA:USER_TEMPLATE_FLAG:PSP_LOOKUPS:PSP_USER_TEMPLATE_FLAG:MEANING'
, '_LA:REPORT_TYPE:PSP_LOOKUPS:PSP_REPORT_TYPE:MEANING'
, PER.REPORT_INITIATOR_ID
, PER.INITIATOR_APPS_NAME
, PER.ERROR_DATE_TIME
, PER.EFFORT_REPORT_PERIOD_NAME
, PER.PEOPLE_GROUP_ID
, PPG.GROUP_NAME
, PER.SUPERVISOR_ID
, PER.ELEMENT_TYPE_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PER.TASK_ID
, PAT.TASK_NAME
, PER.EXPENDITURE_TYPE
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATED_BY
, PER.CREATION_DATE
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PRP.START_DATE_ACTIVE
, PRP.END_DATE_ACTIVE
, PP1.FIRST_NAME
, PP1.LAST_NAME
, PET.ELEMENT_NAME
FROM PSP_EFFORT_REPORT_TEMPLATES PER
, PSP_EFFORT_REPORT_PERIODS PRP
, PER_ALL_PEOPLE_F PPF
, PER_PEOPLE_F PP1
, PAY_ELEMENT_TYPES_F PET
, PAY_PEOPLE_GROUPS PPG
, PA_TASKS PAT
, GL_CODE_COMBINATIONS GCC
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE PER.EFFORT_REPORT_PERIOD_NAME = PRP.EFFORT_REPORT_PERIOD_NAME(+)
AND (PER.PERSON_ID = PPF.PERSON_ID(+)
AND PER.EFFECTIVE_START_DATE = PPF.EFFECTIVE_START_DATE(+))
AND (PER.SUPERVISOR_ID = PP1.PERSON_ID(+)
AND PER.EFFECTIVE_START_DATE BETWEEN PP1.EFFECTIVE_START_DATE
AND PP1.EFFECTIVE_END_DATE)
AND (PER.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID(+)
AND PER.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE)
AND PER.PEOPLE_GROUP_ID=PPG.PEOPLE_GROUP_ID(+)
AND PER.TASK_ID=PAT.TASK_ID(+)
AND PER.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID(+)
AND PER.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID
AND PER.BUSINESS_GROUP_ID=HOU.ORGANIZATION_ID WITH READ ONLY