Product: | IGF - Financial Aid |
---|---|
Description: | The entity holds the payroll details that will be uploaded through a payment upload process. Data source for this will be the interface table .. User can also manually enter or update external payroll details. |
Implementation/DBA Data: | APPS.IGF_SE_PAYMENT_V |
SELECT SEP. ROWID ROW_ID
, SEP. TRANSACTION_ID
, SEP. PAYROLL_ID
, SEP. PAYROLL_DATE
, SEP. PERSON_ID
, SEP. FUND_ID
, SEP. AUTH_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, SEP. PAID_AMOUNT
, NULL
, SEP. ORG_UNIT_CD
, SEP.SOURCE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SE_SOURCE'
, SEP.SOURCE) SOURCE_DESCRIPTION
, SEP. CREATED_BY
, SEP. CREATION_DATE
, SEP. LAST_UPDATED_BY
, SEP. LAST_UPDATE_DATE
, SEP. LAST_UPDATE_LOGIN
, SEP.REQUEST_ID
, SEP. PROGRAM_APPLICATION_ID
, SEP.PROGRAM_ID
, SEP. PROGRAM_UPDATE_DATE
FROM IGF_SE_PAYMENT SEP