DBA Data[Home] [Help]

APPS.PAY_GET_TAX_EXISTS_PKG dependencies on HR_US_FF_UDF1

Line 590: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

586: hr_utility.trace('Local Income Tax Exists : ' ||l_wh_work_localities);
587: --
588: -- This is added to tax a jurisdiction if it is tagged OR
589: -- resident jurisdiction is same Work
590: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
591: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
592: if (nvl(l_jd_type,'NL') = 'RT' OR
593: nvl(l_jd_type,'NL') = 'RW' OR
594: nvl(l_jd_type,'NL') = 'HW' -- added to fix bug # 4463475

Line 852: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

848: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
849:
850: IF l_sit_rs_exists = 'N' THEN
851:
852: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN
853: RETURN 'Y';
854: END IF;
855:
856: END IF;

Line 870: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

866: hr_utility.trace('SIT Exists : ' || l_org_info2);
867:
868: IF l_org_info2 = 'N' THEN
869:
870: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN
871: RETURN 'Y';
872: END IF;
873:
874: END IF;

Line 1271: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);

1267:
1268: hr_utility.trace('l_indiana_override '||l_indiana_override);
1269: if override_state%found then
1270:
1271: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1272:
1273: hr_utility.trace('l_across_years '||l_across_years);
1274: if (l_indiana_override = 'IN' and
1275: l_across_years = 'Y') then

Line 1452: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);

1448: the check date is in the next following year then date paid should be
1449: used. */
1450: if p_pact_id is not null then
1451:
1452: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1453:
1454: hr_utility.trace('l_across_years '||l_across_years);
1455: if (l_across_years = 'Y') then
1456:

Line 1695: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

1691: , 73);
1692: -- added for Bug # 4711572
1693: if l_local_tax_rules_type = 'LOCALITIES'
1694: then
1695: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
1696: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1697: -- if (nvl(l_jd_type,'NL') = 'RW')
1698: /*Modified for bug 7353397 to include Work at home scenario
1699: for caluclating taxes when 'Only Locatlites Under Local Tax Rules'

Line 1724: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

1720: hr_utility.set_location(
1721: 'py_gt_tax_exists_pkg.get_tax_exists', 75);
1722: -- This is added to tax a jurisdiction if it is tagged OR
1723: -- resident jurisdiction is same Work
1724: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
1725: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1726: if (nvl(l_jd_type,'NL') = 'RT' OR
1727: nvl(l_jd_type,'NL') = 'RW' OR
1728: nvl(l_jd_type,'NL') = 'HW' )then -- added for Bug # 4463475

Line 2257: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

2253:
2254: CLOSE state_rule;
2255: IF l_state_employer_info = 'N' THEN
2256:
2257: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN
2258: RETURN l_default_rule;
2259: ELSE
2260: RETURN l_jit8_rule;
2261: END IF;

Line 2271: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

2267:
2268: CLOSE state_rule;
2269: IF l_state_rule = 'Y' THEN
2270:
2271: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN
2272: RETURN l_default_rule;
2273: ELSE
2274: RETURN l_jit8_rule;
2275: END IF;

Line 2327: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

2323:
2324: CLOSE local_rule;
2325: IF l_state_rule_for_local = 'L' THEN
2326:
2327: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2328: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2329:
2330: IF (nvl(l_jd_type,'NL') = 'RT' OR
2331: nvl(l_jd_type,'NL') = 'RW' OR

Line 2358: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

2354: IF l_state_rule_for_local = 'W' THEN
2355:
2356: IF l_local_rule = 'Y' THEN
2357:
2358: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2359: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2360:
2361: IF (nvl(l_jd_type,'NL') = 'RT' OR
2362: nvl(l_jd_type,'NL') = 'RW' OR

Line 2404: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

2400: ELSE
2401:
2402: IF l_local_rule = 'Y' THEN
2403:
2404: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2405: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2406:
2407: IF (nvl(l_jd_type,'NL') = 'RT' OR
2408: nvl(l_jd_type,'NL') = 'RW' OR

Line 2460: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);

2456:
2457: hr_utility.trace('l_indiana_override '||l_indiana_override);
2458: IF override_state%found THEN
2459:
2460: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
2461:
2462: hr_utility.trace('l_across_years '||l_across_years);
2463: IF (l_indiana_override = 'IN' AND
2464: l_across_years = 'Y') THEN