APPS.IGF_AW_AWD_CERT_RESPS_PKG dependencies on IGF_AW_AWARD_CERTS

Line 143: FROM igf_aw_award_certs

139: cp_award_prd_cd igf_aw_awd_cert_resps.award_prd_cd%TYPE,
140: cp_awd_cert_code igf_aw_awd_cert_resps.awd_cert_code%TYPE
141: ) IS
142: SELECT update_funds_auth_flag
143: FROM igf_aw_award_certs
144: WHERE ci_cal_type = cp_ci_cal_type
145: AND ci_sequence_number = cp_ci_sequence_number
146: AND award_prd_cd = cp_award_prd_cd
147: AND awd_cert_code = cp_awd_cert_code;

Line 148: l_funds_auth igf_aw_award_certs.update_funds_auth_flag%TYPE;

144: WHERE ci_cal_type = cp_ci_cal_type
145: AND ci_sequence_number = cp_ci_sequence_number
146: AND award_prd_cd = cp_award_prd_cd
147: AND awd_cert_code = cp_awd_cert_code;
148: l_funds_auth igf_aw_award_certs.update_funds_auth_flag%TYPE;
149:
150: CURSOR c_pe_hz_parties(
151: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
152: ) IS