DBA Data[Home] [Help]

APPS.PAY_GET_TAX_EXISTS_PKG dependencies on HR_US_FF_UDF1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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