APPS.PAY_TAXABILITY_RULES_API dependencies on PAY_TAXABILITY_RULES

Line 1: Package body pay_taxability_rules_api as

1: Package body pay_taxability_rules_api as
2: /* $Header: paytxabltyrulapi.pkb 120.0 2005/05/29 11:51 appldev noship $ */
3:
4: -- Package Variables
5: g_package VARCHAR2(33) := ' create_taxability_rules_api.';

Line 26: from pay_taxability_rules

22: ,cp_category in varchar2
23: ,cp_classification_id in number
24: ,cp_secondary_classification_id in number) is
25: select nvl(status, 'V'),last_updated_by
26: from pay_taxability_rules
27: where jurisdiction_code = cp_jurisdiction
28: and nvl(tax_type,'X') = nvl(cp_tax_type,'X')
29: and nvl(tax_category,'X') = nvl(cp_category,'X')
30: and nvl(classification_id,0) = nvl(cp_classification_id,0)

Line 192: ** We will never be deleting the data in pay_taxability_rules

188:
189:
190:
191: /***********************************************************
192: ** We will never be deleting the data in pay_taxability_rules
193: ** table. We will be updating the status to 'D' if the value
194: ** already exists.
195: **
196: ** Commenting out the delete becasue of the reason mentioned

Line 216: end pay_taxability_rules_api;

212: null;
213: END delete_taxability_rules;
214: ***********************************************************/
215:
216: end pay_taxability_rules_api;