DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_TAXABILITY_RULES

Line 346: FROM PAY_TAXABILITY_RULES

342:
343: CURSOR csr_chk_taxability(v_tax_type VARCHAR2,
344: v_jurisdiction_code VARCHAR2) IS
345: SELECT 'Y'
346: FROM PAY_TAXABILITY_RULES
347: WHERE jurisdiction_code = v_jurisdiction_code
348: and tax_category = g_earnings_category
349: and tax_type = v_tax_type
350: and classification_id = g_classification_id

Line 356: FROM PAY_TAXABILITY_RULES

352: ;
353:
354: CURSOR csr_chk_fed_taxability(v_tax_type VARCHAR2) IS
355: SELECT 'Y'
356: FROM PAY_TAXABILITY_RULES
357: WHERE jurisdiction_code = g_fed_jd
358: and tax_category = g_earnings_category
359: and tax_type = v_tax_type
360: and classification_id = g_classification_id

Line 366: FROM PAY_TAXABILITY_RULES

362: ;
363:
364: CURSOR csr_chk_all_taxability(v_jurisdiction_code VARCHAR2) IS
365: SELECT 'N'
366: FROM PAY_TAXABILITY_RULES
367: WHERE jurisdiction_code = v_jurisdiction_code
368: and nvl(status,'VALID') <> 'D'
369:
370: ;

Line 1911: FROM pay_taxability_rules

1907: IF g_classification IN ('Imputed Earnings', 'Supplemental Earnings') THEN
1908: BEGIN
1909: SELECT 'Y'
1910: INTO l_medicare_taxability
1911: FROM pay_taxability_rules
1912: WHERE jurisdiction_code = g_fed_jd
1913: AND tax_category = g_earnings_category
1914: AND tax_type = 'MEDICARE'
1915: AND classification_id = g_classification_id