[Home] [Help]
View: IGW_PRPO_ROLES_DETAILS_V
Product: | IGW - Grants Proposal |
Description: | View displays summary information about personnel included in budget lines |
Implementation/DBA Data: |
APPS.IGW_PRPO_ROLES_DETAILS_V
|
View Text
SELECT COUNT(*) NO_OF_PERSONS
, PPP.PROPOSAL_ROLE_CODE
, DECODE(PPP.PROPOSAL_ROLE_CODE
, 'AM'
, 'PRINCIPAL INVESTIGATOR'
, IGW_REPORT_PROCESSING.GET_PROPOSAL_ROLE(PROPOSAL_ROLE_CODE)) PROPOSAL_ROLE
, SUM(PBP.CALCULATION_BASE) BASE_SALARY
, IBC.BUDGET_CATEGORY_CODE
, PBPD.START_DATE PERIOD_BEGINNING_DATE
, PBPD.END_DATE PERIOD_END_DATE
, SUM(TO_NUMBER(PBP.APPOINTMENT_TYPE_CODE) * PBPD.PERCENT_EFFORT/100) PERSON_MONTHS
, SUM(PBPD.SALARY_REQUESTED) SALARY_REQUESTED
, PBP.PROPOSAL_ID
, IBC.BUDGET_PERIOD_ID FROM IGW_BUDGETS PB
, IGW_BUDGET_CATEGORY_V IBC
, IGW_BUDGET_PERSONNEL_DETAILS PBPD
, IGW_BUDGET_PERSONS PBP
, PER_PEOPLE_X PPX
, IGW_PROP_PERSONS PPP
WHERE PB.PROPOSAL_ID = IBC.PROPOSAL_ID AND PB.FINAL_VERSION_FLAG = 'Y' AND IBC.LINE_ITEM_ID = PBPD.LINE_ITEM_ID AND PB.PROPOSAL_ID = PBPD.PROPOSAL_ID AND PB.PROPOSAL_ID = PBPD.PROPOSAL_ID AND PB.VERSION_ID = PBPD.VERSION_ID AND PBPD.PROPOSAL_ID = PBP.PROPOSAL_ID AND PBPD.VERSION_ID = PBP.VERSION_ID AND PBPD.APPOINTMENT_TYPE_CODE = PBP.APPOINTMENT_TYPE_CODE AND PBPD.PARTY_ID = PBP.PARTY_ID AND PB.PROPOSAL_ID = PPP.PROPOSAL_ID AND PPP.PERSON_PARTY_ID = PBP.PARTY_ID GROUP BY PPP.PROPOSAL_ROLE_CODE
, PBP.CALCULATION_BASE
, IBC.BUDGET_CATEGORY_CODE
, PBP.CALCULATION_BASE
, PBPD.START_DATE
, PBPD.END_DATE
, PBP.PROPOSAL_ID
, IBC.BUDGET_PERIOD_ID
Columns
Name |
NO_OF_PERSONS |
PROPOSAL_ROLE_CODE |
PROPOSAL_ROLE |
BASE_SALARY |
BUDGET_CATEGORY_CODE |
PERIOD_BEGINNING_DATE |
PERIOD_END_DATE |
PERSON_MONTHS |
SALARY_REQUESTED |
PROPOSAL_ID |
BUDGET_PERIOD_ID |