APPS.PAY_CA_TAX_RULES_GARN_PKG dependencies on PAY_TAXABILITY_RULES

Line 31: from PAY_TAXABILITY_RULES_DATES TRD

27: P_date DATE default sysdate) is
28: CURSOR csr_get_info is
29: select TRD.TAXABILITY_RULES_DATE_ID,
30: TRD.VALID_DATE_FROM, TRD.VALID_DATE_TO
31: from PAY_TAXABILITY_RULES_DATES TRD
32: where p_date between TRD.VALID_DATE_FROM and
33: TRD.VALID_DATE_TO
34: and TRD.LEGISLATION_CODE = p_legislation_code;
35: 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 83: INSERT INTO pay_taxability_rules(

79: P_taxability_rules_date_id NUMBER,
80: P_legislation_code VARCHAR2) IS
81: --
82: begin
83: INSERT INTO pay_taxability_rules(
84: JURISDICTION_CODE,
85: TAX_TYPE,
86: TAX_CATEGORY,
87: CLASSIFICATION_ID,

Line 124: delete from pay_taxability_rules

120: P_taxability_rules_date_id NUMBER,
121: P_legislation_code VARCHAR2) IS
122: --
123: begin
124: delete from pay_taxability_rules
125: where jurisdiction_code = P_jurisdiction
126: and tax_type = P_tax_type
127: and tax_category = P_category
128: and classification_id = p_classification_id

Line 167: from pay_taxability_rules_dates

163: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
164: if X_taxability_rules_date_id IS NULL then
165: select taxability_rules_date_id
166: into X_taxability_rules_date_id
167: from pay_taxability_rules_dates
168: where X_session_date between valid_date_from and valid_date_to
169: and legislation_code = X_legislation_code;
170: end if;
171: