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