eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGWFV_GRNT_PRPSL_BDGT_LIN_PERS

Product:	IGW - Grants Proposal
Description:
Implementation/DBA Data:	APPS.IGWFV_GRNT_PRPSL_BDGT_LIN_PERS

View Text

SELECT PR.PROPOSAL_NUMBER
, PAPF.FULL_NAME
, PERS_DTLS.START_DATE
, PERS_DTLS.END_DATE
, PERS_DTLS.PERIOD_TYPE_CODE
, '_LA:APPOINTMENT_TYPE_CODE:IGW_LOOKUPS_V:IGW_APPOINTMENT_TYPE:MEANING'
, PERS_DTLS.SALARY_REQUESTED
, PERS_DTLS.PERCENT_CHARGED
, PERS_DTLS.PERCENT_EFFORT
, PERS_DTLS.COST_SHARING_PERCENT
, PERS_DTLS.COST_SHARING_AMOUNT
, PERS_DTLS.UNDERRECOVERY_AMOUNT
, PERS_DTLS.BUDGET_PERSONNEL_DETAIL_ID
, PR.PROPOSAL_ID
, PERS_DTLS.VERSION_ID
, PERS_DTLS.BUDGET_PERIOD_ID
, PERS_DTLS.LINE_ITEM_ID
, PERS_DTLS.PERSON_ID
, PERS_DTLS.LAST_UPDATE_DATE
, PERS_DTLS.LAST_UPDATED_BY
, PERS_DTLS.CREATION_DATE
, PERS_DTLS.CREATED_BY
FROM IGW_BUDGET_PERSONNEL_DETAILS PERS_DTLS
, IGW_PROPOSALS_ALL PR
, IGW_LOOKUPS_V LKUP1
, PER_ALL_PEOPLE_F PAPF
WHERE PR.PROPOSAL_ID = PERS_DTLS.PROPOSAL_ID
AND LKUP1.LOOKUP_CODE = PERS_DTLS.PERIOD_TYPE_CODE
AND LKUP1.LOOKUP_TYPE = 'IGW_PERIOD_TYPES'
AND PAPF.PERSON_ID = PERS_DTLS.PERSON_ID
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE WITH READ ONLY

Columns

Name
PROPOSAL_NUMBER
PERSON_FULL_NAME
START_DATE
END_DATE
BUDGET_PERSON_PERIOD_TYPE
"_LA:APPOINTMENT_TYPE"
SALARY_REQUESTED
AMOUNT_CHARGED_PERCENT
EFFORT_PERCENT
COST_SHARING_PERCENT
COST_SHARING_AMOUNT
UNDERRECOVERY_AMOUNT
BUDGET_PERSONNEL_DETAIL_ID
PROPOSAL_ID
VERSION_ID
BUDGET_PERIOD_ID
LINE_ITEM_ID
PERSON_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY