APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_FI_INVLN_INT

Line 350: igs_fi_invln_int_v ln

346: hd.fee_ci_sequence_number,
347: hd.invoice_id,
348: hd.invoice_amount_due
349: FROM igs_fi_inv_int_all hd,
350: igs_fi_invln_int_v ln
351: WHERE hd.invoice_id = ln.invoice_id
352: AND hd.transaction_type = g_transaction_type
353: AND hd.person_id = cp_n_person_id
354: AND hd.invoice_amount_due > 0

Line 382: igs_fi_invln_int_v ln

378: hd.fee_ci_sequence_number,
379: hd.invoice_id,
380: hd.invoice_amount_due
381: FROM igs_fi_inv_int_all hd,
382: igs_fi_invln_int_v ln
383: WHERE hd.invoice_id = ln.invoice_id
384: AND hd.transaction_type = g_transaction_type
385: AND hd.person_id IN (SELECT person_id
386: FROM igs_pe_prsid_grp_mem

Line 417: igs_fi_invln_int_v ln

413: hd.fee_ci_sequence_number,
414: hd.invoice_id,
415: hd.invoice_amount_due
416: FROM igs_fi_inv_int_all hd,
417: igs_fi_invln_int_v ln
418: WHERE hd.invoice_id = ln.invoice_id
419: AND hd.transaction_type = g_transaction_type
420: AND hd.invoice_amount_due > 0
421: AND hd.fee_cal_type = cp_v_fee_cal_type

Line 483: l_uoo_id igs_fi_invln_int.uoo_id%TYPE;

479: AND ca.sequence_number = p_n_sequence_number;
480:
481: -- Declaration of local variables
482:
483: l_uoo_id igs_fi_invln_int.uoo_id%TYPE;
484: l_person_id igs_pe_person.person_id%TYPE;
485: l_course_cd igs_fi_inv_int.course_cd%TYPE;
486: l_cnt NUMBER;
487: l_str VARCHAR2(4000);