APPS.AP_WEB_DB_EXPTEMPLATE_PKG dependencies on AP_EXPENSE_REPORTS

Line 10: FROM ap_expense_reports

6: --------------------------------------------------------------------------------
7: BEGIN
8: OPEN p_cursor FOR
9: SELECT expense_report_id, report_type
10: FROM ap_expense_reports
11: WHERE web_enabled_flag = 'Y'
12: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
13: AND AP_WEB_DB_EXPTEMPLATE_PKG.IsExpTemplateWebEnabled(expense_report_id) = 'Y'
14: ORDER BY UPPER(report_type);

Line 37: ap_expense_reports er

33: SELECT nvl(erp.web_friendly_prompt, erp.prompt),
34: to_char(erp.parameter_id)
35: FROM ap_lookup_codes lc,
36: ap_expense_report_params erp,
37: ap_expense_reports er
38: WHERE (erp.expense_report_id = p_xtemplateid
39: OR ( erp.web_enabled_flag = 'Y'
40: AND trunc(sysdate) <= trunc(nvl(er.inactive_date, sysdate))
41: )

Line 96: ap_expense_reports er

92: erp.card_exp_type_lookup_code,
93: erp.amount_includes_tax_flag,
94: nvl(erp.justification_required_flag,'V') justif_req
95: FROM ap_expense_report_params erp,
96: ap_expense_reports er
97: WHERE erp.expense_report_id = p_report_id
98: OR (erp.web_enabled_flag = 'Y'
99: AND er.web_enabled_flag = 'Y'
100: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))

Line 132: ap_expense_reports er

128: calculate_amount_flag,
129: erp.amount_includes_tax_flag,
130: erp.pa_expenditure_type
131: FROM ap_expense_report_params erp,
132: ap_expense_reports er
133: WHERE erp.expense_report_id = er.expense_report_id
134: AND trunc(sysdate) <= trunc(nvl(er.inactive_date, sysdate))
135: AND trunc(sysdate) <= trunc(nvl(erp.end_date, sysdate))
136: AND er.web_enabled_flag = 'Y';

Line 185: FROM ap_expense_reports WHERE web_enabled_flag = 'Y'

181: l_debugInfo := 'getTemplateName';
182: -------------------------------------------------------
183: SELECT report_type
184: INTO P_TemplateName
185: FROM ap_expense_reports WHERE web_enabled_flag = 'Y'
186: AND expense_report_id = P_TemplateID;
187:
188: return TRUE;
189: EXCEPTION

Line 209: FROM ap_expense_reports

205: BEGIN
206: -- Fix 1472710, Added check to verify if the template is valid.
207: SELECT expense_report_id
208: INTO p_exp_temp_id
209: FROM ap_expense_reports
210: WHERE web_enabled_flag = 'Y'
211: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
212: AND report_type = p_report_type;
213:

Line 304: FUNCTION IsExpTemplateWebEnabled(p_expense_report_id IN ap_expense_reports.expense_report_id%TYPE)

300: END GetExpTypeInfo;
301:
302:
303: -------------------------------------------------------------------
304: FUNCTION IsExpTemplateWebEnabled(p_expense_report_id IN ap_expense_reports.expense_report_id%TYPE)
305: RETURN VARCHAR2 IS
306: -------------------------------------------------------------------
307:
308: l_exp_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;

Line 364: FROM ap_expense_reports

360: -------------------------------------------------------------------
361: BEGIN
362: SELECT COUNT(*)
363: INTO p_count
364: FROM ap_expense_reports
365: WHERE web_enabled_flag = 'Y'
366: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
367: AND AP_WEB_DB_EXPTEMPLATE_PKG.IsExpTemplateWebEnabled(expense_report_id) = 'Y';
368: