APPS.HRI_OLTP_DISC_PROFICIENCY SQL Statements

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

Line: 88

Description   : Function to chech whether the given competence has been updates
                by an appraisal
Preconditions : None
In Parameters : p_competence_id  IN NUMBER
                p_appraisal_id IN NUMBER,
		p_person_id IN NUMBER
Post Sucess   : Returns the 'Y' If the competence being updated by appraisal
                else returns 'N'
Post Failure  : 'NULL'
***************************************************************************/
--
FUNCTION get_competence_appraisal_flag(p_competence_id  IN NUMBER,
                                       p_appraisal_id IN NUMBER,
				       p_person_id IN NUMBER)
RETURN VARCHAR2
IS
--
  l_flag varchar2(5);