DBA Data[Home] [Help]

APPS.IGS_FI_GEN_GL dependencies on IGS_AD_APP_REQ

Line 180: FROM igs_ad_app_req adm

176: --Cursor to check unposted transactions in adm applications fees table. (only posting control id need to be checked)
177: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
178: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
179: SELECT 'Y'
180: FROM igs_ad_app_req adm
181: WHERE adm.gl_date IS NOT NULL
182: AND TRUNC(adm.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
183: AND adm.posting_control_id IS NULL;
184: