APPS.AP_WEB_DB_EXPTEMPLATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

    SELECT expense_report_id, report_type
    FROM   ap_expense_reports
    WHERE  web_enabled_flag = 'Y'
    AND    trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
    AND    AP_WEB_DB_EXPTEMPLATE_PKG.IsExpTemplateWebEnabled(expense_report_id) = 'Y'
    ORDER BY UPPER(report_type);

Line: 33

    SELECT  nvl(erp.web_friendly_prompt, erp.prompt),
            to_char(erp.parameter_id)
    FROM    ap_lookup_codes lc,
            ap_expense_report_params erp,
	    ap_expense_reports er
    WHERE   (erp.expense_report_id = p_xtemplateid
    OR      ( erp.web_enabled_flag = 'Y'
	       AND     trunc(sysdate) <= trunc(nvl(er.inactive_date, sysdate))
	     )
            )
    AND     lc.lookup_type = 'INVOICE DISTRIBUTION TYPE'
    AND     erp.expense_report_id = er.expense_report_id
    AND     erp.line_type_lookup_code = lc.lookup_code
    AND     trunc(sysdate) <= trunc(nvl(erp.end_date, sysdate))
    ORDER BY nvl(web_friendly_prompt, prompt);

Line: 65

    SELECT  nvl(web_friendly_prompt, prompt) web_prompt,
            erp.parameter_id,
            erp.justification_required_flag,
            erp.require_receipt_amount
    FROM    ap_expense_report_params erp;

Line: 89

    SELECT  distinct erp.parameter_id,
            nvl(erp.web_friendly_prompt,erp.prompt) web_prompt,
	    erp.require_receipt_amount,
	    erp.card_exp_type_lookup_code,
            erp.amount_includes_tax_flag,
	    nvl(erp.justification_required_flag,'V') justif_req
    FROM    ap_expense_report_params erp,
	    ap_expense_reports er
    WHERE   erp.expense_report_id = p_report_id
       OR   (erp.web_enabled_flag = 'Y'
       AND   er.web_enabled_flag = 'Y'
       AND    trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
       AND   erp.expense_report_id = er.expense_report_id)
       AND    trunc(sysdate) <= trunc(nvl(erp.end_date, sysdate))
    ORDER BY web_prompt;

Line: 122

    SELECT  erp.parameter_id,
	    nvl(erp.web_friendly_prompt,erp.prompt) web_prompt,
 	    erp.prompt,
	    erp.require_receipt_amount,
	    card_exp_type_lookup_code,
	    nvl(erp.justification_required_flag,'V') justif_req,
	    calculate_amount_flag,
	    erp.amount_includes_tax_flag,
	    erp.pa_expenditure_type
    FROM    ap_expense_report_params erp,
	    ap_expense_reports er
    WHERE   erp.expense_report_id = er.expense_report_id
      AND   trunc(sysdate) <= trunc(nvl(er.inactive_date, sysdate))
      AND   trunc(sysdate) <= trunc(nvl(erp.end_date, sysdate))
      AND   er.web_enabled_flag = 'Y';

Line: 155

    SELECT  erp.parameter_id
    FROM    ap_expense_report_params erp
    WHERE   nvl(erp.justification_required_flag,'V') = 'Y'
    ORDER BY nvl(web_friendly_prompt, prompt);

Line: 183

      SELECT report_type
      INTO   P_TemplateName
      FROM   ap_expense_reports                                                      WHERE  web_enabled_flag = 'Y'
      AND    expense_report_id = P_TemplateID;

Line: 210

	SELECT 	expense_report_id
	INTO	p_exp_temp_id
	FROM	ap_expense_reports
	WHERE	web_enabled_flag = 'Y'
        AND     trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
	AND	report_type = p_report_type;

Line: 227

	SELECT 	expense_report_id
	INTO	p_exp_temp_id
	FROM	ap_expense_reports
	WHERE	web_enabled_flag = 'Y'
    AND     trunc(sysdate) <= trunc(nvl(inactive_date + v_graceperiod, sysdate))
	AND	report_type = p_report_type;

Line: 251

      SELECT prompt
      INTO   p_exp_prompt
      FROM   ap_expense_report_params
      WHERE  parameter_id = p_parameter_id;

Line: 272

  SELECT parameter_id
  INTO p_parameter_id
  FROM ap_expense_report_params
  WHERE expense_type_code = 'PERSONAL';

Line: 299

  SELECT FLEX_CONCACTENATED,
         VAT_CODE,
         AMOUNT_INCLUDES_TAX_FLAG,
         LINE_TYPE_LOOKUP_CODE,
	 PA_EXPENDITURE_TYPE
  INTO   P_ExpTypeRec.flex_concat,
         P_ExpTypeRec.vat_code,
         P_ExpTypeRec.amt_incl_tax,
         P_ExpTypeRec.line_type,
	 p_ExpTypeRec.pa_exp_type
  FROM AP_EXPENSE_REPORT_PARAMS
  WHERE PARAMETER_ID = P_ExpTypeID;

Line: 382

  SELECT    COUNT(*)
  INTO      p_count
  FROM      ap_expense_reports
  WHERE     web_enabled_flag = 'Y'
  AND       trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
  AND       AP_WEB_DB_EXPTEMPLATE_PKG.IsExpTemplateWebEnabled(expense_report_id) = 'Y';

Line: 415

	  SELECT nvl(prompt,'ITEM'),
                 nvl(line_type_lookup_code,'ITEM'),
	         nvl(require_receipt_amount,-1)
          INTO   p_item_description,
                 p_line_type_lookup_code,
	         p_require_receipt_amount
          FROM   AP_EXPENSE_REPORT_PARAMS
          WHERE  parameter_id = p_xtype;

Line: 476

    SELECT  erp.calculate_amount_flag
    INTO    l_calculate_amount_enabled
    FROM    ap_lookup_codes lc,
            ap_expense_report_params erp
    WHERE   (erp.expense_report_id 	= to_number(p_template_id)
    AND      erp.parameter_id 		= to_number(p_parameter_id))
    AND     erp.line_type_lookup_code = lc.lookup_code
    AND     lc.lookup_type = 'INVOICE DISTRIBUTION TYPE';

Line: 530

  SELECT require_receipt_amount
  INTO p_require_receipt_amount
  FROM AP_EXPENSE_REPORT_PARAMS
  WHERE PARAMETER_ID = P_ExpTypeID;

Line: 557

  SELECT parameter_id
  INTO p_parameter_id
  FROM ap_expense_report_params
  WHERE expense_type_code = 'ROUNDING';