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 458: FROM ap_lookup_codes lc,

454: ------------------------------------------------------------------------
455:
456: SELECT erp.calculate_amount_flag
457: INTO l_calculate_amount_enabled
458: FROM ap_lookup_codes lc,
459: ap_expense_report_params erp
460: WHERE (erp.expense_report_id = to_number(p_template_id)
461: AND erp.parameter_id = to_number(p_parameter_id))
462: AND erp.line_type_lookup_code = lc.lookup_code