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: HR_ORGANIZATION_INFORMATION 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: HR_ORGANIZATION_INFORMATION HOIP,
310: HR_ORGANIZATION_INFORMATION HOIC,
311: HR_ORGANIZATION_INFORMATION HOI,
312: PER_WORKFORCE_CURRENT_X PP,
313: AP_EXPENSE_REPORT_LINES_ALL LINES

Line 310: HR_ORGANIZATION_INFORMATION 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: HR_ORGANIZATION_INFORMATION HOIP,
310: HR_ORGANIZATION_INFORMATION HOIC,
311: HR_ORGANIZATION_INFORMATION HOI,
312: PER_WORKFORCE_CURRENT_X PP,
313: AP_EXPENSE_REPORT_LINES_ALL LINES
314: WHERE ENABLED_FLAG = ''Y''

Line 311: HR_ORGANIZATION_INFORMATION HOI,

307: l_query_stmt := 'SELECT distinct HOIP.ORG_INFORMATION2 OWNER_ID
308: FROM GL_CODE_COMBINATIONS GLCC,
309: HR_ORGANIZATION_INFORMATION HOIP,
310: HR_ORGANIZATION_INFORMATION HOIC,
311: HR_ORGANIZATION_INFORMATION HOI,
312: PER_WORKFORCE_CURRENT_X PP,
313: AP_EXPENSE_REPORT_LINES_ALL LINES
314: WHERE ENABLED_FLAG = ''Y''
315: AND GLCC.' || l_segment_name || ' = :costCenter