APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_FI_FUND_SRC

Line 731: igs_fi_fund_src b

727: CURSOR c_fsrc IS
728: SELECT b.govt_funding_source,
729: a.funding_source
730: FROM igs_fi_fnd_src_rstn a,
731: igs_fi_fund_src b
732: WHERE a.course_cd = p_course_cd
733: AND a.version_number = p_version_number
734: AND a.dflt_ind = 'Y'
735: AND a.funding_source = b.funding_source;

Line 739: CURSOR c_gov_fsrc(cp_fund_src igs_fi_fund_src.funding_source%TYPE) IS

735: AND a.funding_source = b.funding_source;
736:
737: -- smaddali added cursor for hefd208 build, bug#2717751
738: -- to get the govt funding_source for the funding_source set up at Poous level
739: CURSOR c_gov_fsrc(cp_fund_src igs_fi_fund_src.funding_source%TYPE) IS
740: SELECT govt_funding_source,
741: funding_source
742: FROM igs_fi_fund_src
743: WHERE funding_source = cp_fund_src ;

Line 742: FROM igs_fi_fund_src

738: -- to get the govt funding_source for the funding_source set up at Poous level
739: CURSOR c_gov_fsrc(cp_fund_src igs_fi_fund_src.funding_source%TYPE) IS
740: SELECT govt_funding_source,
741: funding_source
742: FROM igs_fi_fund_src
743: WHERE funding_source = cp_fund_src ;
744:
745: BEGIN
746:

Line 774: -- If no HESA value get funding source from igs_fi_fund_src

770: IF l_hesa_fund_src IS NULL THEN
771:
772: IF l_govt_fund_src IS NULL THEN
773:
774: -- If no HESA value get funding source from igs_fi_fund_src
775: OPEN c_gov_fsrc(l_oss_fund_src) ;
776: FETCH c_gov_fsrc INTO l_hesa_fund_src,
777: p_oss_fund_src;
778: CLOSE c_gov_fsrc;