APPS.IGF_GR_PELL dependencies on IGF_AW_AWARD_ALL

Line 296: CURSOR cur_get_awd ( p_award_id igf_aw_award_all.award_id%TYPE)

292: --
293: -- Cursor to Pick Award Details
294: --
295:
296: CURSOR cur_get_awd ( p_award_id igf_aw_award_all.award_id%TYPE)
297: IS
298: SELECT
299: adisb1.disb_num,
300: adisb2.disb_date

Line 1107: FUNCTION get_enrollment_date(p_award_id igf_aw_award_all.award_id%TYPE)

1103: app_exception.raise_exception;
1104:
1105: END generate_origination_id;
1106:
1107: FUNCTION get_enrollment_date(p_award_id igf_aw_award_all.award_id%TYPE)
1108: RETURN DATE
1109: AS
1110:
1111: CURSOR cur_enrollment_date(cp_award_id igf_aw_award_all.award_id%TYPE) IS

Line 1111: CURSOR cur_enrollment_date(cp_award_id igf_aw_award_all.award_id%TYPE) IS

1107: FUNCTION get_enrollment_date(p_award_id igf_aw_award_all.award_id%TYPE)
1108: RETURN DATE
1109: AS
1110:
1111: CURSOR cur_enrollment_date(cp_award_id igf_aw_award_all.award_id%TYPE) IS
1112: SELECT ld_cal_type,ld_sequence_number
1113: FROM igf_aw_awd_disb_all
1114: WHERE award_id = cp_award_id
1115: AND trans_type <> 'C';

Line 1117: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS

1113: FROM igf_aw_awd_disb_all
1114: WHERE award_id = cp_award_id
1115: AND trans_type <> 'C';
1116:
1117: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS
1118: SELECT base_id
1119: FROM igf_aw_award_all
1120: WHERE award_id = cp_award_id;
1121: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

Line 1119: FROM igf_aw_award_all

1115: AND trans_type <> 'C';
1116:
1117: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS
1118: SELECT base_id
1119: FROM igf_aw_award_all
1120: WHERE award_id = cp_award_id;
1121: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1122:
1123: p_start_dt DATE;