APPS.PA_ADMIN_EXT SQL Statements

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

Line: 11

  		  SELECT  COUNT(*)
		  INTO    X_dummy
                  FROM   PER_ASSIGNMENTS_F A
                  ,      PER_ASSIGNMENT_STATUS_TYPES AST
                  WHERE  SUPERVISOR_ID = pa_online_exp.GetAdminPersonId
                  AND    A.PRIMARY_FLAG = 'Y'
                  AND    A.ASSIGNMENT_TYPE IN ('E','C')
		  AND    A.JOB_ID IS NOT NULL
		  AND    A.ORGANIZATION_ID IS NOT NULL
		  AND    AST.ASSIGNMENT_STATUS_TYPE_ID = A.ASSIGNMENT_STATUS_TYPE_ID
		  AND    AST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN','ACTIVE_CWK')
		  AND    A.PERSON_ID = X_person_id;

Line: 46

                  SELECT  COUNT(*)
                  INTO    X_dummy
                  FROM   PER_ASSIGNMENTS_F A
                  ,      PER_ASSIGNMENT_STATUS_TYPES AST
                  WHERE  SUPERVISOR_ID = pa_online_exp.GetAdminPersonId
		  AND    (trunc(effective_start_date) between x_date and X_ending_date or
			  trunc(effective_end_date) between X_date and X_ending_date or
			  trunc(sysdate) between effective_start_date and effective_end_date)
                  AND    A.PRIMARY_FLAG = 'Y'
                  AND    A.ASSIGNMENT_TYPE IN ('E','C')
		  AND	 A.JOB_ID IS NOT NULL
		  AND	 A.ORGANIZATION_ID IS NOT NULL
                  AND    AST.ASSIGNMENT_STATUS_TYPE_ID = A.ASSIGNMENT_STATUS_TYPE_ID
                  AND    AST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN','ACTIVE_CWK')
		  AND    A.PERSON_ID = x_person_id;