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

Line 785: FROM hr_organization_information hoi,

781: p_legal_entity_id legal_employer_id,
782: hoi.org_information3 contact_name,
783: p_reporting_year reporting_year,
784: TO_CHAR(SYSDATE,'YYYYMMDD') issue_date
785: FROM hr_organization_information hoi,
786: hr_organization_units hou
787: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
788: AND hoi.organization_id = hou.organization_id
789: AND hoi.organization_id = c_legal_entity_id ;

Line 1251: FROM hr_organization_information hoi,

1247: SELECT DISTINCT
1248: hou.name employer_name,
1249: hoi.org_information1 employer_tfn,
1250: p_reporting_year reporting_year
1251: FROM hr_organization_information hoi,
1252: hr_organization_units hou
1253: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
1254: AND hoi.organization_id = hou.organization_id
1255: AND hoi.organization_id = c_legal_entity_id ;