APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_PP_STD_ATTRS

Line 154: p_n_student_plan_id OUT NOCOPY igs_fi_pp_std_attrs.student_plan_id%TYPE,

150: P_hold_plan_level OUT NOCOPY igs_fi_hold_plan.hold_plan_level%TYPE,
151: P_holds_charges OUT NOCOPY igs_fi_inv_int.invoice_amount%TYPE,
152: P_holds_final_balance OUT NOCOPY igs_fi_credits.amount%TYPE,
153: p_offset_days OUT NOCOPY igs_fi_hold_plan.offset_days%TYPE,
154: p_n_student_plan_id OUT NOCOPY igs_fi_pp_std_attrs.student_plan_id%TYPE,
155: p_d_last_inst_due_date OUT NOCOPY igs_fi_pp_instlmnts.due_date%TYPE)
156: RETURN BOOLEAN
157: IS
158: /***************************************************************

Line 244: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,

240: (TRUNC(p_process_start_date) >= TRUNC(start_dt) AND TRUNC(end_dt) is null)
241: )
242: );
243:
244: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
245: cp_d_d_pay_det_date DATE
246: ) IS
247: SELECT SUM(installment_amt) installment_amt,
248: SUM(due_amt) due_amt,

Line 291: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE ;

287: -- Changes due to SFCR018
288:
289: l_n_threshold_amount igs_fi_hold_plan.threshold_amount%TYPE ;
290: l_n_threshold_percent igs_fi_hold_plan.threshold_percent%TYPE ;
291: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE ;
292: l_v_act_plan_name igs_fi_pp_templates.payment_plan_name%TYPE;
293: l_d_pay_det_date DATE;
294:
295: BEGIN

Line 587: p_n_student_plan_id IN igs_fi_pp_std_attrs.student_plan_id%TYPE,

583: p_holds_final_balance IN igs_fi_credits.amount%TYPE,
584: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
585: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
586: p_test_run IN VARCHAR2,
587: p_n_student_plan_id IN igs_fi_pp_std_attrs.student_plan_id%TYPE,
588: p_d_last_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE
589: )
590: RETURN BOOLEAN
591: IS

Line 1104: l_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;

1100:
1101: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
1102: l_v_message_name fnd_new_messages.message_name%TYPE :=NULL;
1103: l_n_offset_days igs_fi_hold_plan.offset_days%TYPE :=0;
1104: l_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
1105: l_d_last_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE;
1106: l_n_fnd_user_id fnd_user.user_id%TYPE;
1107: l_v_person_number hz_parties.party_number%TYPE;
1108: l_v_person_name hz_person_profiles.person_name%TYPE;

Line 1773: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,

1769: AND holds_balance IS NOT NULL
1770: AND TRUNC(balance_date) <= TRUNC(cp_process_start_dt)
1771: ORDER BY balance_date DESC;
1772:
1773: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
1774: cp_d_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE
1775: ) IS
1776: SELECT SUM(installment_amt) installment_amt,
1777: SUM(due_amt) due_amt