View: PER_ZA_LEARNERSHIP_AGREEMENT_V

Product:	PER - Human Resources
Description:	PER_ZA_LEARNERSHIP_AGREEMENT_V is used to maintain table PER_ZA_LEARNERSHIP_AGREEMENTS via NQF forms.
Implementation/DBA Data:	APPS.PER_ZA_LEARNERSHIP_AGREEMENT_V

View Text

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

Columns