APPS.PAY_NL_TAX_PKG SQL Statements

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

Line: 25

  SELECT ptp.start_date     start_date
        ,ptp.end_date       end_date
  FROM   per_time_periods   ptp
  WHERE  ptp.payroll_id=p_payroll_id
  AND p_date_earned    BETWEEN ptp.start_date AND ptp.end_date;

Line: 34

  SELECT date_of_birth,per.last_name,paf.assignment_number
  FROM   per_all_people_f per
        ,per_all_assignments_f paf
  WHERE  per.person_id      = paf.person_id
  AND    paf.assignment_id  = p_assignment_id
  AND    p_date_earned       BETWEEN per.effective_start_date AND per.effective_end_date
  AND    p_date_earned       BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line: 93

    SELECT ptp.start_date     start_date
          ,ptp.end_date       end_date
    FROM   per_time_periods   ptp
    WHERE  ptp.payroll_id=p_payroll_id
    AND p_date_earned    BETWEEN ptp.start_date AND ptp.end_date;

Line: 102

    SELECT date_of_birth
    FROM   per_all_people_f per
    WHERE  per.person_id      = p_person_id
    AND    p_date_earned       BETWEEN per.effective_start_date AND per.effective_end_date;

Line: 145

  SELECT date_of_birth
  FROM   per_all_people_f per
        ,per_all_assignments_f paf
  WHERE  per.person_id      = paf.person_id
  AND    paf.assignment_id  = p_assignment_id
  AND    p_date_earned       BETWEEN per.effective_start_date AND per.effective_end_date
  AND    p_date_earned       BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line: 182

  SELECT date_of_birth
  FROM   per_all_people_f per
        ,per_all_assignments_f paf
  WHERE  per.person_id      = paf.person_id
  AND    paf.assignment_id  = p_assignment_id
  AND    l_system_date       BETWEEN per.effective_start_date AND per.effective_end_date
  AND    l_system_date       BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line: 214

   SELECT scl.segment7
   FROM hr_soft_coding_keyflex scl,per_all_assignments_f paa,fnd_sessions ses
   WHERE
     paa.person_id=p_person_id and
     paa.assignment_id <> nvl(p_assignment_id,-1) and
     scl.soft_coding_keyflex_id=paa.soft_coding_keyflex_id and
     scl.segment7='Y' and
     ses.effective_date between nvl (paa.effective_start_date,sysdate) and
     nvl(paa.effective_end_date,sysdate) and
     ses.session_id = userenv ('sessionid');

Line: 256

       SELECT pp.period_type
       FROM pay_payrolls_f pp,fnd_sessions ses
       WHERE
       pp.payroll_id=p_payroll_id and
       ses.effective_date between nvl(pp.effective_start_date,ses.effective_date) and
       nvl(pp.effective_end_date,ses.effective_date) and
      ses.session_id=userenv('sessionid');

Line: 528

  SELECT date_start from
  per_periods_of_service pps,
  per_all_assignments_f paa
  where pps.person_id = paa.person_id
  and paa.assignment_id = p_assignment_id
  and pps.business_group_id = p_business_group_id
  and paa.business_group_id = p_business_group_id
  and p_date_earned between date_start and nvl(actual_termination_date,hr_general.end_of_time)
  and p_date_earned between paa.effective_start_date and paa.effective_end_date;

Line: 541

  SELECT date_of_birth
  FROM   per_all_people_f pap,
         per_all_assignments_f paa
  where  paa.person_id = pap.person_id
  and paa.assignment_id = p_assignment_id
  And p_date_earned between pap.effective_start_date and pap.effective_end_date
  and p_date_earned between paa.effective_start_date and paa.effective_end_date
  And pap.business_Group_id = p_business_group_id
  and paa.business_Group_id = p_business_group_id;