APPS.PAY_IN_PROF_TAX_PKG SQL Statements

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

Line: 30

        select hoi.org_information4
        from   hr_organization_information hoi
             , hr_organization_units hou
        where  hoi.organization_id = p_pt_org
        and    hoi.organization_id = hou.organization_id
        and    hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
        and    org_information_context ='PER_IN_PROF_TAX_DF';

Line: 146

  PROCEDURE check_pt_update
         (p_effective_date   IN  DATE
         ,p_dt_mode          IN  VARCHAR2
         ,p_assignment_id    IN  NUMBER
         ,p_pt_org           IN  VARCHAR2
         ,p_message          OUT NOCOPY VARCHAR2
         )
  IS
  BEGIN

    NULL;

Line: 158

  END check_pt_update;

Line: 198

      SELECT 'X'
      FROM   hr_organization_information
      WHERE  organization_id         = p_organization_id
      AND    org_information_context = p_org_info_type_code
      AND    org_information1        = p_state
      AND    org_information2        = p_exemption_catg
      AND    (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
      AND    fnd_date.canonical_to_date(p_eff_start_date)
          <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
      AND    fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
          >= fnd_date.canonical_to_date(org_information3);

Line: 334

      SELECT 'X'
      FROM   hr_organization_information
      WHERE  organization_id         = p_organization_id
      AND    org_information_context = p_org_info_type_code
      AND    org_information1        = p_state
      AND    (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
      AND    fnd_date.canonical_to_date(p_eff_start_date)
          <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
      AND    fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
          >= fnd_date.canonical_to_date(org_information3);

Line: 472

     SELECT 'X'
     FROM   pay_payment_types ppt
     WHERE  ppt.payment_type_id = to_number(p_payment_mode)
     AND ppt.territory_code = 'IN'
     AND ppt.category <> 'MT';

Line: 651

      SELECT org_information1, org_information2
      FROM   hr_organization_information
      WHERE  organization_id         = p_organization_id
      AND    org_information_context = p_org_info_type_code;

Line: 714

     SELECT loc_information16
     FROM   hr_locations
     WHERE  location_id = p_location_id
     AND    style = 'IN';

Line: 788

   SELECT location_id
   FROM   hr_all_organization_units
   WHERE  organization_id = p_organization_id;

Line: 868

                SELECT '1'
                  FROM per_assignments_f      paf
                      ,hr_soft_coding_keyflex hsc
                 WHERE ((paf.effective_start_date BETWEEN (p_prorate_end_date+1) AND p_period_end_date)
                       OR (paf.effective_end_date BETWEEN (p_prorate_end_date+1) AND p_period_end_date))
                   AND paf.assignment_id = p_assignment_id
                   AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
                   AND pay_in_prof_tax_pkg.get_state(hsc.segment3) = p_state ;

Line: 946

                SELECT 1
                  FROM per_assignments_f      paf
                      ,hr_soft_coding_keyflex hsc
                 WHERE (p_date + 1) between paf.effective_start_date and paf.effective_end_date
                   AND paf.assignment_id = p_assignment_id
                   AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
                   AND pay_in_prof_tax_pkg.get_state(hsc.segment3) = p_state ;