APPS.PER_POS_BGT_PKG SQL Statements

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

Line: 35

  SELECT  COUNT(E.PERSON_ID),
	  '** ' || COUNT(E.PERSON_ID) ||' '|| X_HOLDER_NAME,
	  MAX(E.FULL_NAME),
	  MAX(E.EMPLOYEE_NUMBER)
  INTO	  X_NO_OF_HOLDERS,
	  X_HOLDER_NAME,
	  l_real_holder_name,
	  X_HOLDER_EMP_NO
  FROM    PER_ALL_PEOPLE E
  ,       PER_ALL_ASSIGNMENTS A
  WHERE   A.POSITION_ID       = X_POSITION_ID
  AND     A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
  AND     A.ORGANIZATION_ID   = X_ORGANIZATION_ID
  AND     A.ASSIGNMENT_TYPE   = 'E'
  AND     A.PERSON_ID = E.PERSON_ID;

Line: 79

SELECT BV.VALUE, BV.BUDGET_VALUE_ID
FROM   PER_BUDGET_VALUES BV, PER_BUDGET_ELEMENTS BE
WHERE  BE.POSITION_ID       = X_POSITION_ID
AND    BE.BUDGET_VERSION_ID = X_BUDGET_VERSION_ID
AND    BV.BUDGET_ELEMENT_ID = BE.BUDGET_ELEMENT_ID
AND    BV.TIME_PERIOD_ID    = X_TIME_PERIOD_ID;

Line: 118

SELECT NVL(SUM(ABV.VALUE),0)
FROM   PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
       PER_ASSIGNMENT_STATUS_TYPES  AST,
       PER_ASSIGNMENTS_F A
WHERE  A.POSITION_ID			= X_POSITION_ID
AND    A.BUSINESS_GROUP_ID		= X_BUSINESS_GROUP_ID
AND    X_START_DATE 	BETWEEN A.EFFECTIVE_START_DATE AND
                	A.EFFECTIVE_END_DATE
AND    A.ASSIGNMENT_ID			= ABV.ASSIGNMENT_ID
AND    ABV.BUSINESS_GROUP_ID		= X_BUSINESS_GROUP_ID
AND    X_START_DATE 	BETWEEN ABV.EFFECTIVE_START_DATE AND
                	                ABV.EFFECTIVE_END_DATE
AND    X_UNIT				= ABV.UNIT
AND    A.ASSIGNMENT_STATUS_TYPE_ID	= AST.ASSIGNMENT_STATUS_TYPE_ID
AND    AST.PER_SYSTEM_STATUS		<> 'TERM_ASSIGN'
AND    A.ASSIGNMENT_TYPE		= 'E';

Line: 170

SELECT NVL(SUM(ABV.VALUE),0)
FROM   PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
       PER_ASSIGNMENT_STATUS_TYPES  AST,
       PER_ASSIGNMENTS_F A
WHERE  A.POSITION_ID			= X_POSITION_ID
AND    A.BUSINESS_GROUP_ID		= X_BUSINESS_GROUP_ID
AND    X_END_DATE		BETWEEN A.EFFECTIVE_START_DATE AND
						A.EFFECTIVE_END_DATE
AND    ABV.UNIT				= X_UNIT
AND    A.ASSIGNMENT_ID			= ABV.ASSIGNMENT_ID
AND    X_END_DATE	       BETWEEN ABV.EFFECTIVE_START_DATE AND
					ABV.EFFECTIVE_END_DATE
AND    A.ASSIGNMENT_STATUS_TYPE_ID	= AST.ASSIGNMENT_STATUS_TYPE_ID
AND    AST.PER_SYSTEM_STATUS		<> 'TERM_ASSIGN'
AND    A.ASSIGNMENT_TYPE		= 'E';

Line: 245

SELECT   A.ASSIGNMENT_ID, A.POSITION_ID,
         A.EFFECTIVE_START_DATE, A.EFFECTIVE_END_DATE, ABV.VALUE
FROM     PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
         PER_ASSIGNMENTS_F A
WHERE    A.POSITION_ID          =  X_POSITION_ID
AND      A.BUSINESS_GROUP_ID    =  X_BUSINESS_GROUP_ID
AND      A.EFFECTIVE_START_DATE <= X_END_DATE
AND      A.EFFECTIVE_END_DATE   >= X_START_DATE - 1
AND      X_UNIT                 =  ABV.UNIT
AND      A.ASSIGNMENT_ID        =  ABV.ASSIGNMENT_ID

AND    (A.EFFECTIVE_START_DATE BETWEEN  ABV.EFFECTIVE_START_DATE AND ABV.EFFECTIVE_END_DATE)

AND      A.ASSIGNMENT_TYPE      =  'E'
ORDER BY A.ASSIGNMENT_ID, A.EFFECTIVE_START_DATE;

Line: 370

SELECT   A.ASSIGNMENT_ID, A.POSITION_ID, AST.PER_SYSTEM_STATUS,
         A.EFFECTIVE_START_DATE, A.EFFECTIVE_END_DATE, ABV.VALUE
FROM     PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
         PER_ASSIGNMENT_STATUS_TYPES  AST,
         PER_ASSIGNMENTS_F	      A
WHERE    A.POSITION_ID               =  X_POSITION_ID
AND      A.BUSINESS_GROUP_ID         =  X_BUSINESS_GROUP_ID
AND      A.ASSIGNMENT_STATUS_TYPE_ID =  AST.ASSIGNMENT_STATUS_TYPE_ID
AND      A.EFFECTIVE_START_DATE      <= X_END_DATE + 1
AND      A.EFFECTIVE_END_DATE        >= X_START_DATE
AND      X_UNIT                      =  ABV.UNIT
AND      A.ASSIGNMENT_ID             =  ABV.ASSIGNMENT_ID

AND    (A.EFFECTIVE_START_DATE BETWEEN  ABV.EFFECTIVE_START_DATE AND ABV.EFFECTIVE_END_DATE)

AND      A.ASSIGNMENT_TYPE           =  'E'
ORDER BY A.ASSIGNMENT_ID, A.EFFECTIVE_START_DATE;