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

850: p_legal_entity_id legal_employer_id,
851: hoi.org_information3 contact_name,
852: p_reporting_year reporting_year,
853: TO_CHAR(SYSDATE,'YYYYMMDD') issue_date
854: FROM hr_organization_information hoi,
855: hr_organization_units hou
856: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
857: AND hoi.organization_id = hou.organization_id
858: AND hoi.organization_id = c_legal_entity_id ;

Line 1320: FROM hr_organization_information hoi,

1316: SELECT DISTINCT
1317: hou.name employer_name,
1318: hoi.org_information1 employer_tfn,
1319: p_reporting_year reporting_year
1320: FROM hr_organization_information hoi,
1321: hr_organization_units hou
1322: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
1323: AND hoi.organization_id = hou.organization_id
1324: AND hoi.organization_id = c_legal_entity_id ;