DBA Data[Home] [Help]

APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_BATCH_AW_MAP_ALL

Line 1949: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,

1945: END update_fed_verif_status;
1946:
1947: FUNCTION get_gr_ver_code(
1948: pv_fed_verif_status igf_lookups_view.lookup_code%TYPE,
1949: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1950: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1951: ) RETURN VARCHAR2 IS
1952:
1953: -- Read Sys Award Year

Line 1950: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE

1946:
1947: FUNCTION get_gr_ver_code(
1948: pv_fed_verif_status igf_lookups_view.lookup_code%TYPE,
1949: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1950: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1951: ) RETURN VARCHAR2 IS
1952:
1953: -- Read Sys Award Year
1954: CURSOR cur_get_sys_awd(

Line 1955: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,

1951: ) RETURN VARCHAR2 IS
1952:
1953: -- Read Sys Award Year
1954: CURSOR cur_get_sys_awd(
1955: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1956: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1957: ) IS
1958: SELECT sys_award_year
1959: FROM igf_ap_batch_aw_map

Line 1956: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE

1952:
1953: -- Read Sys Award Year
1954: CURSOR cur_get_sys_awd(
1955: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1956: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1957: ) IS
1958: SELECT sys_award_year
1959: FROM igf_ap_batch_aw_map
1960: WHERE ci_cal_type = p_cal_type