APPS.AP_WEB_CUST_AME_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 374: l_cc_business_mgr_id HR_ORGANIZATION_INFORMATION.ATTRIBUTE2%TYPE := NULL;

370: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2
371: -------------------------------------------------------------------------
372: IS
373: l_debug_info VARCHAR2(200);
374: l_cc_business_mgr_id HR_ORGANIZATION_INFORMATION.ATTRIBUTE2%TYPE := NULL;
375: l_segment_name FND_SEGMENT_ATTRIBUTE_VALUES.application_column_name%TYPE := NULL;
376: l_rows_processed NUMBER := 0;
377: l_cur_hdl INTEGER;
378: l_query_stmt VARCHAR2(4000);

Line 414: HR_ORGANIZATION_INFORMATION HOIP,

410: -- and contingent workers, not terminated ones.
411:
412: l_query_stmt := 'SELECT DISTINCT HOIP.ATTRIBUTE2 business_manager_id
413: FROM GL_CODE_COMBINATIONS GLCC,
414: HR_ORGANIZATION_INFORMATION HOIP,
415: HR_ORGANIZATION_INFORMATION HOIC,
416: HR_ORGANIZATION_INFORMATION HOI,
417: PER_WORKFORCE_CURRENT_X PP
418: WHERE ENABLED_FLAG = ''Y''

Line 415: HR_ORGANIZATION_INFORMATION HOIC,

411:
412: l_query_stmt := 'SELECT DISTINCT HOIP.ATTRIBUTE2 business_manager_id
413: FROM GL_CODE_COMBINATIONS GLCC,
414: HR_ORGANIZATION_INFORMATION HOIP,
415: HR_ORGANIZATION_INFORMATION HOIC,
416: HR_ORGANIZATION_INFORMATION HOI,
417: PER_WORKFORCE_CURRENT_X PP
418: WHERE ENABLED_FLAG = ''Y''
419: AND GLCC.' || l_segment_name || ' = :costCenter

Line 416: HR_ORGANIZATION_INFORMATION HOI,

412: l_query_stmt := 'SELECT DISTINCT HOIP.ATTRIBUTE2 business_manager_id
413: FROM GL_CODE_COMBINATIONS GLCC,
414: HR_ORGANIZATION_INFORMATION HOIP,
415: HR_ORGANIZATION_INFORMATION HOIC,
416: HR_ORGANIZATION_INFORMATION HOI,
417: PER_WORKFORCE_CURRENT_X PP
418: WHERE ENABLED_FLAG = ''Y''
419: AND GLCC.' || l_segment_name || ' = :costCenter
420: AND CHART_OF_ACCOUNTS_ID = :charOfAccountsId