VIEW: APPS.PER_ZA_LEARNERSHIP_AGREEMENT_V

Source

View Text - Preformatted

SELECT la.AGREEMENT_ID, la.NAME, la.DESCRIPTION, la.AGREEMENT_NUMBER, la.PERSON_ID, la.AGREEMENT_START_DATE, la.AGREEMENT_END_DATE, la.STATUS, la.SETA, PER_ZA_UTILITY_PKG.PER_ZA_TABLE_MEANING('ZA_NQF_SETA_INFORMATION', 'ID', la.SETA,pap.BUSINESS_GROUP_ID) SETA_MEANING, la.PROBATIONARY_END_DATE, la.TERMINATED_BY, la.LEARNER_TYPE, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_LEARNER_TYPES', la.LEARNER_TYPE) LEARNER_TYPE_MEANING, la.REASON_FOR_TERMINATION, la.ACTUAL_END_DATE, la.AGREEMENT_HARD_COPY_ID FROM PER_ZA_LEARNERSHIP_AGREEMENTS la, PER_ALL_PEOPLE pap WHERE la.PERSON_ID = pap.PERSON_ID

View Text - HTML Formatted

SELECT LA.AGREEMENT_ID
, LA.NAME
, LA.DESCRIPTION
, LA.AGREEMENT_NUMBER
, LA.PERSON_ID
, LA.AGREEMENT_START_DATE
, LA.AGREEMENT_END_DATE
, LA.STATUS
, LA.SETA
, PER_ZA_UTILITY_PKG.PER_ZA_TABLE_MEANING('ZA_NQF_SETA_INFORMATION'
, 'ID'
, LA.SETA
, PAP.BUSINESS_GROUP_ID) SETA_MEANING
, LA.PROBATIONARY_END_DATE
, LA.TERMINATED_BY
, LA.LEARNER_TYPE
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_LEARNER_TYPES'
, LA.LEARNER_TYPE) LEARNER_TYPE_MEANING
, LA.REASON_FOR_TERMINATION
, LA.ACTUAL_END_DATE
, LA.AGREEMENT_HARD_COPY_ID
FROM PER_ZA_LEARNERSHIP_AGREEMENTS LA
, PER_ALL_PEOPLE PAP
WHERE LA.PERSON_ID = PAP.PERSON_ID