APPS.PAY_CA_TAXABILITY_RULES_PKG dependencies on PAY_TAXABILITY_RULES

Line 27: of Canadian taxability rules using PAY_TAXABILITY_RULES

23:
24: Name : pay_ca_taxability_rules_pkg
25:
26: Description : This package holds building blocks used in maintenace
27: of Canadian taxability rules using PAY_TAXABILITY_RULES
28: table.
29:
30: Uses : hr_utility
31:

Line 82: from PAY_TAXABILITY_RULES_DATES TRD

78: P_date DATE default sysdate) is
79: CURSOR csr_get_info is
80: select TRD.TAXABILITY_RULES_DATE_ID,
81: TRD.VALID_DATE_FROM, TRD.VALID_DATE_TO
82: from PAY_TAXABILITY_RULES_DATES TRD
83: where p_date between TRD.VALID_DATE_FROM and
84: TRD.VALID_DATE_TO
85: and TRD.LEGISLATION_CODE = p_legislation_code;
86: begin

Line 105: from PAY_TAXABILITY_RULES PTR

101: ret VARCHAR2(1) := 'N';
102: --
103: CURSOR csr_check is
104: select 'Y'
105: from PAY_TAXABILITY_RULES PTR
106: where PTR.JURISDICTION_CODE = P_jurisdiction
107: and PTR.TAX_TYPE = P_tax_type
108: and PTR.TAX_CATEGORY = P_category
109: and PTR.CLASSIFICATION_ID = p_classification_id

Line 134: INSERT INTO pay_taxability_rules(

130: P_taxability_rules_date_id NUMBER) IS
131: --
132: begin
133:
134: INSERT INTO pay_taxability_rules(
135: JURISDICTION_CODE,
136: TAX_TYPE,
137: TAX_CATEGORY,
138: classification_id,

Line 175: delete from pay_taxability_rules

171: p_classification_id NUMBER,
172: P_taxability_rules_date_id NUMBER) IS
173: --
174: begin
175: delete from pay_taxability_rules
176: where jurisdiction_code = P_jurisdiction
177: and tax_type = P_tax_type
178: and tax_category = P_category
179: and classification_id = p_classification_id

Line 345: from pay_taxability_rules_dates

341: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
342: if X_taxability_rules_date_id IS NULL then
343: select taxability_rules_date_id
344: into X_taxability_rules_date_id
345: from pay_taxability_rules_dates
346: where X_session_date between valid_date_from and valid_date_to
347: and legislation_code = X_legislation_code;
348: end if;
349: