APPS.PAY_CA_TAX_RULES_GARN_PKG SQL Statements

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

Line: 4

PROCEDURE get_or_update(X_MODE                VARCHAR2,
                        X_CONTEXT             VARCHAR2,
                        X_JURISDICTION        VARCHAR2,
                        X_TAX_CAT             VARCHAR2,
			X_classification_id   NUMBER,
                        X_legislation_code    VARCHAR2,
                        X_taxability_rules_date_id   out nocopy NUMBER,
                        X_valid_date_from       in out nocopy DATE,
                        X_valid_date_to       in out nocopy DATE,
                        X_session_date          DATE,
                        X_BOX1         IN OUT nocopy VARCHAR2,
                        X_BOX2         IN OUT nocopy VARCHAR2) IS
-- Local Variables
P_ret      VARCHAR2(1) := 'N';

Line: 29

       select TRD.TAXABILITY_RULES_DATE_ID,
              TRD.VALID_DATE_FROM, TRD.VALID_DATE_TO
       from   PAY_TAXABILITY_RULES_DATES TRD
       where  p_date between TRD.VALID_DATE_FROM and
                             TRD.VALID_DATE_TO
       and    TRD.LEGISLATION_CODE = p_legislation_code;

Line: 53

       select 'Y'
       from   PAY_TAXABILITY_RULES
       where  JURISDICTION_CODE = P_jurisdiction
       and    TAX_TYPE          = P_tax_type
       and    TAX_CATEGORY      = P_category
       and    CLASSIFICATION_ID = p_classification_id
       and    TAXABILITY_RULES_DATE_ID = p_taxability_rules_date_id;

Line: 75

PROCEDURE insert_rules(P_jurisdiction       VARCHAR2,
                       P_tax_type           VARCHAR2,
                       P_category           VARCHAR2,
		       P_classification_id  NUMBER,
                       P_taxability_rules_date_id NUMBER,
		       P_legislation_code   VARCHAR2) IS
--
begin
  INSERT INTO pay_taxability_rules(
         JURISDICTION_CODE,
         TAX_TYPE,
         TAX_CATEGORY,
         CLASSIFICATION_ID,
         TAXABILITY_RULES_DATE_ID,
         LEGISLATION_CODE,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN,
         CREATED_BY,
         CREATION_DATE)
  VALUES (
         P_jurisdiction,
         P_tax_type,
         P_category,
         P_classification_id,
         P_taxability_rules_date_id,
         P_legislation_code,
         SYSDATE,
         P_user_id,
         P_Login_Id,
         P_user_id,
         SYSDATE);

Line: 109

     hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');

Line: 114

END insert_rules;

Line: 116

PROCEDURE delete_rules(P_jurisdiction       VARCHAR2,
                       P_tax_type           VARCHAR2,
                       P_category           VARCHAR2,
		       P_classification_id  NUMBER,
                       P_taxability_rules_date_id NUMBER,
                       P_legislation_code   VARCHAR2) IS
--
begin
  delete from pay_taxability_rules
  where jurisdiction_code = P_jurisdiction
  and   tax_type          = P_tax_type
  and   tax_category      = P_category
  and   classification_id = p_classification_id
  and   taxability_rules_date_id = P_taxability_rules_date_id
  and   legislation_code = P_legislation_code;

Line: 134

     hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');

Line: 139

END delete_rules;

Line: 161

  elsif X_MODE = 'UPDATE' then
     P_User_Id  := FND_PROFILE.Value('USER_ID');

Line: 165

        select taxability_rules_date_id
        into   X_taxability_rules_date_id
        from   pay_taxability_rules_dates
        where  X_session_date between valid_date_from and valid_date_to
        and    legislation_code = X_legislation_code;

Line: 180

           delete_rules(l_jurisdiction,'CSDI',X_tax_cat, X_classification_id,
			X_taxability_rules_date_id, X_legislation_code);

Line: 183

           insert_rules(l_jurisdiction,'CSDI',X_tax_cat, X_classification_id,
			X_taxability_rules_date_id, X_legislation_code);

Line: 195

           delete_rules(l_jurisdiction,'GDI',X_tax_cat, X_classification_id,
			X_taxability_rules_date_id, X_legislation_code);

Line: 198

           insert_rules(l_jurisdiction,'GDI',X_tax_cat, X_classification_id,
			X_taxability_rules_date_id, X_legislation_code);

Line: 205

END get_or_update;

Line: 216

SELECT classification_id
FROM   pay_element_classifications
WHERE  classification_name = p_classification_name
AND    legislation_code = p_legislation_code;