APPS.PAY_US_TAXABILITY_RULES_PKG dependencies on PAY_TAXABILITY_RULES

Line 24: of US taxability rule using PAY_TAXABILITY_RULES

20:
21: Name : pay_us_taxability_rules_pkg
22:
23: Description : This package holds building blocks used in maintenace
24: of US taxability rule using PAY_TAXABILITY_RULES
25: table.
26:
27: Uses : hr_utility
28:

Line 58: pay_taxability_rules.

54: 03-JUN-1999 A Handa 115.4 Added legislation_code
55: check in select
56: from
57: pay_element_classifications and
58: pay_taxability_rules.
59: 09-JUL-1999 R. Murthy 115.5 Modified selects and inserts
60: from pay_taxability_rules
61: to include the new not-null
62: column taxability_rules_date_id

Line 60: from pay_taxability_rules

56: from
57: pay_element_classifications and
58: pay_taxability_rules.
59: 09-JUL-1999 R. Murthy 115.5 Modified selects and inserts
60: from pay_taxability_rules
61: to include the new not-null
62: column taxability_rules_date_id
63: and hard-coded legislation_code
64: as US, since Canada has it's

Line 68: pay_taxability_rules.

64: as US, since Canada has it's
65: own package.
66:
67: 02-JUN-2003 asasthan 115.6 2904628 New column has been added to
68: pay_taxability_rules.
69: The status column now carries
70: a value of 'D' if the rule
71: is DELETED(D) by either
72: Oracle or by customer.

Line 120: from PAY_TAXABILITY_RULES_DATES TRD

116: P_date DATE default sysdate) is
117: CURSOR csr_get_info is
118: select TRD.TAXABILITY_RULES_DATE_ID,
119: TRD.VALID_DATE_FROM, TRD.VALID_DATE_TO
120: from PAY_TAXABILITY_RULES_DATES TRD
121: where p_date between TRD.VALID_DATE_FROM and
122: TRD.VALID_DATE_TO
123: and TRD.LEGISLATION_CODE = p_legislation_code;
124: begin

Line 143: from PAY_TAXABILITY_RULES

139: ret VARCHAR2(1) := 'N';
140: --
141: CURSOR csr_check is
142: select 'Y'
143: from PAY_TAXABILITY_RULES
144: where JURISDICTION_CODE = P_jurisdiction
145: and TAX_TYPE = P_tax_type
146: and TAX_CATEGORY = P_category
147: and CLASSIFICATION_ID = p_classification_id

Line 181: update pay_taxability_rules

177:
178: ret number := 0;
179: begin
180:
181: update pay_taxability_rules
182: set status = null
183: where jurisdiction_code = P_jurisdiction
184: and tax_type = P_tax_type
185: and tax_category = P_category

Line 190: INSERT INTO pay_taxability_rules(

186: and classification_id = p_classification_id
187: and taxability_rules_date_id = P_taxability_rules_date_id;
188:
189: if sql%notfound then
190: INSERT INTO pay_taxability_rules(
191: JURISDICTION_CODE, TAX_TYPE, TAX_CATEGORY,
192: classification_id, TAXABILITY_RULES_DATE_ID,
193: LEGISLATION_CODE,
194: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 230: update pay_taxability_rules

226: --
227: ret number := 0;
228: begin
229:
230: update pay_taxability_rules
231: set status = 'D'
232: where jurisdiction_code = P_jurisdiction
233: and tax_type = P_tax_type
234: and tax_category = P_category

Line 268: FROM pay_taxability_rules

264: -- declare local cursor
265: --
266: CURSOR get_other_rule IS
267: SELECT 'Y'
268: FROM pay_taxability_rules
269: WHERE jurisdiction_code = p_jurisdiction_code
270: AND tax_type = p_tax_type
271: AND classification_id = p_classification_id
272: AND tax_category <> p_tax_category

Line 416: from pay_taxability_rules_dates

412: P_User_Id := FND_PROFILE.Value('USER_ID');
413: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
414: select taxability_rules_date_id
415: into p_taxability_rules_date_id
416: from pay_taxability_rules_dates
417: where sysdate between valid_date_from and valid_date_to
418: and legislation_code = p_legislation_code;
419:
420: if X_CONTEXT = 'FEDERAL' then