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.FII_GL_EXTRACTION_UTIL dependencies on HR_ORGANIZATION_INFORMATION

Line 64: from hr_organization_information ccc_tbl,

60: to_number (mgr_tbl.org_information2) manager,
61: ccc_tbl.organization_id ccc_org_id,
62: fv1.flex_value_id com_id,
63: fv2.flex_value_id cc_id
64: from hr_organization_information ccc_tbl,
65: ( select /*+ parallel(b) */ organization_id, org_information2
66: from hr_organization_information b
67: where org_information_context = 'Organization Name Alias'
68: and nvl( fnd_date.canonical_to_date( org_information3 ),

Line 66: from hr_organization_information b

62: fv1.flex_value_id com_id,
63: fv2.flex_value_id cc_id
64: from hr_organization_information ccc_tbl,
65: ( select /*+ parallel(b) */ organization_id, org_information2
66: from hr_organization_information b
67: where org_information_context = 'Organization Name Alias'
68: and nvl( fnd_date.canonical_to_date( org_information3 ),
69: sysdate + 1 ) <= sysdate
70: and nvl( fnd_date.canonical_to_date( org_information4 ),

Line 73: hr_organization_information org,

69: sysdate + 1 ) <= sysdate
70: and nvl( fnd_date.canonical_to_date( org_information4 ),
71: sysdate + 1 ) >= sysdate
72: ) mgr_tbl,
73: hr_organization_information org,
74: fnd_flex_values fv1,
75: fnd_flex_values fv2
76: where ccc_tbl.org_information_context = 'CLASS'
77: and ccc_tbl.org_information1 = 'CC'