Product: | IGS - Student System |
---|---|
Description: | Holds Person's Fund Source details |
Implementation/DBA Data: | APPS.IGS_PE_FUND_SOURCE_V |
SELECT FS.ROWID ROW_ID
, FS.FUND_SOURCE_ID
, FS.PERSON_ID
, FS. FUND_SOURCE_CODE
, L1.MEANING FUND_SOURCE_M
, FS.NAME
, FS.AMOUNT
, FS.RELATIONSHIP_CODE
, L2.MEANING RELATIONSHIP_M
, FS.DOCUMENT_IND
, FS.NOTES
, FS.CREATED_BY
, FS.CREATION_DATE
, FS.LAST_UPDATED_BY
, FS.LAST_UPDATE_DATE
, FS.LAST_UPDATE_LOGIN
FROM IGS_PE_FUND_SOURCE FS
, IGS_LOOKUPS_VIEW L1
, FND_LOOKUP_VALUES L2
WHERE FS.FUND_SOURCE_CODE = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'PE_FUND_TYPE'
AND L2.LOOKUP_TYPE(+) = 'PARTY_RELATIONS_TYPE'
AND FS.RELATIONSHIP_CODE = L2.LOOKUP_CODE(+) AND L2.VIEW_APPLICATION_ID(+) = 222
AND L2.LANGUAGE(+) = USERENV('LANG')
AND L2.SECURITY_GROUP_ID(+) = 0