Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Student Payroll Details |
Implementation/DBA Data: | APPS.IGFFV_STUDENT_PAYROLL_DETAILS |
SELECT SEPY.PAYROLL_DATE
, SEPY.LD_CAL_TYPE
, SEPY.LD_SEQUENCE_NUMBER
, SEPY.HRS_WORKED
, SEPY.PAID_AMOUNT
, SEPY.ORG_UNIT_CD
, '_LA:SEPY.SOURCE:IGF_LOOKUPS_VIEW:IGF_SE_SOURCE:MEANING'
, HZ.PARTY_NUMBER
, HZ.PERSON_FIRST_NAME
, HZ.PERSON_LAST_NAME
, HZ.PERSON_MIDDLE_NAME
, FMAST.FUND_CODE
, AWDY.ALTERNATE_CODE
, LOAD.ALTERNATE_CODE
, SEPY.PERSON_ID
, SEPY.FUND_ID
, SEPY.PAYROLL_ID
, SEPY.AUTH_ID
, SEPY.TRANSACTION_ID
, SEPY.CREATED_BY
, SEPY.CREATION_DATE
, SEPY.LAST_UPDATED_BY
, SEPY.LAST_UPDATE_DATE
FROM IGF_AW_FUND_MAST_ALL FMAST
, IGF_SE_PAYMENT SEPY
, IGS_CA_INST_ALL LOAD
, IGS_CA_INST_ALL AWDY
, HZ_PARTIES HZ
WHERE FMAST.FUND_ID = SEPY.FUND_ID
AND FMAST.CI_CAL_TYPE = AWDY.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWDY.SEQUENCE_NUMBER
AND HZ.PARTY_ID = SEPY.PERSON_ID
AND SEPY.LD_CAL_TYPE = LOAD.CAL_TYPE
AND SEPY.LD_SEQUENCE_NUMBER = LOAD.SEQUENCE_NUMBER WITH READ ONLY