APPS.PAY_CN_EXC SQL Statements

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

Line: 35

   SELECT   TP.end_date + 1
     FROM   per_time_periods    TP
          , pay_payroll_actions PACT
    WHERE   PACT.payroll_action_id = p_pactid
      AND   PACT.payroll_id        = TP.payroll_id
      AND   p_date BETWEEN TP.start_date AND TP.end_date;

Line: 255

     SELECT fnd_date.canonical_to_date(org_information11)
     FROM   pay_payroll_actions PACT
          , hr_organization_information HOI
     WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
     AND    HOI.organization_id                = PACT.business_group_id
     AND    PACT.payroll_action_id             = p_owner_payroll_action_id;

Line: 389

     SELECT fnd_date.canonical_to_date(org_information11)
     FROM   pay_payroll_actions PACT
          , hr_organization_information HOI
     WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
     AND    HOI.organization_id                = PACT.business_group_id
     AND    PACT.payroll_action_id             = p_owner_payroll_action_id;