DBA Data[Home] [Help]

APPS.PAY_US_TAXABILITY_RULES_PKG dependencies on PAY_TAXABILITY_RULES_DATES

Line 120: from PAY_TAXABILITY_RULES_DATES TRD

116: P_date DATE default sysdate) is
117: CURSOR csr_get_info is
118: select TRD.TAXABILITY_RULES_DATE_ID,
119: TRD.VALID_DATE_FROM, TRD.VALID_DATE_TO
120: from PAY_TAXABILITY_RULES_DATES TRD
121: where p_date between TRD.VALID_DATE_FROM and
122: TRD.VALID_DATE_TO
123: and TRD.LEGISLATION_CODE = p_legislation_code;
124: begin

Line 416: from pay_taxability_rules_dates

412: P_User_Id := FND_PROFILE.Value('USER_ID');
413: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
414: select taxability_rules_date_id
415: into p_taxability_rules_date_id
416: from pay_taxability_rules_dates
417: where sysdate between valid_date_from and valid_date_to
418: and legislation_code = p_legislation_code;
419:
420: if X_CONTEXT = 'FEDERAL' then