VIEW: APPS.IGWBV_GRNT_PRPSL_BDGT_LIN_PERS

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, PERS_DTLS.VERSION_ID, 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.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 WHERE PR.proposal_id = PERS_DTLS.proposal_id and LKUP1.lookup_code = PERS_DTLS.PERIOD_TYPE_CODE and LKUP1.lookup_type = 'IGW_PERIOD_TYPES' with read only

View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, PERS_DTLS.VERSION_ID
, 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.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
WHERE PR.PROPOSAL_ID = PERS_DTLS.PROPOSAL_ID
AND LKUP1.LOOKUP_CODE = PERS_DTLS.PERIOD_TYPE_CODE
AND LKUP1.LOOKUP_TYPE = 'IGW_PERIOD_TYPES' WITH READ ONLY