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

Line 269: l_cc_owner_id HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE := NULL;

265: -------------------------------------------------------------------------
266: IS
267: l_debug_info VARCHAR2(200);
268: l_segment_name FND_SEGMENT_ATTRIBUTE_VALUES.application_column_name%TYPE := NULL;
269: l_cc_owner_id HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE := NULL;
270: l_rows_processed NUMBER := 0;
271: l_cur_hdl INTEGER;
272: l_query_stmt VARCHAR2(4000);
273: l_errorText VARCHAR2(200);

Line 309: (Select Organization_Id,Org_Information2 From Hr_Organization_Information Where Upper(Org_Information_Context) = ''ORGANIZATION NAME ALIAS'')HOIP,

305: -- 3176205: This query will only include current employees
306: -- and contingent workers, not terminated ones.
307: l_query_stmt := 'SELECT distinct HOIP.ORG_INFORMATION2 OWNER_ID
308: FROM GL_CODE_COMBINATIONS GLCC,
309: (Select Organization_Id,Org_Information2 From Hr_Organization_Information Where Upper(Org_Information_Context) = ''ORGANIZATION NAME ALIAS'')HOIP,
310: (Select ORGANIZATION_ID From Hr_Organization_Information Where Upper(Org_Information_Context) = ''COMPANY COST CENTER'') HOIC,
311: (Select Organization_Id From Hr_Organization_Information Where Upper(Org_Information_Context) = ''CLASS'' And Org_Information1 = ''CC'') HOI,
312: PER_WORKFORCE_CURRENT_X PP
313: WHERE ENABLED_FLAG = ''Y''

Line 310: (Select ORGANIZATION_ID From Hr_Organization_Information Where Upper(Org_Information_Context) = ''COMPANY COST CENTER'') HOIC,

306: -- and contingent workers, not terminated ones.
307: l_query_stmt := 'SELECT distinct HOIP.ORG_INFORMATION2 OWNER_ID
308: FROM GL_CODE_COMBINATIONS GLCC,
309: (Select Organization_Id,Org_Information2 From Hr_Organization_Information Where Upper(Org_Information_Context) = ''ORGANIZATION NAME ALIAS'')HOIP,
310: (Select ORGANIZATION_ID From Hr_Organization_Information Where Upper(Org_Information_Context) = ''COMPANY COST CENTER'') HOIC,
311: (Select Organization_Id From Hr_Organization_Information Where Upper(Org_Information_Context) = ''CLASS'' And Org_Information1 = ''CC'') HOI,
312: PER_WORKFORCE_CURRENT_X PP
313: WHERE ENABLED_FLAG = ''Y''
314: AND GLCC.' || l_segment_name || ' = :costCenter

Line 311: (Select Organization_Id From Hr_Organization_Information Where Upper(Org_Information_Context) = ''CLASS'' And Org_Information1 = ''CC'') HOI,

307: l_query_stmt := 'SELECT distinct HOIP.ORG_INFORMATION2 OWNER_ID
308: FROM GL_CODE_COMBINATIONS GLCC,
309: (Select Organization_Id,Org_Information2 From Hr_Organization_Information Where Upper(Org_Information_Context) = ''ORGANIZATION NAME ALIAS'')HOIP,
310: (Select ORGANIZATION_ID From Hr_Organization_Information Where Upper(Org_Information_Context) = ''COMPANY COST CENTER'') HOIC,
311: (Select Organization_Id From Hr_Organization_Information Where Upper(Org_Information_Context) = ''CLASS'' And Org_Information1 = ''CC'') HOI,
312: PER_WORKFORCE_CURRENT_X PP
313: WHERE ENABLED_FLAG = ''Y''
314: AND GLCC.' || l_segment_name || ' = :costCenter
315: AND CHART_OF_ACCOUNTS_ID = :charOfAccountsId