DBA Data[Home] [Help]

APPS.PAY_CA_TAXABILITY_RULES_PKG dependencies on PAY_TAXABILITY_RULES_DATES

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