DBA Data[Home] [Help]

APPS.JA_CN_CUSTOM_SOURCES dependencies on PA_PROJECTS_ALL

Line 573: project_num PA_PROJECTS_ALL.Segment1%type:=null;

569: --===========================================================================
570:
571: FUNCTION GET_PROJECT_NUM(Project_id IN NUMBER)
572: RETURN VARCHAR2 IS
573: project_num PA_PROJECTS_ALL.Segment1%type:=null;
574: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
575: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
576: l_proc_name VARCHAR2(100) :='GET_PROJECT_NUM';
577: BEGIN

Line 598: FROM PA_PROJECTS_ALL

594: RETURN NULL;
595: ELSE
596: SELECT SEGMENT1
597: INTO project_num
598: FROM PA_PROJECTS_ALL
599: WHERE PROJECT_ID = Project_id;
600:
601: RETURN project_num;
602: END IF;