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_US_MWR_REPORTING_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 334: hr_organization_information hoi1,

330: SELECT /*+ use_nl (hoi1, hoi2)*/
331: hoi1.org_information2,
332: hoi2.org_information1
333: FROM pay_state_rules SR,
334: hr_organization_information hoi1,
335: hr_organization_information hoi2
336: WHERE hoi1.organization_id = p_tax_unit_id
337: AND hoi1.org_information_context = 'State Tax Rules'
338: AND hoi1.org_information1 = SR.state_code

Line 335: hr_organization_information hoi2

331: hoi1.org_information2,
332: hoi2.org_information1
333: FROM pay_state_rules SR,
334: hr_organization_information hoi1,
335: hr_organization_information hoi2
336: WHERE hoi1.organization_id = p_tax_unit_id
337: AND hoi1.org_information_context = 'State Tax Rules'
338: AND hoi1.org_information1 = SR.state_code
339: AND SR.jurisdiction_code = substr(p_jurisdiction,1,2)||'-000-0000'

Line 693: hr_organization_information hoi1

689:
690: SELECT hoi1.org_information2
691: INTO l_sui_id
692: FROM pay_state_rules SR,
693: hr_organization_information hoi1
694: WHERE hoi1.organization_id = l_tax_unit_id
695: AND hoi1.org_information_context = 'State Tax Rules'
696: AND hoi1.org_information1 = SR.state_code
697: AND SR.jurisdiction_code =

Line 755: hr_organization_information hoi1

751:
752: SELECT hoi1.org_information2
753: INTO l_sui_id
754: FROM pay_state_rules SR,
755: hr_organization_information hoi1
756: WHERE hoi1.organization_id = l_tax_unit_id
757: AND hoi1.org_information_context = 'State Tax Rules'
758: AND hoi1.org_information1 = SR.state_code
759: AND SR.jurisdiction_code = substr(l_sqwl_jurisdiction_code,1,2)||'-000-0000';