eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GET_TAX_EXISTS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 522: FROM hr_organization_information hoi

518: 'LOCALITIES', 'N',
519: 'WORK_LOCALITIES','N',
520: 'Y')
521: INTO l_state_level_tax_exists
522: FROM hr_organization_information hoi
523: WHERE hoi.org_information_context = 'State Tax Rules'
524: AND hoi.organization_id = p_tax_unit_id
525: AND hoi.org_information1 = l_state_abbrev;
526: BEGIN

Line 535: FROM hr_organization_information hoi

531: SELECT DECODE(hoi.ORG_INFORMATION19,
532: 'WORK_LOCALITIES','N',
533: 'Y') -- State Tax Rules level
534: INTO l_wh_work_localities
535: FROM hr_organization_information hoi
536: WHERE hoi.org_information_context = 'State Tax Rules'
537: AND hoi.organization_id = p_tax_unit_id
538: AND hoi.org_information1 = l_state_abbrev;
539: IF l_wh_work_localities = 'Y'

Line 549: FROM HR_ORGANIZATION_INFORMATION hoi

545: --{
546: SELECT DECODE(hoi.ORG_INFORMATION3,'Y','N','N','Y','Y')
547: --local level have to check if exempt
548: INTO l_local_level_tax_exists
549: FROM HR_ORGANIZATION_INFORMATION hoi
550: WHERE hoi.ORG_INFORMATION_CONTEXT = 'Local Tax Rules'
551: AND hoi.organization_id = p_tax_unit_id
552: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||'-0000';
553: /* Bug 2934494

Line 833: FROM HR_ORGANIZATION_INFORMATION hoi

829: /*{*/
830: SELECT DECODE(hoi.ORG_INFORMATION2, 'ALL', 'Y', 'STATES', 'N', 'Y')
831: /* EI level */
832: INTO l_org_info2
833: FROM HR_ORGANIZATION_INFORMATION hoi
834: WHERE hoi.ORG_INFORMATION_CONTEXT = 'Employer Identification'
835: AND hoi.organization_id = p_tax_unit_id;
836:
837: BEGIN

Line 842: FROM HR_ORGANIZATION_INFORMATION hoi

838: /*{*/
839: SELECT DECODE(hoi.ORG_INFORMATION18, 'Y', 'N', 'N', 'Y', 'Y')
840: /* state level have to check if exempt */
841: INTO l_sit_rs_exists
842: FROM HR_ORGANIZATION_INFORMATION hoi
843: WHERE hoi.ORG_INFORMATION_CONTEXT = 'State Tax Rules'
844: AND hoi.organization_id = p_tax_unit_id
845: AND hoi.org_information1 = l_state_abbrev;
846:

Line 970: from hr_organization_information hoi,

966: l_wc_exists := 'N';
967:
968: select 'Y'
969: into l_wc_exists
970: from hr_organization_information hoi,
971: pay_us_states pus
972: where organization_id = p_tax_unit_id
973: and hoi.org_information_context = 'State Tax Rules'
974: and hoi.org_information1 = pus.state_abbrev

Line 1651: FROM hr_organization_information hoi

1647: -- new column added in the fetch for fixing bug 4711572
1648: -- INTO l_org_info19
1649: INTO l_org_info19,
1650: l_local_tax_rules_type
1651: FROM hr_organization_information hoi
1652: WHERE hoi.org_information_context = 'State Tax Rules'
1653: AND hoi.organization_id = p_tax_unit_id
1654: AND hoi.org_information1 = l_state_abbrev;
1655: BEGIN

Line 1664: FROM hr_organization_information hoi

1660: SELECT DECODE(hoi.ORG_INFORMATION19,
1661: 'WORK_LOCALITIES','N',
1662: 'Y') /* State Tax Rules level */
1663: INTO l_wh_work_localities
1664: FROM hr_organization_information hoi
1665: WHERE hoi.org_information_context = 'State Tax Rules'
1666: AND hoi.organization_id = p_tax_unit_id
1667: AND hoi.org_information1 = l_state_abbrev;
1668:

Line 1676: FROM HR_ORGANIZATION_INFORMATION hoi

1672: --{
1673: SELECT DECODE(hoi.ORG_INFORMATION3,'Y','N','N','Y','Y')
1674: /* local level have to check if exempt */
1675: INTO l_city_rs_exists
1676: FROM HR_ORGANIZATION_INFORMATION hoi
1677: WHERE hoi.ORG_INFORMATION_CONTEXT = 'Local Tax Rules'
1678: AND hoi.organization_id = p_tax_unit_id
1679: AND hoi.org_information1 = p_juri_code;
1680: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'

Line 2029: FROM hr_organization_information hoi

2025: BEGIN
2026: /*{*/
2027: SELECT 'N'
2028: INTO l_sui_exists
2029: FROM hr_organization_information hoi
2030: WHERE hoi.org_information_context = '1099R Magnetic Report Rules'
2031: AND hoi.organization_id = p_tax_unit_id
2032: AND hoi.org_information2 IS NOT NULL;
2033:

Line 2157: FROM hr_organization_information hoi

2153:
2154:
2155: CURSOR state_employer_info IS
2156: SELECT DECODE(hoi.org_information2, 'ALL', 'Y', 'STATES', 'N', 'Y')
2157: FROM hr_organization_information hoi
2158: WHERE hoi.org_information_context = 'Employer Identification'
2159: AND hoi.organization_id = p_tax_unit_id;
2160:
2161: CURSOR state_rule IS

Line 2163: FROM hr_organization_information hoi

2159: AND hoi.organization_id = p_tax_unit_id;
2160:
2161: CURSOR state_rule IS
2162: SELECT DECODE(NVL(hoi.org_information18,'00'), 'N', '00', NVL(hoi.org_information18,'00'))
2163: FROM hr_organization_information hoi
2164: WHERE hoi.org_information_context = 'State Tax Rules'
2165: AND hoi.organization_id = p_tax_unit_id
2166: AND hoi.org_information1 = l_state_abbrev;
2167:

Line 2174: FROM hr_organization_information hoi

2170: 'ALL','A',
2171: 'LOCALITIES','L',
2172: 'WORK_LOCALITIES','W',
2173: 'A')
2174: FROM hr_organization_information hoi
2175: WHERE hoi.org_information_context = 'State Tax Rules'
2176: AND hoi.organization_id = p_tax_unit_id
2177: AND hoi.org_information1 = l_state_abbrev;
2178:

Line 2181: FROM hr_organization_information hoi

2177: AND hoi.org_information1 = l_state_abbrev;
2178:
2179: CURSOR local_rule IS
2180: SELECT DECODE(NVL(hoi.org_information3,'00'),'N','00',NVL(hoi.org_information3,'00'))
2181: FROM hr_organization_information hoi
2182: WHERE hoi.org_information_context = 'Local Tax Rules'
2183: AND hoi.organization_id = p_tax_unit_id
2184: AND hoi.org_information1 = p_juri_code;
2185: