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