APPS.PAY_CA_TAX_RULES_GARN_PKG dependencies on PAY_TAXABILITY_RULES_DATES

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 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: