APPS.AP_WEB_CUST_AME_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 93: FROM ap_expense_report_headers_all aeh

89: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
90: BEGIN
91: SELECT aeh.week_end_date, aeh.employee_id, flex_concatenated
92: INTO l_week_end_date, l_employee_id, l_cost_center
93: FROM ap_expense_report_headers_all aeh
94: WHERE report_header_id = p_report_header_id;
95:
96: -----------------------------------------------------
97: l_debug_info := 'Check whether user entered an Approver';

Line 401: ap_expense_report_headers_all erh

397: SELECT GS.chart_of_accounts_id
398: INTO l_char_of_accounts_id
399: FROM ap_system_parameters_all S,
400: gl_sets_of_books GS,
401: ap_expense_report_headers_all erh
402: WHERE GS.set_of_books_id = S.set_of_books_id
403: AND S.org_id = erh.org_id
404: AND erh.report_header_id = p_report_header_id;
405:

Line 540: FROM AP_EXPENSE_REPORT_HEADERS_ALL

536: l_debug_info := 'Check whether entered Cost Center equals to Employee Default Cost Center';
537: -----------------------------------------------------
538: SELECT employee_id, flex_concatenated
539: INTO l_employee_id, l_cost_center
540: FROM AP_EXPENSE_REPORT_HEADERS_ALL
541: WHERE report_header_id = p_report_header_id;
542:
543: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(
544: l_employee_name,

Line 654: from ap_expense_report_headers_all

650:
651: BEGIN
652:
653: select employee_id into l_employee_id
654: from ap_expense_report_headers_all
655: where report_header_id = p_report_header_id;
656:
657: --------------------------------------------------------------
658: l_debug_info := 'Calling AP_WEB_DB_HR_INT_PKG.IsPersonActive';

Line 792: from ap_expense_report_headers_all

788: if (p_item_class = 'header') then
789:
790: select override_approver_id, employee_id
791: into l_override_approver_id, l_employee_id
792: from ap_expense_report_headers_all
793: where report_header_id = p_report_header_id;
794:
795: -- Bug 14158542: Terminated employee expense reports skips the first manager for approval
796: IF l_override_approver_id IS NULL THEN