DBA Data[Home] [Help]

APPS.PAY_US_TAXABILITY_RULES_PKG_F dependencies on PAY_TAXABILITY_RULES_DATES

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