DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_TAXABILITY_RULES

Line 248: FROM PAY_TAXABILITY_RULES

244:
245: CURSOR csr_chk_taxability(v_tax_type VARCHAR2,
246: v_jurisdiction_code VARCHAR2) IS
247: SELECT 'Y'
248: FROM PAY_TAXABILITY_RULES
249: WHERE jurisdiction_code = v_jurisdiction_code
250: and tax_category = g_earnings_category
251: and tax_type = v_tax_type
252: and classification_id = g_classification_id

Line 258: FROM PAY_TAXABILITY_RULES

254: ;
255:
256: CURSOR csr_chk_fed_taxability(v_tax_type VARCHAR2) IS
257: SELECT 'Y'
258: FROM PAY_TAXABILITY_RULES
259: WHERE jurisdiction_code = g_fed_jd
260: and tax_category = g_earnings_category
261: and tax_type = v_tax_type
262: and classification_id = g_classification_id

Line 268: FROM PAY_TAXABILITY_RULES

264: ;
265:
266: CURSOR csr_chk_all_taxability(v_jurisdiction_code VARCHAR2) IS
267: SELECT 'N'
268: FROM PAY_TAXABILITY_RULES
269: WHERE jurisdiction_code = v_jurisdiction_code
270: and nvl(status,'VALID') <> 'D'
271:
272: ;