APPS.IGS_FI_GEN_GL dependencies on IGS_FI_CREDITS

Line 361: CURSOR cur_credit (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS

357: WHERE gl_date IS NOT NULL
358: AND invoice_id = cp_n_invoice_id;
359:
360:
361: CURSOR cur_credit (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
362: SELECT gl_date
363: FROM igs_fi_credits_all
364: WHERE gl_date IS NOT NULL
365: AND credit_id = cp_n_credit_id;

Line 363: FROM igs_fi_credits_all

359:
360:
361: CURSOR cur_credit (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
362: SELECT gl_date
363: FROM igs_fi_credits_all
364: WHERE gl_date IS NOT NULL
365: AND credit_id = cp_n_credit_id;
366:
367: l_d_chg_gl_date igs_fi_invln_int_all.gl_date%TYPE := NULL;

Line 368: l_d_crd_gl_date igs_fi_credits_all.gl_date%TYPE := NULL;

364: WHERE gl_date IS NOT NULL
365: AND credit_id = cp_n_credit_id;
366:
367: l_d_chg_gl_date igs_fi_invln_int_all.gl_date%TYPE := NULL;
368: l_d_crd_gl_date igs_fi_credits_all.gl_date%TYPE := NULL;
369:
370: BEGIN
371:
372: -- Sanity Validation of the input parameters to raise exception

Line 432: CURSOR cur_neg (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS

428: WHERE invoice_id = cp_n_invoice_id
429: AND application_type = 'APP';
430:
431:
432: CURSOR cur_neg (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
433: SELECT 'Y'
434: FROM igs_fi_credits_all crd,
435: igs_fi_cr_types_all crtype
436: WHERE crd.credit_id = cp_n_credit_id

Line 434: FROM igs_fi_credits_all crd,

430:
431:
432: CURSOR cur_neg (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
433: SELECT 'Y'
434: FROM igs_fi_credits_all crd,
435: igs_fi_cr_types_all crtype
436: WHERE crd.credit_id = cp_n_credit_id
437: AND crd.credit_type_id = crtype.credit_type_id
438: AND crtype.credit_class = 'CHGADJ';