APPS.IGS_FI_GEN_GL dependencies on IGS_FI_POSTING_INT_ALL

Line 150: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

146:
147:
148: --Cursor to check unposted transactions in credit activities table.
149:
150: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
151: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
152:
153: SELECT 'Y'
154: FROM igs_fi_cr_activities crac

Line 151: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

147:
148: --Cursor to check unposted transactions in credit activities table.
149:
150: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
151: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
152:
153: SELECT 'Y'
154: FROM igs_fi_cr_activities crac
155: WHERE crac.gl_date IS NOT NULL

Line 164: CURSOR cur_appl(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

160:
161:
162: --Cursor to check unposted transactions in applications table.
163:
164: CURSOR cur_appl(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
165: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
166:
167: SELECT 'Y'
168: FROM igs_fi_applications appl

Line 165: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

161:
162: --Cursor to check unposted transactions in applications table.
163:
164: CURSOR cur_appl(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
165: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
166:
167: SELECT 'Y'
168: FROM igs_fi_applications appl
169: WHERE appl.gl_date IS NOT NULL

Line 177: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

173:
174:
175:
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

Line 178: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

174:
175:
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)

Line 187: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

183: AND adm.posting_control_id IS NULL;
184:
185:
186: --Cursor to check unposted transactions in charges table.
187: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
188: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
189: SELECT 'Y'
190: FROM igs_fi_invln_int_all invln
191: WHERE invln.gl_date IS NOT NULL

Line 188: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

184:
185:
186: --Cursor to check unposted transactions in charges table.
187: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
188: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
189: SELECT 'Y'
190: FROM igs_fi_invln_int_all invln
191: WHERE invln.gl_date IS NOT NULL
192: AND TRUNC(invln.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)