APPS.PAY_TXR_SHD SQL Statements

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

Line: 79

    select
       jurisdiction_code
      ,tax_type
      ,tax_category
      ,classification_id
      ,taxability_rules_date_id
      ,legislation_code
      ,status
      ,secondary_classification_id
    from        pay_taxability_rules
    where       jurisdiction_code = p_jurisdiction_code
    and   nvl(tax_type, 'X') = nvl(p_tax_type ,'X')
    and   nvl(tax_category, 'X') = nvl(p_tax_category ,'X')
    and   nvl(classification_id, 0) = nvl(p_classification_id, 0)
    and   nvl(secondary_classification_id, 0) =
                       nvl(p_secondary_classification_id, 0)
    and   taxability_rules_date_id = p_taxability_rules_date_id;

Line: 169

    select
       jurisdiction_code
      ,tax_type
      ,tax_category
      ,classification_id
      ,taxability_rules_date_id
      ,legislation_code
      ,status
      ,secondary_classification_id
    from        pay_taxability_rules
    where       jurisdiction_code = p_jurisdiction_code
    and   nvl(tax_type, 'X') = nvl(p_tax_type, 'X')
    and   nvl(tax_category, 'X') = nvl(p_tax_category, 'X')
    and   nvl(classification_id, 0) = nvl(p_classification_id, 0)
    and   nvl(secondary_classification_id, 0) =
                         nvl(p_secondary_classification_id, 0)
    and   taxability_rules_date_id = p_taxability_rules_date_id
    for update nowait;