APPS.IGS_FI_PRC_ACCT_PKG SQL Statements

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

Line: 102

    SELECT COUNT(*)
    FROM fnd_id_flex_segments
    WHERE id_flex_num = cp_n_coa_id
    AND enabled_flag= cp_v_enabled_flag
    AND id_flex_code = cp_v_flex_cd;

Line: 144

      COMMIT;  -- Commit's the transaction if a new Combination is inserted.

Line: 189

                                variable p_seg_num_val is removed, update of the segments is directly done
                                Hence procedure update_seg_values is also removed since it is not required to update
                                the Global segments.
     schodava   20-Sep-2002     Enh # 2564643 - Subaccount Removal
                                Removed references to subaccount.
    *************************************************************************************************/

    --
    --Get the Segment Values for the Program Entity
    --
    CURSOR cur_ps_accts (cp_course_cd  igs_ps_accts.course_cd%TYPE,
                         cp_version_number igs_ps_accts.version_number%TYPE)
    IS
    SELECT segment_num,segment_value
    FROM   igs_ps_accts
    WHERE  course_cd= cp_course_cd
    AND    version_number = cp_version_number;

Line: 213

    SELECT segment_num,segment_value
    FROM   igs_ps_unit_accts
    WHERE  unit_cd= cp_unit_cd
    AND    version_number = cp_version_number;

Line: 223

    SELECT segment_num,segment_value
    FROM   igs_ps_usec_accts
    WHERE  uoo_id = cp_uoo_id;

Line: 233

    SELECT segment_num,segment_value
    FROM   igs_or_unit_accts
    WHERE  org_unit_cd = cp_org_unit_cd
    AND    start_dt = cp_start_dt;

Line: 243

    SELECT segment_num,segment_value
    FROM   igs_ad_loc_accts
    WHERE  location_cd = cp_location_cd;

Line: 252

    SELECT segment_num,segment_value
    FROM   igs_fi_sa_segments;

Line: 262

    SELECT segment_num,segment_value
    FROM   igs_fi_f_type_accts
    WHERE  fee_type = cp_fee_type
    AND    fee_cal_type = cp_fee_cal_type
    AND    fee_ci_sequence_number = cp_fee_ci_sequence_number;

Line: 381

    SELECT *
    FROM igs_fi_ftci_accts
    WHERE fee_type = cp_v_fee_type
    AND fee_cal_type = cp_v_fee_cal_type
    AND fee_ci_sequence_number = cp_n_sequence_number
    ORDER BY order_sequence;

Line: 390

    SELECT am.govt_attendance_mode
    FROM igs_en_atd_mode_all am
    WHERE am.attendance_mode=p_att_mode;

Line: 660

    SELECT dr_gl_ccid,
           cr_gl_ccid,
           dr_account_cd,
           cr_account_cd
    FROM   igs_fi_cr_types
    WHERE  credit_type_id = cp_credit_type_id;

Line: 676

    SELECT acct_hier_id,
           rec_account_cd,
           rec_gl_ccid,
           rev_account_cd,
           ret_gl_ccid,
           ret_account_cd
    FROM   igs_fi_f_typ_ca_inst
    WHERE  fee_type = cp_fee_type
    AND    fee_cal_type = cp_fee_cal_type
    AND    fee_ci_sequence_number = cp_fee_ci_sequence_number;

Line: 694

    SELECT zero_fill_flag
    FROM   igs_fi_hier_accounts
    WHERE  acct_hier_id = cp_acct_hier_id;

Line: 705

    SELECT acct_tbl_id,
           order_sequence,
           entity_type_code
    FROM   igs_fi_hier_acct_tbl
    WHERE  acct_hier_id = cp_acct_hier_id
    ORDER BY order_sequence;

Line: 715

   SELECT  rec_account_cd,
           rec_gl_ccid
   FROM    igs_fi_control;

Line: 722

   SELECT seg.segment,seg.segment_num,val.maximum_size maximum_size
   FROM   igs_fi_acct_segs_v seg,
          fnd_flex_value_sets val
   WHERE  seg.flex_value_set_id = val.flex_value_set_id
   ORDER BY segment_num;

Line: 731

    SELECT s_fee_type
    FROM igs_fi_fee_type
    WHERE fee_type = cp_fee_type;

Line: 743

    SELECT application_column_name segment_name
    FROM fnd_segment_attribute_values
    WHERE id_flex_num = cp_n_coa_id
    AND application_id = cp_n_appl_id
    AND segment_attribute_type = cp_v_attr_type
    AND attribute_value = cp_v_attr_value;

Line: 776

    SELECT fwp.fee_cal_type,
           fwp.fee_ci_sequence_number,
           fwp.waiver_name,
           fwp.credit_type_id,
           fwp.target_fee_type
    FROM   igs_fi_waiver_pgms fwp
    WHERE  fwp.adjustment_fee_type = cp_v_fee_type
    AND    fwp.fee_cal_type    = cp_v_fee_cal_type
    AND    fwp.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
    AND    fwp.waiver_name = cp_v_waiver_name;

Line: 795

    g_accsegs.DELETE;