Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds the System Award Year Mapping details |
Implementation/DBA Data: | APPS.IGFFV_BATCH_YEAR_SETUPS |
SELECT '_LA:BAM.SYS_AWARD_YEAR:IGF_LOOKUPS_VIEW:IGF_AW_SYSTEM_AWARD_YEAR:MEANING'
, '_LA:BAM.AWARD_YEAR_STATUS_CODE:IGF_LOOKUPS_VIEW:IGF_AWARD_YEAR_STATUS:MEANING'
, BAM.NUM_DAYS_DIVISOR
, '_LA:BAM.ROUNDOFF_FACT:IGF_LOOKUPS_VIEW:IGF_AP_EFC_ROUND_FACT:MEANING'
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, BAM.CI_CAL_TYPE
, BAM.CI_SEQUENCE_NUMBER
, '_LA:BAM.PUBLISH_IN_SS_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, BAM.BAM_ID
, BAM.CREATED_BY
, BAM.CREATION_DATE
, BAM.LAST_UPDATED_BY
, BAM.LAST_UPDATE_DATE
FROM IGF_AP_BATCH_AW_MAP_ALL BAM
, IGS_CA_INST_ALL CI
WHERE CI.CAL_TYPE = BAM.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER = BAM.CI_SEQUENCE_NUMBER WITH READ ONLY