APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGF_AP_BATCH_AW_MAP

Line 733: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;

729: c_int_data_rec c_int_data%ROWTYPE;
730: l_css_log VARCHAR2(1);
731: l_debug_str VARCHAR2(2000) := NULL;
732:
733: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
734: PROCEDURE p_convert_rec
735: IS
736: /*
737: || Created By : rasahoo

Line 5849: FROM igf_ap_batch_aw_map map

5845:
5846: -- cursor to get sys award year and award year status
5847: CURSOR c_get_stat( p_ci_cal_type VARCHAR2,p_ci_sequence_number NUMBER)IS
5848: SELECT award_year_status_code, sys_award_year
5849: FROM igf_ap_batch_aw_map map
5850: WHERE map.ci_cal_type = p_ci_cal_type
5851: AND map.ci_sequence_number = p_ci_sequence_number ;
5852:
5853: CURSOR c_lkup_values(p_lookup_code VARCHAR2 )IS

Line 5866: FROM IGF_AP_BATCH_AW_MAP

5862: SELECT BATCH_YEAR batch_year ,
5863: AWARD_YEAR_STATUS_CODE ,
5864: CSS_ACADEMIC_YEAR,
5865: SYS_AWARD_YEAR
5866: FROM IGF_AP_BATCH_AW_MAP
5867: WHERE CI_CAL_TYPE = p_ci_cal_type
5868: AND CI_SEQUENCE_NUMBER = p_ci_sequence_number;
5869:
5870: -- Bug #3039724 Added p_stu_record_type

Line 5899: l_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;

5895: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
5896: l_ci_cal_type VARCHAR2(10);
5897: l_ci_sequence_number NUMBER;
5898: l_ret_profile VARCHAR2(2);
5899: l_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
5900: c_lkup_values_err_rec c_lkup_values%ROWTYPE;
5901: c_lkup_values_pn_rec c_lkup_values%ROWTYPE;
5902: c_lkup_values_bi_rec c_lkup_values%ROWTYPE;
5903: l_batch_valid VARCHAR2(1) ;