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 352: hr_organization_information hoi1,

348: SELECT /*+ use_nl (hoi1, hoi2)*/
349: hoi1.org_information2,
350: hoi2.org_information1
351: FROM pay_state_rules SR,
352: hr_organization_information hoi1,
353: hr_organization_information hoi2
354: WHERE hoi1.organization_id = p_tax_unit_id
355: AND hoi1.org_information_context = 'State Tax Rules'
356: AND hoi1.org_information1 = SR.state_code

Line 353: hr_organization_information hoi2

349: hoi1.org_information2,
350: hoi2.org_information1
351: FROM pay_state_rules SR,
352: hr_organization_information hoi1,
353: hr_organization_information hoi2
354: WHERE hoi1.organization_id = p_tax_unit_id
355: AND hoi1.org_information_context = 'State Tax Rules'
356: AND hoi1.org_information1 = SR.state_code
357: AND SR.jurisdiction_code = substr(p_jurisdiction,1,2)||'-000-0000'

Line 865: hr_organization_information hoi1

861:
862: SELECT hoi1.org_information2
863: INTO l_sui_id
864: FROM pay_state_rules SR,
865: hr_organization_information hoi1
866: WHERE hoi1.organization_id = l_tax_unit_id
867: AND hoi1.org_information_context = 'State Tax Rules'
868: AND hoi1.org_information1 = SR.state_code
869: AND SR.jurisdiction_code =

Line 989: hr_organization_information hoi1

985:
986: SELECT hoi1.org_information2
987: INTO l_sui_id
988: FROM pay_state_rules SR,
989: hr_organization_information hoi1
990: WHERE hoi1.organization_id = l_tax_unit_id
991: AND hoi1.org_information_context = 'State Tax Rules'
992: AND hoi1.org_information1 = SR.state_code
993: AND SR.jurisdiction_code = substr(l_sqwl_jurisdiction_code,1,2)||'-000-0000';