APPS.PAY_SE_EXPIRY_SUPPORT SQL Statements

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

Line: 29

     SELECT bd.period_type
           ,pact.business_group_id
     FROM   pay_payroll_actions         pact
           ,hr_organization_information hoi
           ,pay_balance_dimensions      bd
     WHERE  pact.payroll_action_id             = p_payroll_action_id
       AND  hoi.organization_id                = pact.business_group_id
       AND  UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
       AND  bd.dimension_name                  = p_dimension_name
       AND  bd.legislation_code                = hoi.org_information9;

Line: 105

     SELECT bd.period_type
           ,pact.business_group_id
     FROM   pay_payroll_actions         pact
           ,hr_organization_information hoi
           ,pay_balance_dimensions      bd
     WHERE  pact.payroll_action_id             = p_payroll_action_id
       AND  hoi.organization_id                = pact.business_group_id
       AND  UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
       AND  bd.dimension_name                  = p_dimension_name
       AND  bd.legislation_code                = hoi.org_information9;

Line: 172

	SELECT assignment_id
	FROM pay_assignment_actions
	WHERE assignment_action_id=p_assignment_action_id;

Line: 176

	SELECT	substr(hoi4.ORG_INFORMATION3,4,2)
	       FROM	HR_ORGANIZATION_UNITS o1
		    ,HR_ORGANIZATION_INFORMATION hoi1
		    ,HR_ORGANIZATION_INFORMATION hoi2
		    ,HR_ORGANIZATION_INFORMATION hoi3
		    ,HR_ORGANIZATION_INFORMATION hoi4
		    ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
			 FROM PER_ALL_ASSIGNMENTS_F ASG
			      ,HR_SOFT_CODING_KEYFLEX SCL
			WHERE ASG.ASSIGNMENT_ID	= l_assignment_id
			  AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
			  AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE	AND ASG.EFFECTIVE_END_DATE ) X
	      WHERE o1.business_group_id = l_business_group_id
		AND hoi1.organization_id = o1.organization_id
		AND hoi1.organization_id = X.ORG_ID
		AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
		AND hoi1.org_information_context = 'CLASS'
		AND o1.organization_id = hoi2.org_information1
		AND hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS'
		AND hoi2.organization_id =  hoi3.organization_id
		AND hoi3.ORG_INFORMATION_CONTEXT='CLASS'
		AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
		AND hoi3.organization_id = hoi4.organization_id
		AND hoi4.ORG_INFORMATION_CONTEXT='SE_HOLIDAY_YEAR_DEFN'
		AND hoi4.org_information1 IS NOT NULL;