eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_PACKAGING dependencies on IGS_PS_VER_V

Line 510: p_prog_cd IN igs_ps_ver_v.course_cd%type,

506: RETURN l_disb_round_factor;
507: END get_disb_round_factor;
508:
509: FUNCTION get_prog_elig(
510: p_prog_cd IN igs_ps_ver_v.course_cd%type,
511: p_prog_ver IN igs_ps_ver_v.version_number%type,
512: p_fund_source IN igf_aw_fund_cat_all.fund_source%type
513: )
514: RETURN BOOLEAN

Line 511: p_prog_ver IN igs_ps_ver_v.version_number%type,

507: END get_disb_round_factor;
508:
509: FUNCTION get_prog_elig(
510: p_prog_cd IN igs_ps_ver_v.course_cd%type,
511: p_prog_ver IN igs_ps_ver_v.version_number%type,
512: p_fund_source IN igf_aw_fund_cat_all.fund_source%type
513: )
514: RETURN BOOLEAN
515: IS

Line 537: cp_stud_program_cd igs_ps_ver_v.course_cd%type,

533: -------------------------------------------------------------------
534:
535: -- Check program eligibility for actual data
536: CURSOR c_chk_prog_elig_with_ver(
537: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
538: cp_stud_program_ver igs_ps_ver_v.version_number%type,
539: cp_fund_source igf_aw_fund_cat_all.fund_source%type
540: )
541: IS

Line 538: cp_stud_program_ver igs_ps_ver_v.version_number%type,

534:
535: -- Check program eligibility for actual data
536: CURSOR c_chk_prog_elig_with_ver(
537: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
538: cp_stud_program_ver igs_ps_ver_v.version_number%type,
539: cp_fund_source igf_aw_fund_cat_all.fund_source%type
540: )
541: IS
542: SELECT DECODE(cp_fund_source,

Line 547: FROM IGS_PS_VER_V

543: 'STATE', UPPER(state_financial_aid),
544: 'FEDERAL', UPPER(federal_financial_aid),
545: 'INSTITUTIONAL', UPPER(institutional_financial_aid),
546: NULL) prog_eligibility
547: FROM IGS_PS_VER_V
548: WHERE course_cd = cp_stud_program_cd AND
549: version_number = cp_stud_program_ver;
550:
551: l_chk_prog_elig_with_ver c_chk_prog_elig_with_ver%ROWTYPE;

Line 555: cp_stud_program_cd igs_ps_ver_v.course_cd%type,

551: l_chk_prog_elig_with_ver c_chk_prog_elig_with_ver%ROWTYPE;
552:
553: -- Check program eligibility for anticipated data
554: CURSOR c_chk_prog_elig_wout_ver(
555: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
556: cp_fund_source igf_aw_fund_cat_all.fund_source%type
557: )
558: IS
559: SELECT 'x' FROM dual

Line 561: ( SELECT * FROM IGS_PS_VER_V

557: )
558: IS
559: SELECT 'x' FROM dual
560: WHERE EXISTS
561: ( SELECT * FROM IGS_PS_VER_V
562: WHERE course_cd = cp_stud_program_cd AND
563: DECODE(cp_fund_source,
564: 'STATE', UPPER(state_financial_aid),
565: 'FEDERAL', UPPER(federal_financial_aid),

Line 5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;

5780: WHERE fmdet.formula_code = cp_group_code
5781: AND fmdet.ci_cal_type = cp_ci_cal_type
5782: AND fmdet.ci_sequence_number = cp_ci_sequence_number);
5783:
5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;
5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;
5786: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
5788:

Line 5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;

5781: AND fmdet.ci_cal_type = cp_ci_cal_type
5782: AND fmdet.ci_sequence_number = cp_ci_sequence_number);
5783:
5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;
5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;
5786: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
5788:
5789: -- Returns the fund source of the given fund