APPS.PN_R12_UTIL_PKG SQL Statements

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

Line: 18

   SELECT tax_classification_code
     FROM zx_id_tcc_mapping
    WHERE p_as_of_date BETWEEN nvl(effective_from, p_as_of_date)
                       AND nvl(effective_to, p_as_of_date)
      AND tax_rate_code_id = p_tax_code_id
      AND source = p_source;

Line: 70

  SELECT meaning
  FROM zx_output_classifications_v
  WHERE enabled_flag = 'Y'
  AND trunc(SYSDATE) BETWEEN TRUNC(nvl(start_date_active,SYSDATE)) AND TRUNC(nvl(end_date_active,SYSDATE))
  AND org_id = p_org_id
  AND lookup_code = p_tcc;

Line: 78

  SELECT meaning
  FROM ZX_INPUT_CLASSIFICATIONS_V
  WHERE lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
  AND enabled_flag = 'Y'
  AND trunc(SYSDATE) BETWEEN TRUNC(nvl(start_date_active, SYSDATE)) AND TRUNC(nvl(end_date_active, SYSDATE))
  AND org_id = p_org_id
  AND lookup_code = p_tcc;

Line: 133

      SELECT tax_code_id, tax_group_id, tax_classification_code
      FROM   pn_term_templates
      WHERE  term_template_id = p_term_temp_id;

Line: 285

      SELECT ppt.legal_entity_id       le_id,
             dist.account_id           cc_id
      FROM   pn_distributions dist,
             pn_payment_terms_all ppt
      WHERE  dist.payment_term_id = p_payment_term_id
        AND  ppt.payment_term_id = p_payment_term_id
        AND  rownum < 2;

Line: 295

      SELECT dist.account_id       cc_id,
             NULL             AS   le_id
      FROM   pn_distributions dist
      WHERE  dist.term_template_id = p_term_template_id
        AND  rownum < 2;

Line: 303

      SELECT ppt.legal_entity_id       le_id,
             dist.account_id           cc_id
      FROM   pn_distributions dist,
             pn_payment_terms_all ppt
      WHERE  dist.payment_term_id = p_payment_term_id
        AND  ppt.payment_term_id = p_payment_term_id
        AND  distribution_id <> p_distribution_id
        AND  rownum < 2;

Line: 314

      SELECT dist.account_id       cc_id,
             NULL             AS   le_id
      FROM   pn_distributions dist
      WHERE  dist.term_template_id = p_term_template_id
        AND  distribution_id <> p_distribution_id
        AND  rownum < 2;

Line: 328

   IF p_mode = 'INSERT' THEN
     IF p_payment_term_id IS NOT NULL THEN
       FOR validation_rec IN chk_other_dist_ins LOOP
         l_answer := is_le_compatible(
                      p_le_id_old      => validation_rec.le_id
                     ,p_ccid1          => validation_rec.cc_id
                     ,p_ccid2          => p_ccid
                     ,p_vendor_site_id => p_vendor_site_id
                     ,p_org_id         => p_org_id);

Line: 350

   ELSIF p_mode = 'UPDATE' THEN
     IF p_payment_term_id IS NOT NULL THEN
       FOR validation_rec IN chk_other_dist_upd LOOP
         l_answer := is_le_compatible(
                      p_le_id_old      => validation_rec.le_id
                     ,p_ccid1          => validation_rec.cc_id
                     ,p_ccid2          => p_ccid
                     ,p_vendor_site_id => p_vendor_site_id
                     ,p_org_id         => p_org_id);

Line: 497

   SELECT DECODE( NVL(inclusive_tax_flag,'Y'),'Y','S','N') tax_flag
   FROM   zx_party_tax_profile zpt,
         po_vendors pov
   WHERE  pov.vendor_id = p_vendor_id
   AND    zpt.party_id = pov.party_id
   AND    party_type_code = 'THIRD_PARTY';

Line: 506

   SELECT DECODE( NVL(inclusive_tax_flag,'Y'),'Y','S','N') tax_flag
   FROM   zx_party_tax_profile zpt,
          po_vendor_sites_all pvsa
   WHERE  pvsa.VENDOR_SITE_ID = p_vendor_site_id
   AND    zpt.party_id = pvsa.party_site_id
   AND    party_type_code = 'THIRD_PARTY_SITE';

Line: 629

   SELECT org_id,
          tax_code_id,
          tax_group_id,
          tax_classification_code,
          term_template_type
   FROM pn_term_templates_all
   WHERE term_template_id = p_term_template_id;

Line: 655

            UPDATE pn_term_templates_all
            SET tax_classification_code = l_tcc,
                tax_code_id = NULL,
                tax_group_id = NULL
            WHERE term_template_id = p_term_template_id;