APPS.IGF_AP_AWD_YR_SETUP dependencies on IGF_AP_BATCH_AW_MAP

Line 36: igf_ap_batch_aw_map_v

32: SUBSTR(sys_award_year,4) code,
33: award_year_status_code status,
34: sys_award_year_mean
35: FROM
36: igf_ap_batch_aw_map_v
37: WHERE
38: sys_award_year like 'LI%'
39: UNION
40: SELECT

Line 45: igf_ap_batch_aw_map_v

41: '20'||SUBSTR(sys_award_year,0,2) code,
42: award_year_status_code status,
43: sys_award_year_mean
44: FROM
45: igf_ap_batch_aw_map_v
46: WHERE
47: Sys_award_year NOT LIKE 'LI%'
48: ORDER BY 1;
49:

Line 54: lv_prev_status igf_ap_batch_aw_map.award_year_status_code%TYPE;

50: lv_cur_rec cur_award%rowtype;
51:
52: lv_prev_year NUMBER;
53: lv_curr_year NUMBER;
54: lv_prev_status igf_ap_batch_aw_map.award_year_status_code%TYPE;
55: lv_curr_status igf_ap_batch_aw_map.award_year_status_code%TYPE;
56: l_valid BOOLEAN ;
57: l_profile_set VARCHAR2(30);
58: l_school VARCHAR2(10) := 'US';

Line 55: lv_curr_status igf_ap_batch_aw_map.award_year_status_code%TYPE;

51:
52: lv_prev_year NUMBER;
53: lv_curr_year NUMBER;
54: lv_prev_status igf_ap_batch_aw_map.award_year_status_code%TYPE;
55: lv_curr_status igf_ap_batch_aw_map.award_year_status_code%TYPE;
56: l_valid BOOLEAN ;
57: l_profile_set VARCHAR2(30);
58: l_school VARCHAR2(10) := 'US';
59: