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 519: FROM hr_organization_information hoi

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

Line 532: FROM hr_organization_information hoi

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

Line 546: FROM HR_ORGANIZATION_INFORMATION hoi

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

Line 830: FROM HR_ORGANIZATION_INFORMATION hoi

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

Line 839: FROM HR_ORGANIZATION_INFORMATION hoi

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

Line 967: from hr_organization_information hoi,

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

Line 1648: FROM hr_organization_information hoi

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

Line 1661: FROM hr_organization_information hoi

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

Line 1673: FROM HR_ORGANIZATION_INFORMATION hoi

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

Line 2026: FROM hr_organization_information hoi

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

Line 2154: FROM hr_organization_information hoi

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

Line 2160: FROM hr_organization_information hoi

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

Line 2171: FROM hr_organization_information hoi

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

Line 2178: FROM hr_organization_information hoi

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