APPS.PAY_IN_EXC SQL Statements

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

Line: 37

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

   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   PACT.date_earned  BETWEEN TP.start_date AND TP.end_date;

Line: 779

select target.org_information2
from  per_all_assignments_f assign,
       hr_soft_coding_keyflex hsc,
       hr_organization_information target,
       pay_assignment_actions paa
  WHERE paa.assignment_action_id = p_asg_action
  AND   paa.assignment_id = assign.assignment_id
  AND   p_effective_date  BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
  AND   assign.business_group_id = target.organization_id
  AND   target.org_information_context = 'PER_IN_PT_FREQUENCY'
  AND   assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
  AND   pay_in_prof_tax_pkg.get_state(hsc.segment3)  = target.org_information1
  AND   p_effective_date BETWEEN fnd_date.canonical_to_date(target.org_information3)
  AND fnd_date.canonical_to_date(nvl(target.org_information4,'4712/12/31 00:00:00'));