VIEW: APPS.IGFFV_STUDENT_PAYROLL_DETAILS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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