DBA Data[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on IGS_EN_STDNT_PS_ATT

Line 124: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

120: -- function to return the latest standard balance of the student for the personid provided
121: FUNCTION get_std_balance(p_partyid IN igs_fi_balances.party_id%TYPE) RETURN NUMBER;
122:
123: -- Procedure for checking if Term Record exists
124: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
127: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,
128: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,

Line 125: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

121: FUNCTION get_std_balance(p_partyid IN igs_fi_balances.party_id%TYPE) RETURN NUMBER;
122:
123: -- Procedure for checking if Term Record exists
124: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
127: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,
128: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,
129: p_v_status OUT NOCOPY VARCHAR2,