Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AP_EFC_V |
SELECT BAM.ROWID
, BAM.CI_CAL_TYPE
, BAM.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, BAM.EFC_FRML
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_EFC_FRML'
, BAM.EFC_FRML)
, BAM.NUM_DAYS_DIVISOR
, BAM.ROUNDOFF_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_EFC_ROUND_FACT'
, BAM.ROUNDOFF_FACT)
, BAM.CREATED_BY
, BAM.CREATION_DATE
, BAM.LAST_UPDATED_BY
, BAM.LAST_UPDATE_DATE
, BAM.LAST_UPDATE_LOGIN
FROM IGF_AP_BATCH_AW_MAP BAM
, IGS_CA_INST CI
WHERE BAM.CI_CAL_TYPE = CI.CAL_TYPE
AND BAM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER