VIEW: APPS.IGWFV_GRNT_PRPSL_BDGT_LIN_PERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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