APPS.IGF_AP_LG_VER_IMP dependencies on IGF_AP_ISIR_CORR

Line 190: CURSOR cur_corr_items ( cp_pay_isir_id igf_ap_isir_corr.isir_id%TYPE,

186: || Who When What
187: || (reverse chronological order - newest change first)
188: */
189:
190: CURSOR cur_corr_items ( cp_pay_isir_id igf_ap_isir_corr.isir_id%TYPE,
191: cp_sar_num igf_ap_isir_corr.sar_field_number%TYPE ) IS
192: SELECT 1
193: FROM igf_ap_isir_corr
194: WHERE isir_id = cp_pay_isir_id

Line 191: cp_sar_num igf_ap_isir_corr.sar_field_number%TYPE ) IS

187: || (reverse chronological order - newest change first)
188: */
189:
190: CURSOR cur_corr_items ( cp_pay_isir_id igf_ap_isir_corr.isir_id%TYPE,
191: cp_sar_num igf_ap_isir_corr.sar_field_number%TYPE ) IS
192: SELECT 1
193: FROM igf_ap_isir_corr
194: WHERE isir_id = cp_pay_isir_id
195: AND sar_field_number = cp_sar_num ;

Line 193: FROM igf_ap_isir_corr

189:
190: CURSOR cur_corr_items ( cp_pay_isir_id igf_ap_isir_corr.isir_id%TYPE,
191: cp_sar_num igf_ap_isir_corr.sar_field_number%TYPE ) IS
192: SELECT 1
193: FROM igf_ap_isir_corr
194: WHERE isir_id = cp_pay_isir_id
195: AND sar_field_number = cp_sar_num ;
196: l_count NUMBER ;
197: