APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AW_INT_EXT_MAP

Line 77: | Modified get_gr_ver_code to read mapping from igf_aw_int_ext_map table|

73: | Bug 2606001,2613546 |
74: | sjadhav Oct.28.2002 |
75: | Added l_pell_mat to igf_gr_pell.pell_calc routine |
76: | Added x_pell_alt_expense in igf_ap_fa_base_rec_pkg |
77: | Modified get_gr_ver_code to read mapping from igf_aw_int_ext_map table|
78: |-----------------------------------------------------------------------|
79: | 12-Jun-2002 Bug ID: 2402371/ 2403886. |
80: |The initialization of cursor variable dbms_sql.open_cursor removed from|
81: |declaration section and moved to main body as it was failing when more |

Line 1963: lv_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE;

1959: FROM igf_ap_batch_aw_map
1960: WHERE ci_cal_type = p_cal_type
1961: AND ci_sequence_number = p_sequence_number;
1962:
1963: lv_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE;
1964:
1965: -- Read mapping from igf_aw_int_ext_map table
1966: CURSOR cur_get_int_ext(
1967: p_fed_verif_status igf_lookups_view.lookup_code%TYPE,

Line 1965: -- Read mapping from igf_aw_int_ext_map table

1961: AND ci_sequence_number = p_sequence_number;
1962:
1963: lv_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE;
1964:
1965: -- Read mapping from igf_aw_int_ext_map table
1966: CURSOR cur_get_int_ext(
1967: p_fed_verif_status igf_lookups_view.lookup_code%TYPE,
1968: p_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE ,
1969: cp_int_lkup_type VARCHAR2 ,

Line 1968: p_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE ,

1964:
1965: -- Read mapping from igf_aw_int_ext_map table
1966: CURSOR cur_get_int_ext(
1967: p_fed_verif_status igf_lookups_view.lookup_code%TYPE,
1968: p_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE ,
1969: cp_int_lkup_type VARCHAR2 ,
1970: cp_ext_lkup_type VARCHAR2
1971: ) IS
1972: SELECT ext_lookup_code

Line 1973: FROM igf_aw_int_ext_map

1969: cp_int_lkup_type VARCHAR2 ,
1970: cp_ext_lkup_type VARCHAR2
1971: ) IS
1972: SELECT ext_lookup_code
1973: FROM igf_aw_int_ext_map
1974: WHERE int_lookup_type = cp_int_lkup_type
1975: AND ext_lookup_type = cp_ext_lkup_type
1976: AND int_lookup_code = p_fed_verif_status
1977: AND SYS_AWARD_YEAR = p_sys_award_year;