DBA Data[Home] [Help]

APPS.PER_ZA_LSA_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 76

    select
        AGREEMENT_ID,
   		NAME,
   		DESCRIPTION,
   		AGREEMENT_NUMBER,
   		PERSON_ID,
   		AGREEMENT_START_DATE,
   		AGREEMENT_END_DATE,
   		STATUS,
   		SETA,
   		PROBATIONARY_END_DATE,
   		TERMINATED_BY,
   		LEARNER_TYPE,
   		REASON_FOR_TERMINATION,
   		ACTUAL_END_DATE,
   		AGREEMENT_HARD_COPY_ID,
   		LAST_UPDATE_DATE,
   		LAST_UPDATED_BY,
   		LAST_UPDATE_LOGIN,
   		CREATED_BY,
   		CREATION_DATE
	from
    	per_za_learnership_agreements
    where
    	agreement_id = p_agreement_id
    for	update nowait;