DBA Data[Home] [Help]

APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_PE_PERSON

Line 1081: CURSOR cur_val_chg(cp_person_id igs_pe_person.person_id%TYPE,

1077:
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,

Line 1380: CURSOR cur_chg(cp_person_id igs_pe_person.person_id%TYPE,

1376: -- Fee Calendar Instance, Fee Category, Course Cd, Transaction type, Unit Section Id
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,

Line 1485: CURSOR cur_charges(cp_person_id igs_pe_person.person_id%TYPE,

1481: l_v_fee_ci_desc igs_ca_inst_all.description%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,