eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_FI_INV_INT_ALL

Line 337: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,

333: -- and the records do not have waiver details
334:
335: CURSOR cur_person_chrgs(cp_n_person_id IN hz_parties.party_id%type,
336: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
337: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
338: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
339: ) IS
340: SELECT hd.person_id person_id,
341: ln.uoo_id uoo_id,

Line 338: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE

334:
335: CURSOR cur_person_chrgs(cp_n_person_id IN hz_parties.party_id%type,
336: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
337: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
338: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
339: ) IS
340: SELECT hd.person_id person_id,
341: ln.uoo_id uoo_id,
342: hd.course_cd,

Line 349: FROM igs_fi_inv_int_all hd,

345: hd.fee_cal_type,
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

Line 369: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,

365: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
366:
367: CURSOR cur_person_group_chrgs(cp_n_person_id_grp IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
368: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
369: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
370: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
371: ) IS
372: SELECT hd.person_id person_id,
373: ln.uoo_id uoo_id,

Line 370: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE

366:
367: CURSOR cur_person_group_chrgs(cp_n_person_id_grp IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
368: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
369: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
370: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
371: ) IS
372: SELECT hd.person_id person_id,
373: ln.uoo_id uoo_id,
374: hd.course_cd,

Line 381: FROM igs_fi_inv_int_all hd,

377: hd.fee_cal_type,
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

Line 404: cp_v_fee_cal_type IN Igs_fi_inv_int_all.fee_cal_type%TYPE,

400: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
401:
402:
403: CURSOR cur_all_person_chrgs(cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
404: cp_v_fee_cal_type IN Igs_fi_inv_int_all.fee_cal_type%TYPE,
405: cp_n_fee_ci_sequence_number IN Igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
406: ) IS
407: SELECT hd.person_id person_id,
408: ln.uoo_id uoo_id,

Line 405: cp_n_fee_ci_sequence_number IN Igs_fi_inv_int_all.fee_ci_sequence_number%TYPE

401:
402:
403: CURSOR cur_all_person_chrgs(cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
404: cp_v_fee_cal_type IN Igs_fi_inv_int_all.fee_cal_type%TYPE,
405: cp_n_fee_ci_sequence_number IN Igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
406: ) IS
407: SELECT hd.person_id person_id,
408: ln.uoo_id uoo_id,
409: hd.course_cd,

Line 416: FROM igs_fi_inv_int_all hd,

412: hd.fee_cal_type,
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