APPS.FA_FASCAPSP_XMLP_PKG SQL Statements

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

Line: 16

  SELECT cr.concurrent_program_id
  INTO l_conc_program_id
  FROM FND_CONCURRENT_REQUESTS cr
  WHERE cr.program_application_id = 140
  AND   cr.request_id = P_CONC_REQUEST_ID;

Line: 22

  SELECT cp.user_concurrent_program_name
  INTO   l_report_name
  FROM    FND_CONCURRENT_PROGRAMS_VL cp
  WHERE
      cp.concurrent_program_id= l_conc_program_id
  and cp.application_id = 140;

Line: 67

  SELECT
        FY_TAX.FISCAL_YEAR,
	FY_TAX.END_DATE
  INTO
        L_FISCAL_YEAR,
	L_END_DATE
  FROM  FA_FISCAL_YEAR FY_TAX,
	FA_BOOK_CONTROLS BC_TAX
  WHERE BC_TAX.BOOK_TYPE_CODE = P_TAX_BOOK AND
	BC_TAX.FISCAL_YEAR_NAME = FY_TAX.FISCAL_YEAR_NAME
  AND	P_DPIS BETWEEN FY_TAX.START_DATE AND FY_TAX.END_DATE;

Line: 79

  SELECT
	DP_BUD.PERIOD_NUM
  INTO
	L_PERIOD_NUM
  FROM  FA_DEPRN_PERIODS DP_BUD,
	FA_FISCAL_YEAR FY_BUD,
	FA_BOOK_CONTROLS BC_BUD
  WHERE BC_BUD.BOOK_TYPE_CODE = P_BUDGET_BOOK	AND
	P_DPIS BETWEEN FY_BUD.START_DATE AND FY_BUD.END_DATE
  AND	FY_BUD.FISCAL_YEAR_NAME = BC_BUD.FISCAL_YEAR_NAME
  AND	DP_BUD.BOOK_TYPE_CODE = P_BUDGET_BOOK AND
	DP_BUD.FISCAL_YEAR = FY_BUD.FISCAL_YEAR AND
	DP_BUD.PERIOD_CLOSE_DATE IS NULL;