APPS.AP_WEB_AUDIT_UTILS dependencies on AP_EXPENSE_REPORT_PARAMS

Line 407: FROM AP_EXPENSE_REPORT_PARAMS_ALL

403: FUNCTION get_expense_type(p_parameter_id IN NUMBER) RETURN VARCHAR2 IS
404:
405: CURSOR expense_type_cur IS
406: SELECT nvl(WEB_FRIENDLY_PROMPT, PROMPT) expense_type_prompt
407: FROM AP_EXPENSE_REPORT_PARAMS_ALL
408: WHERE PARAMETER_ID = p_parameter_id;
409:
410: expense_type_rec expense_type_cur%ROWTYPE;
411: BEGIN

Line 758: ap_expense_report_params_all aerp

754: p_distribution_line_number IN NUMBER) RETURN VARCHAR2 IS
755: CURSOR template_cur IS
756: select prompt web_prompt
757: from ap_expense_report_lines_all aerl,
758: ap_expense_report_params_all aerp
759: where aerl.report_header_id = p_report_header_id
760: and aerl.distribution_line_number = p_distribution_line_number
761: and aerp.parameter_id = aerl.web_parameter_id;
762:

Line 1966: 'AP_EXPENSE_REPORT_PARAMS_ALL',

1962: BEGIN
1963: return get_object_info(to_char(p_parameter_id),
1964: p_column,
1965: p_data_type,
1966: 'AP_EXPENSE_REPORT_PARAMS_ALL',
1967: 'parameter_id');
1968: END get_expense_item_info;
1969:
1970: /*==================== ====================================================

Line 2372: FROM ap_expense_report_params erp

2368: FUNCTION get_seeded_expense_id(p_expense_type_code IN VARCHAR2) RETURN NUMBER IS
2369:
2370: CURSOR seeded_expense_cur IS
2371: SELECT parameter_id
2372: FROM ap_expense_report_params erp
2373: WHERE erp.expense_type_code = p_expense_type_code;
2374:
2375: seeded_expense_rec seeded_expense_cur%ROWTYPE;
2376:

Line 2776: ap_expense_report_params_all erp

2772: NVL(end_expense_date - start_expense_date,0)+1 number_of_days,
2773: ph.day_period_code
2774: from ap_expense_report_lines_all aerl,
2775: ap_pol_headers ph,
2776: ap_expense_report_params_all erp
2777: where aerl.report_header_id = p_report_header_id
2778: and aerl.distribution_line_number = p_distribution_line_number
2779: and aerl.category_code = AP_WEB_POLICY_UTILS.c_PER_DIEM
2780: and erp.parameter_id = aerl.web_parameter_id