DBA Data[Home] [Help]

APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_FEE_TYPE

Line 1082: cp_fee_type igs_fi_fee_type.fee_type%TYPE,

1078: -- Cursor for getting the sum of the Invoice Amount and the Invoice Amount Due
1079:
1080:
1081: CURSOR cur_val_chg(cp_person_id igs_pe_person.person_id%TYPE,
1082: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1083: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1084: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1085: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1086: cp_course_cd igs_ps_ver.course_cd%TYPE,

Line 1381: cp_fee_type igs_fi_fee_type.fee_type%TYPE,

1377: -- and the location code. If the invoice id is passed as input to the cursor then this is
1378: -- used to select the charges. The charges are ordered by the Invoice Amount Due in
1379: -- descending order
1380: CURSOR cur_chg(cp_person_id igs_pe_person.person_id%TYPE,
1381: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1382: cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1384: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1385: cp_course_cd igs_ps_ver.course_cd%TYPE,

Line 1486: cp_fee_type igs_fi_fee_type.fee_type%TYPE,

1482:
1483: -- Cursor to pick up all charges following the unique key (or) for a
1484: -- specific invoice_id (similar to cur_chg, except the ORDER BY clause and check on invoice_amount_due)
1485: CURSOR cur_charges(cp_person_id igs_pe_person.person_id%TYPE,
1486: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1487: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1488: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1489: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1490: cp_course_cd igs_ps_ver.course_cd%TYPE,