APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_EN_STDNT_PS_ATT

Line 520: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;

516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;
520: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;
521: l_st_date igs_or_unit.start_dt%TYPE;
522: l_v_transaction_type igs_fi_inv_int_all.transaction_type%TYPE;
523:
524: -- As part of the bug #1962286 the local variables l_unit_cd and l_unit_version_number were added

Line 529: -- cusor to get the version number form igs_en_stdnt_ps_att table for a person , course

525:
526: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
527: l_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
528:
529: -- cusor to get the version number form igs_en_stdnt_ps_att table for a person , course
530:
531: CURSOR cur_ver (l_course_cd igs_fi_inv_int.course_Cd%TYPE,
532: l_person_id igs_fi_inv_int.person_id%TYPE) IS
533: SELECT version_number

Line 534: FROM igs_en_stdnt_ps_att

530:
531: CURSOR cur_ver (l_course_cd igs_fi_inv_int.course_Cd%TYPE,
532: l_person_id igs_fi_inv_int.person_id%TYPE) IS
533: SELECT version_number
534: FROM igs_en_stdnt_ps_att
535: WHERE course_cd = l_course_cd
536: AND person_id = l_person_id;
537:
538: --