APPS.PAY_NL_TAX_PKG SQL Statements

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

Line: 15

Select TARGET.*
From
per_assignment_extra_info  TARGET
,pay_assignment_actions     PAA
,pay_payroll_actions        PACT
,per_time_periods        TPERIOD
where PAA.assignment_action_id = p_assignment_action_id
AND target.information_type = c_flex_context
AND target.assignment_id = PAA.assignment_id
AND PAA.payroll_action_id = PACT.payroll_action_id
AND PACT.payroll_id = TPERIOD.payroll_id
AND PACT.date_earned between TPERIOD.start_date and TPERIOD.end_date
AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)
AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date);

Line: 32

Select TARGET.*
From
per_assignment_extra_info  TARGET
,pay_assignment_actions     PAA
,pay_payroll_actions        PACT
,per_time_periods        TPERIOD
where PAA.assignment_action_id = p_assignment_action_id
AND target.information_type = c_flex_context
AND target.assignment_id = PAA.assignment_id
AND PAA.payroll_action_id = PACT.payroll_action_id
AND PACT.payroll_id = TPERIOD.payroll_id
AND PACT.date_earned between TPERIOD.start_date and TPERIOD.end_date
AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)
AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date)
AND to_char(TARGET.aei_information3) = 'F';

Line: 50

SELECT *
FROM per_assignment_extra_info
WHERE assignment_id = p_assignment_id
  AND aei_information_category = c_flex_context;

Line: 133

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

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

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

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

    SELECT  fnd_number.canonical_to_number(gbl.global_value)
    FROM ff_globals_f gbl
    WHERE gbl.LEGISLATION_CODE = 'NL'
    AND gbl.GLOBAL_NAME = 'NL_TAX_SENIOR_AGE_MONTHS'
    AND v_period_end_date between gbl.effective_start_date and gbl.effective_end_date;

Line: 288

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

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

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

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

    SELECT fnd_number.canonical_to_number(gbl.global_value)
    FROM ff_globals_f gbl
    WHERE gbl.LEGISLATION_CODE = 'NL'
      AND gbl.GLOBAL_NAME = 'NL_TAX_SENIOR_AGE_MONTHS'
      AND p_date_earned between gbl.effective_start_date and gbl.effective_end_date;

Line: 416

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

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

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

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

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

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

  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;

Line: 895

    SELECT effective_date
    FROM PAY_PAYROLL_ACTIONS
    WHERE payroll_action_id = p_payroll_action_id;

Line: 903

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

Line: 912

  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_date_paid       BETWEEN per.effective_start_date AND per.effective_end_date
  AND    l_date_paid       BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line: 953

      SELECT paei.AEI_INFORMATION3 Discount_Type
      FROM
      per_assignment_extra_info  paei
      WHERE
      paei.assignment_id = p_assignment_id
      AND p_date_earned between
      FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
      and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
      and paei.INFORMATION_TYPE = 'NL_TTD';