DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPTEMPLATE_PKG dependencies on AP_LOOKUP_CODES

Line 35: FROM ap_lookup_codes lc,

31: BEGIN
32: OPEN P_cursor FOR
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'

Line 478: FROM ap_lookup_codes lc,

474: ------------------------------------------------------------------------
475:
476: SELECT erp.calculate_amount_flag
477: INTO l_calculate_amount_enabled
478: FROM ap_lookup_codes lc,
479: ap_expense_report_params erp
480: WHERE (erp.expense_report_id = to_number(p_template_id)
481: AND erp.parameter_id = to_number(p_parameter_id))
482: AND erp.line_type_lookup_code = lc.lookup_code