APPS.CSTPDPPC SQL Statements

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

Line: 24

	UPDATE
	cst_pac_process_phases
	SET
	process_status = i_status,
        process_date = SYSDATE,
        process_upto_date = (select decode(i_status,4,process_upto_date,NULL)
                           from cst_pac_process_phases
                           where process_phase = 5
                           and cost_group_id = i_cost_group_id
                           and pac_period_id = i_period_id),
        last_update_date = SYSDATE,
        last_updated_by = nvl(i_user_id,-1),
        request_id = i_request_id,
        program_application_id = i_prog_appl_id,
        program_id = i_prog_id,
        program_update_date = SYSDATE,
        last_update_login = i_login_id
        WHERE pac_period_id = i_period_id
        AND cost_group_id = i_cost_group_id
        AND process_phase = 6;

Line: 316

  SELECT
  count(*)
  INTO
  l_le_exists
  FROM
  cst_le_cost_types
  WHERE
  legal_entity = i_legal_entity AND
  create_acct_entries ='Y';

Line: 332

  SELECT
  count(*)
  INTO
  l_ct_exists
  FROM
  cst_le_cost_types clct, cst_cost_types cct
  WHERE
  clct.legal_entity = i_legal_entity AND
  clct.cost_type_id = i_cost_type_id AND
  clct.create_acct_entries = 'Y' AND
  clct.cost_type_id = cct.cost_type_id AND
  nvl(cct.disable_date, sysdate +1) > sysdate;

Line: 351

  SELECT
  count(*)
  INTO
  l_cg_exists
  FROM
  cst_cost_groups ccg
  WHERE
  legal_entity = i_legal_entity AND
  cost_group_id = i_cost_group_id;

Line: 368

    SELECT
    count(*)
    INTO
    l_per_exists
    FROM
    cst_pac_periods
    WHERE
    legal_entity = i_legal_entity AND
    cost_type_id = i_cost_type_id AND
    pac_period_id = i_period_id AND
    open_flag = 'Y' AND
    pac_period_id IN
        (SELECT
         DISTINCT pac_period_id
         FROM
         cst_pac_process_phases
         WHERE
         cost_group_id = i_cost_group_id AND
         process_phase = 5 AND
         process_status = 4);

Line: 393

    SELECT
    count(*)
    INTO
    l_running_period
    FROM
    cst_pac_process_phases
    WHERE
    pac_period_id = i_period_id AND
    cost_group_id = i_cost_group_id AND
    process_phase = 6 AND
    process_status = 2;

Line: 419

    SELECT
    count(*)
    INTO
    l_per_exists
    FROM
    cst_pac_periods
    WHERE
    legal_entity = i_legal_entity AND
    cost_type_id = i_cost_type_id AND
    pac_period_id = i_period_id AND
    open_flag IN ('Y','P') AND
    pac_period_id IN
        (SELECT
         DISTINCT pac_period_id
         FROM
         cst_pac_process_phases
         WHERE
         cost_group_id = i_cost_group_id AND
         process_phase = 6 AND
         process_status = 4);

Line: 445

  SELECT
  count(*)
  INTO
  l_acct_lib_exists
  FROM
  cst_le_cost_types clct1,
  cst_accounting_libraries cal
  WHERE
  clct1.legal_entity = i_legal_entity AND
  clct1.cost_type_id = i_cost_type_id AND
  clct1.accounting_library_id = cal.accounting_lib_id;

Line: 483

  SELECT
  accounting_library_id,
  lib_pkg_name
  INTO
  l_acct_lib_id,
  l_lib_name
  FROM
  cst_le_cost_types clct,
  cst_accounting_libraries cal
  WHERE clct.accounting_library_id = cal.ACCOUNTING_LIB_ID AND
  clct.legal_entity = i_legal_entity AND
  clct.cost_type_id = i_cost_type_id;