APPS.PAY_US_TAXABILITY_RULES_PKG_F dependencies on PAY_TAXABILITY_RULES

Line 30: from PAY_TAXABILITY_RULES_DATES TRD

26: P_date DATE default sysdate) is
27: CURSOR csr_get_info is
28: select TRD.TAXABILITY_RULES_DATE_ID,
29: TRD.VALID_DATE_FROM, TRD.VALID_DATE_TO
30: from PAY_TAXABILITY_RULES_DATES TRD
31: where p_date between TRD.VALID_DATE_FROM and
32: TRD.VALID_DATE_TO
33: and TRD.LEGISLATION_CODE = p_legislation_code;
34: begin

Line 54: from PAY_TAXABILITY_RULES

50: ret VARCHAR2(1) := 'N';
51: --
52: CURSOR csr_check is
53: select 'Y'
54: from PAY_TAXABILITY_RULES
55: where JURISDICTION_CODE = P_jurisdiction
56: and TAX_TYPE = P_tax_type
57: and TAX_CATEGORY = P_category
58: and CLASSIFICATION_ID = p_classification_id

Line 85: update pay_taxability_rules

81: --
82: ret number := 0;
83: begin
84:
85: update pay_taxability_rules
86: set status = null
87: where jurisdiction_code = P_jurisdiction
88: and tax_type = P_tax_type
89: and tax_category = P_category

Line 95: INSERT INTO pay_taxability_rules(

91: and taxability_rules_date_id = P_taxability_rules_date_id;
92:
93: if sql%notfound then
94:
95: INSERT INTO pay_taxability_rules(
96: JURISDICTION_CODE,
97: TAX_TYPE,
98: TAX_CATEGORY,
99: classification_id,

Line 140: update pay_taxability_rules

136: RETURN NUMBER IS
137: --
138: ret number := 0;
139: begin
140: update pay_taxability_rules
141: set status = 'D'
142: where jurisdiction_code = P_jurisdiction
143: and tax_type = P_tax_type
144: and tax_category = P_category

Line 178: FROM pay_taxability_rules

174: -- declare local cursor
175: --
176: CURSOR get_other_rule IS
177: SELECT 'Y'
178: FROM pay_taxability_rules
179: WHERE jurisdiction_code = p_jurisdiction_code
180: AND tax_type = p_tax_type
181: AND classification_id = p_classification_id
182: AND tax_category <> p_tax_category

Line 235: FROM pay_taxability_rules_dates

231: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
232:
233: SELECT taxability_rules_date_id
234: INTO p_taxability_rules_date_id
235: FROM pay_taxability_rules_dates
236: WHERE sysdate between valid_date_from and valid_date_to
237: AND legislation_code = p_legislation_code;
238:
239: P_ret := check_row_exist(X_jurisdiction,