APPS.AP_WEB_AUDIT_UTILS dependencies on AP_EXPENSE_REPORT_PARAMS_ALL

Line 440: FROM AP_EXPENSE_REPORT_PARAMS_ALL

436: FUNCTION get_expense_type(p_parameter_id IN NUMBER) RETURN VARCHAR2 IS
437:
438: CURSOR expense_type_cur IS
439: SELECT nvl(WEB_FRIENDLY_PROMPT, PROMPT) expense_type_prompt
440: FROM AP_EXPENSE_REPORT_PARAMS_ALL
441: WHERE PARAMETER_ID = p_parameter_id;
442:
443: expense_type_rec expense_type_cur%ROWTYPE;
444: BEGIN

Line 797: ap_expense_report_params_all aerp

793: p_distribution_line_number IN NUMBER) RETURN VARCHAR2 IS
794: CURSOR template_cur IS
795: select prompt web_prompt
796: from ap_expense_report_lines_all aerl,
797: ap_expense_report_params_all aerp
798: where aerl.report_header_id = p_report_header_id
799: and aerl.distribution_line_number = p_distribution_line_number
800: and aerp.parameter_id = aerl.web_parameter_id;
801:

Line 2008: 'AP_EXPENSE_REPORT_PARAMS_ALL',

2004: BEGIN
2005: return get_object_info(to_char(p_parameter_id),
2006: p_column,
2007: p_data_type,
2008: 'AP_EXPENSE_REPORT_PARAMS_ALL',
2009: 'parameter_id');
2010: END get_expense_item_info;
2011:
2012: /*==================== ====================================================

Line 2818: ap_expense_report_params_all erp

2814: NVL(end_expense_date - start_expense_date,0)+1 number_of_days,
2815: ph.day_period_code
2816: from ap_expense_report_lines_all aerl,
2817: ap_pol_headers ph,
2818: ap_expense_report_params_all erp
2819: where aerl.report_header_id = p_report_header_id
2820: and aerl.distribution_line_number = p_distribution_line_number
2821: and aerl.category_code = AP_WEB_POLICY_UTILS.c_PER_DIEM
2822: and erp.parameter_id = aerl.web_parameter_id