APPS.AP_CARD_DATABASE_PKG SQL Statements

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

Line: 12

    SELECT	card_program_currency_code
    INTO 	p_curr_code
    FROM 	ap_card_programs
    WHERE 	card_program_id = p_card_prog_id;

Line: 37

  SELECT lookup_code, displayed_field
  FROM   ap_lookup_codes
  WHERE  lookup_type = p_lookup_type;

Line: 60

	 SELECT fndcvl.name,
         	NVL(fndcvl.precision,0),
         	fndcvl.minimum_accountable_unit
	 INTO	p_curr_name,
		p_precision,
		p_minimum_acct_unit
         FROM   fnd_currencies_vl fndcvl
	 WHERE	currency_code = p_curr_code;

Line: 87

  SELECT  GS.chart_of_accounts_id
  INTO    p_chart_of_accounts
  FROM    ap_system_parameters S,
          gl_sets_of_books GS
  WHERE   GS.set_of_books_id = S.set_of_books_id;

Line: 117

  SELECT  rowidtochar(ROWID)
  INTO    P_ROW_ID
  FROM    AK_FLOW_REGION_RELATIONS
  WHERE   FROM_REGION_CODE = P_FROM_REGION_CODE
  AND     FROM_REGION_APPL_ID = P_APPLICATION_ID
  AND     FROM_PAGE_CODE = P_FROM_PAGE_CODE
  AND     FROM_PAGE_APPL_ID = P_APPLICATION_ID
  AND     TO_PAGE_CODE = P_TO_PAGE_CODE
  AND     TO_PAGE_APPL_ID = P_APPLICATION_ID
  AND     FLOW_CODE = P_FLOW_CODE
  AND     FLOW_APPLICATION_ID = P_APPLICATION_ID;

Line: 146

 SELECT  EMP.full_name,
	 EMP.employee_num,
         EMP.default_code_combination_id
  INTO   p_emp_info_rec.employee_name,
	 p_emp_info_rec.employee_num,
         p_emp_info_rec.emp_ccid
  FROM   hr_employees_current_v EMP
  WHERE  EMP.employee_id = p_employee_id;