APPS.AP_WEB_OA_ACTIVE_PKG SQL Statements

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

Line: 83

    SELECT DISPLAYED_FIELD
    INTO v_ApApprover
    FROM ap_lookup_codes
    WHERE LOOKUP_TYPE = C_EXPENSE_REPORT_APPROVER
    AND   LOOKUP_CODE = C_AP;

Line: 128

    SELECT DISPLAYED_FIELD
    INTO v_ExpensesAdmin
    FROM ap_lookup_codes
    WHERE LOOKUP_TYPE = C_EXPENSE_REPORT_APPROVER
    AND   LOOKUP_CODE = C_EXPADMIN;

Line: 172

  SELECT INSTANCE_LABEL
  INTO v_activity_label
  FROM (
        SELECT PA.INSTANCE_LABEL
        FROM   WF_ITEM_ACTIVITY_STATUSES IAS,
               WF_PROCESS_ACTIVITIES PA
        WHERE
               IAS.ITEM_TYPE        = C_APEXP
               AND IAS.ACTIVITY_STATUS  = C_NOTIFIED
               AND IAS.ITEM_KEY         = TO_CHAR(p_report_header_id)
               AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
               AND IAS.NOTIFICATION_ID IS NOT NULL
               ORDER BY IAS.BEGIN_DATE desc
        )
   WHERE ROWNUM =1;

Line: 364

  SELECT DISPLAYED_FIELD
  INTO v_status
  FROM ap_lookup_codes
  WHERE LOOKUP_TYPE = C_EXPENSE_REPORT_STATUS
  AND   LOOKUP_CODE = v_status_code;

Line: 452

	SELECT erh.report_header_id, source, workflow_approved_flag
	INTO   l_report_header_id , l_source , l_workflow_approved_flaG
	FROM   ap_credit_card_trxns cct, ap_expense_report_headers erh
	WHERE trx_id = p_trx_id
	AND cct.report_header_id = erh.report_header_id;

Line: 519

   SELECT AERH.VOUCHNO, AERH.EXPENSE_STATUS_CODE
   INTO l_cc_vouch_no, l_org_cc_report_status_code
   FROM AP_EXPENSE_REPORT_HEADERS_ALL AERH
   WHERE AERH.BOTHPAY_PARENT_ID=p_report_header_id;

Line: 540

	   SELECT DECODE(AI.CANCELLED_DATE,NULL,
		      DECODE(APS.GROSS_AMOUNT ,0,'PAID',
		      DECODE(AI.PAYMENT_STATUS_FLAG,'Y','PAID',
		      'N','INVOICED',
		      'P','PARPAID',NULL)),
			 'CANCELLED')
	   INTO l_final_status_code
	   FROM
		AP_INVOICES_ALL AI,
		AP_EXPENSE_REPORT_HEADERS_ALL AERH,
		AP_PAYMENT_SCHEDULES_ALL APS
	   WHERE   AERH.VOUCHNO = AI.INVOICE_ID
		AND   AERH.BOTHPAY_PARENT_ID = p_report_header_id
		AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'
		AND AI.INVOICE_ID= APS.INVOICE_ID
		AND AI.VENDOR_ID = AERH.VENDOR_ID;

Line: 567

 SELECT DECODE(AI.CANCELLED_DATE,NULL,
	      DECODE(APS.GROSS_AMOUNT ,0,'PAID',
	      DECODE(AI.PAYMENT_STATUS_FLAG,'Y','PAID',
	      'N','INVOICED',
	      'P','PARPAID',NULL)),
		 'CANCELLED')
   INTO l_cc_report_status_code
   FROM
	AP_INVOICES_ALL AI,
	AP_EXPENSE_REPORT_HEADERS_ALL AERH,
	AP_PAYMENT_SCHEDULES_ALL APS
   WHERE   AERH.VOUCHNO = AI.INVOICE_ID
	AND   AERH.BOTHPAY_PARENT_ID = p_report_header_id
	AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'
	AND AI.INVOICE_ID= APS.INVOICE_ID
	AND AI.VENDOR_ID = AERH.VENDOR_ID;