APPS.PAY_IP_EXPIRY_SUPPORT SQL Statements

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

Line: 61

   SELECT TP.end_date
   INTO   l_period_end_date
   FROM   per_time_periods    TP
         ,pay_payroll_actions PACT
   WHERE  PACT.payroll_action_id = p_owner_payroll_action_id
     AND  PACT.payroll_id        = TP.payroll_id
     AND  p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;

Line: 150

     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: 237

     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;