APPS.IGF_GR_GEN_XML dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 613: FROM igf_ap_isir_matched_all

609:
610: CURSOR cur_isir_info (p_base_id NUMBER) IS
611: SELECT payment_isir,transaction_num,dependency_status,
612: date_of_birth,current_ssn,last_name,middle_initial
613: FROM igf_ap_isir_matched_all
614: WHERE base_id = p_base_id
615: AND payment_isir = 'Y'
616: AND system_record_type = 'ORIGINAL';
617:

Line 961: FROM igf_ap_isir_matched_all

957:
958: CURSOR cur_isir_info (p_base_id NUMBER) IS
959: SELECT payment_isir,transaction_num,dependency_status,
960: date_of_birth,current_ssn,last_name,middle_initial
961: FROM igf_ap_isir_matched_all
962: WHERE base_id = p_base_id
963: AND payment_isir = 'Y'
964: AND system_record_type = 'ORIGINAL';
965:

Line 1152: FROM IGF_AP_ISIR_MATCHED_ALL isir

1148: rec_attending_entity cur_attending_entity%ROWTYPE;
1149:
1150: CURSOR cur_pymnt_isir ( cp_base_id igf_gr_rfms.base_id%TYPE ) IS
1151: SELECT isir.transaction_num
1152: FROM IGF_AP_ISIR_MATCHED_ALL isir
1153: WHERE isir.base_id = cp_base_id
1154: AND isir.payment_isir = 'Y'
1155: AND isir.system_record_type = 'ORIGINAL';
1156: cur_pymnt_isir_rec cur_pymnt_isir%rowtype;