APPS.IGS_FI_GEN_GL SQL Statements

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

Line: 46

                                while selecting currency from fnd_currencies_tl.
  schodava	29-Sep-2003	Bug # 3112084 - Modified cursor cur_ctrl, to
				fetch the currency name from fnd_currencies_tl
   ******************************************************************/

   -- get the currency code
   CURSOR cur_ctrl IS
   SELECT currency_cd
   FROM   igs_fi_control_all;

Line: 59

     SELECT name
     FROM   fnd_currencies_tl
     WHERE  currency_code = cp_currency_cd
     AND    language = USERENV('LANG');

Line: 140

SELECT lookup_code
FROM   igs_lookup_values
WHERE lookup_code = cp_v_accounting_mthd
AND lookup_type = 'IGS_FI_ACCT_METHOD'
AND enabled_flag = 'Y'
AND trunc(sysdate) BETWEEN trunc(NVL(start_date_active, SYSDATE)) AND trunc(NVL(end_date_active, SYSDATE));

Line: 153

 SELECT 'Y'
 FROM   igs_fi_cr_activities crac
 WHERE  crac.gl_date IS NOT NULL
 AND    TRUNC(crac.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
 AND    crac.posting_id IS NULL
 AND    crac.posting_control_id IS NULL;

Line: 167

SELECT 'Y'
FROM   igs_fi_applications appl
WHERE  appl.gl_date IS NOT NULL
AND    TRUNC(appl.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
AND    appl.posting_id IS NULL
AND    appl.posting_control_id IS NULL;

Line: 179

SELECT 'Y'
FROM   igs_ad_app_req adm
WHERE  adm.gl_date IS NOT NULL
AND    TRUNC(adm.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
AND    adm.posting_control_id IS NULL;

Line: 189

SELECT 'Y'
FROM   igs_fi_invln_int_all invln
WHERE  invln.gl_date IS NOT NULL
AND    TRUNC(invln.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
AND    invln.posting_id IS NULL
AND    invln.posting_control_id IS NULL;

Line: 294

SELECT closing_status
FROM   igs_fi_gl_periods_v
WHERE  TRUNC(p_d_date) BETWEEN TRUNC(start_date) AND TRUNC(end_date)
AND    set_of_books_id = igs_fi_gen_007.get_sob_id;

Line: 355

 SELECT gl_date
 FROM   igs_fi_invln_int_all
 WHERE  gl_date IS NOT NULL
 AND    invoice_id = cp_n_invoice_id;

Line: 362

 SELECT gl_date
 FROM   igs_fi_credits_all
 WHERE  gl_date IS NOT NULL
 AND    credit_id = cp_n_credit_id;

Line: 426

 SELECT credit_id
 FROM   igs_fi_applications
 WHERE  invoice_id = cp_n_invoice_id
 AND    application_type  = 'APP';

Line: 433

 SELECT 'Y'
 FROM igs_fi_credits_all crd,
      igs_fi_cr_types_all crtype
 WHERE crd.credit_id = cp_n_credit_id
 AND   crd.credit_type_id  = crtype.credit_type_id
 AND   crtype.credit_class = 'CHGADJ';

Line: 483

 SELECT meaning
 FROM  igs_lookup_values
 WHERE lookup_code = cp_v_lookup_code
 AND   lookup_type = cp_v_lookup_type;