APPS.IGS_FI_PRC_FIN_LT_CHG dependencies on IGS_FI_PP_INSTLMNTS

Line 571: p_d_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE,

567: p_cal_type IN igs_fi_f_typ_ca_inst_v.fee_cal_type%TYPE,
568: p_sequence_number IN igs_fi_f_typ_ca_inst_v.fee_ci_sequence_number%TYPE,
569: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
570: p_n_std_plan_id IN igs_fi_pp_std_attrs.student_plan_id%TYPE,
571: p_d_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE,
572: p_b_chrg_flag OUT NOCOPY BOOLEAN
573: )AS
574: /***********************************************************************************************
575:

Line 885: FROM igs_fi_pp_instlmnts

881: CURSOR cur_get_inst_dtls(cp_n_std_plan_id NUMBER,
882: cp_d_bal_start_dt DATE
883: ) IS
884: SELECT due_amt, due_date, (g_d_sysdate -(TRUNC(due_date)-1)) num_days
885: FROM igs_fi_pp_instlmnts
886: WHERE student_plan_id = cp_n_std_plan_id
887: AND TRUNC(due_date) BETWEEN TRUNC(cp_d_bal_start_dt) AND g_d_sysdate
888: AND due_amt > 0
889: ORDER BY due_date;

Line 977: FROM igs_fi_pp_instlmnts pp

973: cp_n_std_plan_id NUMBER,
974: cp_v_penalty_flag VARCHAR2,
975: cp_d_due_date DATE) IS
976: SELECT pp.rowid,pp.*
977: FROM igs_fi_pp_instlmnts pp
978: WHERE pp.student_plan_id = cp_n_std_plan_id
979: AND TRUNC(pp.due_date) <= cp_d_due_date
980: AND pp.due_amt > 0
981: AND NVL(pp.penalty_flag,'N') = cp_v_penalty_flag;

Line 1083: igs_fi_pp_instlmnts_pkg.update_row(

1079: --Once the log is generated and charge is created, if the process is invoked with test run parameter as 'No',
1080: --then the penalty flag of the installment record should be updated to 'Y'.
1081: IF p_v_test_flag = 'N' AND l_b_chrg_flag THEN
1082: BEGIN
1083: igs_fi_pp_instlmnts_pkg.update_row(
1084: x_rowid => rec_cur_get_inst_details.rowid,
1085: x_installment_id => rec_cur_get_inst_details.installment_id,
1086: x_student_plan_id => rec_cur_get_inst_details.student_plan_id,
1087: x_installment_line_num => rec_cur_get_inst_details.installment_line_num,