APPS.AP_CARD_UTILITY_PKG SQL Statements

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

Line: 262

			 p_update in boolean default TRUE) return boolean is
-------------------------------------------------------------------------------
begin

  return icx_sec.VALIDATESESSION(P_FUNC, '', P_COMMIT, P_UPDATE);

Line: 289

    SELECT DISTINCT(NVL(FL.ORG_ID,FD.ORG_ID))
    INTO   L_ORG_ID
    FROM   AP_EXPENSE_FEED_LINES_ALL FL,
	   AP_EXPENSE_FEED_DISTS_ALL FD
    WHERE  FL.EMPLOYEE_VERIFICATION_ID = P_ID
    OR     (FD.FEED_LINE_ID = FL.FEED_LINE_ID AND
	   FD.EMPLOYEE_VERIFICATION_ID = P_ID);

Line: 301

    SELECT DISTINCT(ORG_ID)
    INTO   L_ORG_ID
    FROM   AP_EXPENSE_FEED_DISTS_ALL
    WHERE  MANAGER_APPROVAL_ID = P_ID;

Line: 355

  SELECT 1
   INTO v_numRows
  FROM DUAL
  WHERE EXISTS
  (SELECT 1
   FROM
     per_cont_workers_current_x p
   WHERE
     p.person_id = p_person_id);

Line: 384

  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
  and     S.org_id = P_ORG_ID; -- Bug 13087600.

Line: 409

          select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
          from fnd_flex_value_sets
          where flex_value_set_name like p_value_set_name
          and PARENT_FLEX_VALUE_SET_ID is not null;

Line: 416

          SELECT s.segment_num into p_dependent_seg_num
          FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
          fnd_segment_attribute_types sat
            WHERE s.application_id = 101
            AND s.id_flex_code = 'GL#'
            AND s.id_flex_num = p_chart_of_accounts_id
            AND s.enabled_flag = 'Y'
            AND s.application_column_name = sav.application_column_name
            AND sav.application_id = 101
            AND sav.id_flex_code = 'GL#'
            AND sav.id_flex_num = p_chart_of_accounts_id
            AND sav.attribute_value = 'Y'
            AND sav.segment_attribute_type = sat.segment_attribute_type
            AND sat.application_id = 101
            AND sat.id_flex_code = 'GL#'
            AND sat.unique_flag = 'Y'
            AND s.FLEX_VALUE_SET_ID=l_parent_flex_value_set_id
            AND rownum =1;

Line: 476

     SELECT emp.set_of_books_id, emp.default_code_combination_id
     INTO l_emp_set_of_books_id, l_default_emp_ccid
     FROM  per_employees_x emp
     WHERE  emp.employee_id = l_employee_id;

Line: 481

     SELECT emp.set_of_books_id, emp.default_code_combination_id
     INTO l_emp_set_of_books_id, l_default_emp_ccid
     FROM  per_cont_workers_current_x emp
     WHERE  emp.person_id = l_employee_id;

Line: 492

      SELECT GS.chart_of_accounts_id
      INTO   l_emp_chart_of_accounts_id
      FROM   gl_sets_of_books GS
      WHERE  GS.set_of_books_id = l_emp_set_of_books_id;